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

ACA - 2017 MATT Construction 1095C Reports

    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 Report
    • Reported by:
      Support
    • Company:
      MATT Construction
    • Module:
      ACA - 2017

      Attachments

        Activity

        mahendra.mungase Mahendra Mungase (Inactive) created issue -
        mahendra.mungase Mahendra Mungase (Inactive) made changes -
        Field Original Value New Value
        Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
        jennifer.leugers Jennifer Leugers made changes -
        Attachment screenshot-1.png [ 34919 ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Getting a server error when I try to run the reports
        Kristi Smith FYI

        Show
        jennifer.leugers Jennifer Leugers added a comment - Getting a server error when I try to run the reports Kristi Smith FYI
        Hide
        sachin.hingole Sachin Hingole (Inactive) added a comment -

        Hi Jennifer Leugers, Kristi Smith,

        We are able to run report "2016 1095C for Matt" by removing "Legal first name" field from order by list.
        Please refer the latest run for reference.

        Development team will look into this problem,
        till then you can run "2016 1095C for Matt" without adding "Legal first name" field in order by list.

        Thanks,
        Sachin Hingole

        shyam sharma Nandkumar Prabhakar Karlekar Abhijeet Khandagale Mahendra Mungase Rakesh Roy

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers , Kristi Smith , We are able to run report "2016 1095C for Matt" by removing "Legal first name" field from order by list. Please refer the latest run for reference. Development team will look into this problem, till then you can run "2016 1095C for Matt" without adding "Legal first name" field in order by list. Thanks, Sachin Hingole shyam sharma Nandkumar Prabhakar Karlekar Abhijeet Khandagale Mahendra Mungase Rakesh Roy
        sachin.hingole Sachin Hingole (Inactive) logged work - 13/Dec/16 07:05 AM
        • Time Spent:
          1h
           
          <No comment>
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Remaining Estimate 14h [ 50400 ]
        Original Estimate 14h [ 50400 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Remaining Estimate 14h [ 50400 ] 13h [ 46800 ]
        Time Spent 1h [ 3600 ]
        Worklog Id 12658 [ 12658 ]
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,Kristi Smith,

        We have re-run "2016 1095C for Matt" adding "Legal first name" field in order by list.
        Please refer latest run for verification

        Also, I have changed the eligibility rule to "All Status Rule" in EIN Classes Mapping to match the eligibility rule set in 1095C report.

        CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Kristi Smith , We have re-run "2016 1095C for Matt" adding "Legal first name" field in order by list. Please refer latest run for verification Also, I have changed the eligibility rule to "All Status Rule" in EIN Classes Mapping to match the eligibility rule set in 1095C report. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 13h [ 46800 ] 12.5h [ 45000 ]
        Time Spent 1h [ 3600 ] 1.5h [ 5400 ]
        Worklog Id 12848 [ 12848 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Worklog Id 12848 [ 12848 ]
        ramya.tantry Ramya Tantry (Inactive) logged work - 14/Dec/16 05:48 PM - edited
        • Time Spent:
          0.5h
           

          Check ACA Customization.
          verify EIN mapping
          Set Rule to EIN
          Furnish 1095C report.
          verify Sample pdf
          verify Analysis report.

        Hide
        kristi.smith Kristi Smith (Inactive) added a comment -

        Jennifer Leugers Hi Jen, can you provide an ETA for ACA reports that I can give to MATT?

        Show
        kristi.smith Kristi Smith (Inactive) added a comment - Jennifer Leugers Hi Jen, can you provide an ETA for ACA reports that I can give to MATT?
        Hide
        cathleen.harrington@ebsbenefits.com Cathleen Harrington (Inactive) added a comment - - edited

        MATT Construction ACA;
        Please research this:
        For the column O (excel file). From what I can see it looks like anyone hired before their plan year start in July the column says January and for anyone hired on or after July 1, that column says July. Examples of those differences are Valerie Yost and Holly Wilde.
        Jennifer Leugers
        Kristi Smith

        Show
        cathleen.harrington@ebsbenefits.com Cathleen Harrington (Inactive) added a comment - - edited MATT Construction ACA; Please research this: For the column O (excel file). From what I can see it looks like anyone hired before their plan year start in July the column says January and for anyone hired on or after July 1, that column says July. Examples of those differences are Valerie Yost and Holly Wilde. Jennifer Leugers Kristi Smith
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Cathleen Harrington,

        From IRS Site :
        Plan start month: Enter the two-digit number (01 through 12) indicating the calendar month during which the plan year begins of the health plan in which the employee is offered coverage (or would be offered coverage if the employee were eligible to participate in the plan). If more than one plan year could apply (for instance, if the ALE Member changes the plan year during the year), enter the earliest applicable month. If there is no health plan under which coverage is offered to the employee, enter “00.”

        In this company,medical plan start from 07/01.
        Medical plan list:
        United Healthcare Advantage HMO - 07/01/2015 - 06/30/2016
        United Healthcare Select Plus HDHP - 07/01/2015 - 06/30/2016
        United Healthcare Select Plus PPO - 07/01/2015 - 06/30/2016
        United Healthcare Signature HMO - 07/01/2015 - 06/30/2016
        United Healthcare Full Signature HMO - 07/01/2016
        United Healthcare Narrow Advantage HMO - 07/01/2016
        United Healthcare Select Plus HDHP 2016-2017 - 07/01/2016
        United Healthcare Select Plus PPO 2016-2017 - 07/01/2016

        EE's that were hired before July were offered coverage of below plans:
        United Healthcare Advantage HMO - 07/01/2015 - 06/30/2016
        United Healthcare Select Plus HDHP - 07/01/2015 - 06/30/2016
        United Healthcare Select Plus PPO - 07/01/2015 - 06/30/2016
        United Healthcare Signature HMO - 07/01/2015 - 06/30/2016

        Earliest applicable month for these plans for this year(2016) for an employee hired before July is January

        EE's hired after July are offer coverage of below plans:
        United Healthcare Full Signature HMO - 07/01/2016
        United Healthcare Narrow Advantage HMO - 07/01/2016
        United Healthcare Select Plus HDHP 2016-2017 - 07/01/2016
        United Healthcare Select Plus PPO 2016-2017 - 07/01/2016

        These plans start from July.So earliest applicable month for these plans for this year(2016) for an employee hired after July is July.

        For plan start month the date should actually be the plan year start date. This means all Calendar year employers will have ALL 1095s populated with 01 and all fiscal should be whenever their plan year starts.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole,Jennifer Leugers,Kristi Smith

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Cathleen Harrington , From IRS Site : Plan start month: Enter the two-digit number (01 through 12) indicating the calendar month during which the plan year begins of the health plan in which the employee is offered coverage (or would be offered coverage if the employee were eligible to participate in the plan). If more than one plan year could apply (for instance, if the ALE Member changes the plan year during the year), enter the earliest applicable month. If there is no health plan under which coverage is offered to the employee, enter “00.” In this company,medical plan start from 07/01. Medical plan list: United Healthcare Advantage HMO - 07/01/2015 - 06/30/2016 United Healthcare Select Plus HDHP - 07/01/2015 - 06/30/2016 United Healthcare Select Plus PPO - 07/01/2015 - 06/30/2016 United Healthcare Signature HMO - 07/01/2015 - 06/30/2016 United Healthcare Full Signature HMO - 07/01/2016 United Healthcare Narrow Advantage HMO - 07/01/2016 United Healthcare Select Plus HDHP 2016-2017 - 07/01/2016 United Healthcare Select Plus PPO 2016-2017 - 07/01/2016 EE's that were hired before July were offered coverage of below plans: United Healthcare Advantage HMO - 07/01/2015 - 06/30/2016 United Healthcare Select Plus HDHP - 07/01/2015 - 06/30/2016 United Healthcare Select Plus PPO - 07/01/2015 - 06/30/2016 United Healthcare Signature HMO - 07/01/2015 - 06/30/2016 Earliest applicable month for these plans for this year(2016) for an employee hired before July is January EE's hired after July are offer coverage of below plans: United Healthcare Full Signature HMO - 07/01/2016 United Healthcare Narrow Advantage HMO - 07/01/2016 United Healthcare Select Plus HDHP 2016-2017 - 07/01/2016 United Healthcare Select Plus PPO 2016-2017 - 07/01/2016 These plans start from July.So earliest applicable month for these plans for this year(2016) for an employee hired after July is July. For plan start month the date should actually be the plan year start date. This means all Calendar year employers will have ALL 1095s populated with 01 and all fiscal should be whenever their plan year starts. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole , Jennifer Leugers , Kristi Smith
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 12.5h [ 45000 ] 11.5h [ 41400 ]
        Time Spent 1.5h [ 5400 ] 2.5h [ 9000 ]
        Worklog Id 14673 [ 14673 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 11.5h [ 41400 ] 11h [ 39600 ]
        Time Spent 2.5h [ 9000 ] 3h [ 10800 ]
        Worklog Id 14673 [ 14673 ]
        sachin.hingole Sachin Hingole (Inactive) logged work - 21/Dec/16 12:31 PM
        • Time Spent:
          0.5h
           
          <No comment>
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Remaining Estimate 11h [ 39600 ] 10.5h [ 37800 ]
        Time Spent 3h [ 10800 ] 3.5h [ 12600 ]
        Worklog Id 14745 [ 14745 ]
        ramya.tantry Ramya Tantry (Inactive) logged work - 21/Dec/16 06:51 PM - edited
        • Time Spent:
          1.5h
           

          Analysis of client query
          draft reply

        sachin.hingole Sachin Hingole (Inactive) logged work - 05/Jan/17 10:51 AM
        • Time Spent:
          25m
           

          Verified EIN class mapping
          Run 1095C report
          Verified analysis report

        Hide
        sachin.hingole Sachin Hingole (Inactive) added a comment -

        Hi Jennifer Leugers

        We have re-run "2016 1095C for Matt", Please refer latest run.

        Thanks,
        Sachin Hingole

        Nandkumar Prabhakar Karlekar Ramya Tantry Smita Pawar Mahendra Mungase Rakesh Roy

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers We have re-run "2016 1095C for Matt", Please refer latest run. Thanks, Sachin Hingole Nandkumar Prabhakar Karlekar Ramya Tantry Smita Pawar Mahendra Mungase Rakesh Roy
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Remaining Estimate 10.5h [ 37800 ] 10h 5m [ 36300 ]
        Time Spent 3.5h [ 12600 ] 3h 55m [ 14100 ]
        Worklog Id 17432 [ 17432 ]
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223)
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
        Hide
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

        Hello,
        Feel free to reopen in case any further action required on this. Thank you.

        Show
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hello, Feel free to reopen in case any further action required on this. Thank you.
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Resolution Done [ 10000 ]
        Status In Progress [ 3 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times
        Mahendra Mungase (Inactive) made transition -
        Open Waiting for Customer Input
        3m 8s 1
        Nandkumar Prabhakar Karlekar (Inactive) made transition -
        Waiting for Customer Input In Progress
        305d 23h 50m 1
        Nandkumar Prabhakar Karlekar (Inactive) made transition -
        In Progress Closed
        3m 50s 1

          People

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

            Dates

            Created:
            Updated:
            Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 14h
              14h
              Remaining:
              Time Spent - 3h 55m Remaining Estimate - 10h 5m
              10h 5m
              Logged:
              Time Spent - 3h 55m Remaining Estimate - 10h 5m
              3h 55m