Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-8194

ACA 2017 eSubmission - JE Dunn

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Submission
    • Reported by:
      Support
    • Company:
      JE Dunn
    • Module:
      ACA - 2017

      Attachments

        Activity

        mahendra.mungase Mahendra Mungase (Inactive) created issue -
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Field Original Value New Value
        Assignee Jennifer Leugers [ jennifer.leugers ] Kumar Chhajed [ kumar.chhajed ]
        Status Open [ 1 ] In Progress [ 3 ]
        mahendra.mungase Mahendra Mungase (Inactive) made changes -
        Remaining Estimate 15h [ 54000 ]
        Original Estimate 15h [ 54000 ]
        mahendra.mungase Mahendra Mungase (Inactive) made changes -
        Remaining Estimate 15h [ 54000 ] 13h [ 46800 ]
        Time Spent 2h [ 7200 ]
        Worklog Id 22545 [ 22545 ]
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 02/Feb/17 10:05 AM
        • Time Spent:
          2.5h
           

          Creating JIRA items
          Exporting the File to xls

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 13h [ 46800 ] 10.5h [ 37800 ]
        Time Spent 2h [ 7200 ] 4.5h [ 16200 ]
        Worklog Id 22608 [ 22608 ]
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
        Developer Revansiddha G [ 10331 ]
        QA Mahendra Mungase [ mahendra.mungase ]
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
        mahendra.mungase Mahendra Mungase (Inactive) made changes -
        Worklog Id 22545 [ 22545 ]
        mahendra.mungase Mahendra Mungase (Inactive) logged work - 03/Feb/17 07:01 AM - edited
        • Time Spent:
          2h
           

          JIRA creation for support task

        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi all - client would like to know why January is Yes and the rest of the months are No on their 1094C as well as why Active employees are showing as 1G (examples Allen, Cisper, Kaczmarek, Schilling and others).

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi all - client would like to know why January is Yes and the rest of the months are No on their 1094C as well as why Active employees are showing as 1G (examples Allen, Cisper, Kaczmarek, Schilling and others).
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Mahendra Mungase [ mahendra.mungase ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Also - please see additional comments from the client

        Employment count: Per Steve Best these counts look low. Should be closer to 3,000 (appears to be missing unions-Benefit ineligibles) please review how WT is coming up with these counts.

        Their comments: 1094C TOTALS (part III count) does it exclude Union EEs? It should include benefits ineligibles (all EEs) but they are employees of JE Dunn. When Carrie looked at the number it was missing approximately the count of some of the union EEs that are EEs but not benefit eligible. EEs are in WT.

        Show
        jennifer.leugers Jennifer Leugers added a comment - Also - please see additional comments from the client Employment count: Per Steve Best these counts look low. Should be closer to 3,000 (appears to be missing unions-Benefit ineligibles) please review how WT is coming up with these counts. Their comments: 1094C TOTALS (part III count) does it exclude Union EEs? It should include benefits ineligibles (all EEs) but they are employees of JE Dunn. When Carrie looked at the number it was missing approximately the count of some of the union EEs that are EEs but not benefit eligible. EEs are in WT.
        mahendra.mungase Mahendra Mungase (Inactive) made changes -
        Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Remaining Estimate 10.5h [ 37800 ] 9.5h [ 34200 ]
        Time Spent 4.5h [ 16200 ] 5.5h [ 19800 ]
        Worklog Id 33651 [ 33651 ]
        Hide
        smita.pawar Smita Pawar (Inactive) added a comment -

        Hi Jennifer Leugers,

        27 employees are having 1G code.Some of them are terminated in 2015 and some of them are Parttime employees.

        These employees are getting 1G code because

        Cisper Joseph ---- Part time employee and enrolled in self plan
        Kirsten P Allen ---- Part time employee and enrolled in self plan
        James M Kaczmarek ---- Part time employee and enrolled in self plan
        -------------------------------------------------------------------------------------------------------------------------
        In analysis report, excel filters can be applied to ACA 1095C Codes sheet to get following count details.

        Total EE Count:Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2E and 2A.

        EE Count with Offer to Dependents: Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2E,2A and 2D and Line 14 contains 1A,1E,1K and 1C as these codes represent offer to EE and dependents.

        FTE Count: Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2E,2A and 2D

        Action required: Apply FTE Count Filter for specific month and then select for line 14 code as 1H so these employees need to be provide the coverage to achiever the MEC Criteria. So the result should be less than 5 % of total FTE count. Please correct codes for some employees having 1H codes and reduce the percentage less than 5 %.

        So it will achieve MEC Criteria.

        FYI Nandkumar Prabhakar Karlekar,Sachin Hingole,Revansiddha Gaur,Kumar Chhajed

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , 27 employees are having 1G code.Some of them are terminated in 2015 and some of them are Parttime employees. These employees are getting 1G code because Cisper Joseph ---- Part time employee and enrolled in self plan Kirsten P Allen ---- Part time employee and enrolled in self plan James M Kaczmarek ---- Part time employee and enrolled in self plan ------------------------------------------------------------------------------------------------------------------------- In analysis report, excel filters can be applied to ACA 1095C Codes sheet to get following count details. Total EE Count:Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2E and 2A. EE Count with Offer to Dependents: Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2E,2A and 2D and Line 14 contains 1A,1E,1K and 1C as these codes represent offer to EE and dependents. FTE Count: Month-wise count of EE's who are employed for the whole month and Line 16 code does not contain 2E,2A and 2D Action required: Apply FTE Count Filter for specific month and then select for line 14 code as 1H so these employees need to be provide the coverage to achiever the MEC Criteria. So the result should be less than 5 % of total FTE count. Please correct codes for some employees having 1H codes and reduce the percentage less than 5 %. So it will achieve MEC Criteria. FYI Nandkumar Prabhakar Karlekar , Sachin Hingole , Revansiddha Gaur , Kumar Chhajed
        smita.pawar Smita Pawar (Inactive) made changes -
        Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
        revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/Mar/17 09:00 PM
        • Time Spent:
          1h
           

          Internal discussion.

        nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 01/Apr/17 12:31 AM
        • Time Spent:
          12h
           
          <No comment>
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Remaining Estimate 9.5h [ 34200 ] 0h [ 0 ]
        Time Spent 5.5h [ 19800 ] 17.5h [ 63000 ]
        Worklog Id 36580 [ 36580 ]
        Hide
        mandark Mandar Kulkarni (Inactive) added a comment -

        Hi Jennifer Leugers
        I am marking this ticket as closed for now. Feel free to reopen in case any further action expected on this. Thanks.

        -----------------------------------------------------
        CC: Vijay Siddha, Satya, Jaideep Vinchurkar

        Show
        mandark Mandar Kulkarni (Inactive) added a comment - Hi Jennifer Leugers I am marking this ticket as closed for now. Feel free to reopen in case any further action expected on this. Thanks. ----------------------------------------------------- CC: Vijay Siddha , Satya , Jaideep Vinchurkar
        mandark Mandar Kulkarni (Inactive) made changes -
        Resolution Fixed [ 1 ]
        Status In Progress [ 3 ] Resolved [ 5 ]
        mandark Mandar Kulkarni (Inactive) made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times
        Kumar Chhajed (Inactive) made transition -
        Open In Progress
        47m 55s 1
        Mandar Kulkarni (Inactive) made transition -
        In Progress Resolved
        231d 23h 31m 1
        Mandar Kulkarni (Inactive) made transition -
        Resolved Closed
        3s 1

          People

          Assignee:
          jennifer.leugers Jennifer Leugers
          Reporter:
          mahendra.mungase Mahendra Mungase (Inactive)
          Account Executive:
          Jennifer Leugers
          QA:
          Mahendra Mungase (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          6 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 15h Original Estimate - 15h
              15h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 17.5h
              17.5h