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

ACA - 2017 City of Irvine 1095C Reports

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      City of Irvine
    • Module:
      ACA - 2017

      Attachments

        Activity

        kumar.chhajed Kumar Chhajed (Inactive) created issue -
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Field Original Value New Value
        Remaining Estimate 0.5h [ 1800 ]
        Original Estimate 0.5h [ 1800 ]
        ramya.tantry Ramya Tantry (Inactive) logged work - 23/Nov/16 10:04 AM - edited
        • Time Spent:
          0.5h
           

          Check ACA Customization.
          Set Eligibility rule set to 2016 report to EIN.
          Furnish 2016 report.
          Verify sample pdf's.
          Verify analysis report.

        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,

        We have run "2016 1095C for Irvine". Please refer latest run for verification.

        We have changed the Eligibility rule in the existing EIN in EIN classes Mapping under ACA Customization. Please confirm the same.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have run "2016 1095C for Irvine". Please refer latest run for verification. We have changed the Eligibility rule in the existing EIN in EIN classes Mapping under ACA Customization. Please confirm the same. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
        Time Spent 30h [ 108000 ]
        Worklog Id 10277 [ 10277 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 0h [ 0 ] 29.5h [ 106200 ]
        Time Spent 30h [ 108000 ] 0.5h [ 1800 ]
        Worklog Id 10277 [ 10277 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 29.5h [ 106200 ] 0h [ 0 ]
        Worklog Id 10277 [ 10277 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi all - is there anyway to run the 1095C reports with different amounts for different classes? Please see below request from Irvine.

        Is there any way for you to rerun the batch with the following corrections and send us the new batch?

        · Correct Lowest cost plan amounts

        $134.12 for EPT

        $1.92 for FT

        · Correct issue for 12-month EPT employees who are currently showing 2H in line 16 for Jan through May only and should be showing 2H for all 12 months

        · Eliminate statements for all 12-month PT division employees (excepting David Cardon and Nikki Lovenduski)

        Reviewing a batch with those corrections made would largely eliminate general group problems and allow us to focus on any other outstanding issues that will likely be more employee specific and make it easier to complete the error spreadsheet.

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi all - is there anyway to run the 1095C reports with different amounts for different classes? Please see below request from Irvine. Is there any way for you to rerun the batch with the following corrections and send us the new batch? · Correct Lowest cost plan amounts $134.12 for EPT $1.92 for FT · Correct issue for 12-month EPT employees who are currently showing 2H in line 16 for Jan through May only and should be showing 2H for all 12 months · Eliminate statements for all 12-month PT division employees (excepting David Cardon and Nikki Lovenduski) Reviewing a batch with those corrections made would largely eliminate general group problems and allow us to focus on any other outstanding issues that will likely be more employee specific and make it easier to complete the error spreadsheet.
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Kumar Chhajed [ kumar.chhajed ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Kumar Chhajed [ kumar.chhajed ] Ramya Tantry [ ramya.tantry ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Original Estimate 0.5h [ 1800 ] 6h [ 21600 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 0h [ 0 ] 5.5h [ 19800 ]
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,

        Lowest Cost Amounts
        We need to do additional coding to handle class wise cost requests.

        We need information in below format for class wise cost requests

        Class1 Class2 Monthly cost

        Please provide exact classes which are to be considered under FT and EPT.

        EPT employees
        We observed that for some employees rate type is set from June but Current rate is not set,so safe harbor cost is coming up as 0.Hence, 2H is not displayed.

        When rate type is set,we consider current rate for rate of pay calculation.If Rate type is not set then we consider gross annual salary.

        Please set current rate for such employees or should gross annual salary be considered in case where rate type is given but current rate is not given?

        PT Employees:
        Statements are generated as per eligibility rule set on 1095C report. Please select specific class and criteria for which reports are to be generated.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Lowest Cost Amounts We need to do additional coding to handle class wise cost requests. We need information in below format for class wise cost requests Class1 Class2 Monthly cost Please provide exact classes which are to be considered under FT and EPT. EPT employees We observed that for some employees rate type is set from June but Current rate is not set,so safe harbor cost is coming up as 0.Hence, 2H is not displayed. When rate type is set,we consider current rate for rate of pay calculation.If Rate type is not set then we consider gross annual salary. Please set current rate for such employees or should gross annual salary be considered in case where rate type is given but current rate is not given? PT Employees: Statements are generated as per eligibility rule set on 1095C report. Please select specific class and criteria for which reports are to be generated. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        ramya.tantry Ramya Tantry (Inactive) logged work - 02/Dec/16 08:53 AM
        • Time Spent:
          3h
           

          Analysis

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 5.5h [ 19800 ] 2.5h [ 9000 ]
        Time Spent 0.5h [ 1800 ] 3.5h [ 12600 ]
        Worklog Id 11242 [ 11242 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
        Hide
        pfiedler peggy fiedler (Inactive) added a comment -

        If we eliminate PT class what happens if EE was FT Jan-March and PT Apr-Dec?

        Show
        pfiedler peggy fiedler (Inactive) added a comment - If we eliminate PT class what happens if EE was FT Jan-March and PT Apr-Dec?
        Hide
        pfiedler peggy fiedler (Inactive) added a comment -
        Show
        pfiedler peggy fiedler (Inactive) added a comment - Ramya Tantry
        Hide
        pfiedler peggy fiedler (Inactive) added a comment -

        $134.12 – EPT and RPT

        $1.92 - ASAP, CONF, CONFEX, ICEA, IPA, IPASGT, IPEA, IPEAEX, IPMA, MGMT, NORP

        Show
        pfiedler peggy fiedler (Inactive) added a comment - $134.12 – EPT and RPT $1.92 - ASAP, CONF, CONFEX, ICEA, IPA, IPASGT, IPEA, IPEAEX, IPMA, MGMT, NORP
        Hide
        pfiedler peggy fiedler (Inactive) added a comment -

        This needs to be ran today as there due date for errors is Friday - Samir

        Show
        pfiedler peggy fiedler (Inactive) added a comment - This needs to be ran today as there due date for errors is Friday - Samir
        pfiedler peggy fiedler (Inactive) made changes -
        Priority Medium [ 3 ] Highest [ 1 ]
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        peggy fiedler

        We check the eligibility of an employee for every month as per the eligibility rule.So if PT is eliminated in eligibility rule and EE was FT from Jan-March ,then EE will come up in report as he was FT and appropriate codes will be displayed for those months.

        Please select specific class and criteria for which reports are to be generated.

        We did additional coding for setting lowest cost amounts as per classes for this company.
        We have run "2016 1095C for Irvine" report.Please refer to latest run for verification.

        CC : Jennifer Leugers,Nandkumar Prabhakar Karlekar,Sachin Hingole,Samir

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - peggy fiedler We check the eligibility of an employee for every month as per the eligibility rule.So if PT is eliminated in eligibility rule and EE was FT from Jan-March ,then EE will come up in report as he was FT and appropriate codes will be displayed for those months. Please select specific class and criteria for which reports are to be generated. We did additional coding for setting lowest cost amounts as per classes for this company. We have run "2016 1095C for Irvine" report.Please refer to latest run for verification. CC : Jennifer Leugers , Nandkumar Prabhakar Karlekar , Sachin Hingole , Samir
        ramya.tantry Ramya Tantry (Inactive) logged work - 09/Dec/16 12:35 PM
        • Time Spent:
          1.25h
           

          Coding for classwise costs and safe harbor.
          discussion
          furnish 1095C report
          verification

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 2.5h [ 9000 ] 1.25h [ 4500 ]
        Time Spent 3.5h [ 12600 ] 4.75h [ 17100 ]
        Worklog Id 12329 [ 12329 ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi all - I updated the customization on this group and as I'm out of the office until Wednesday, could you please re-run these? Thanks!

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi all - I updated the customization on this group and as I'm out of the office until Wednesday, could you please re-run these? Thanks!
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,

        We have re-run the report "2016 1095C for Irvine". Please refer latest run for verification.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have re-run the report "2016 1095C for Irvine". Please refer latest run for verification. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 1.25h [ 4500 ] 0.25h [ 900 ]
        Time Spent 4.75h [ 17100 ] 5.75h [ 20700 ]
        Worklog Id 15133 [ 15133 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
        ramya.tantry Ramya Tantry (Inactive) logged work - 23/Dec/16 05:23 PM
        • Time Spent:
          1h
           

          Set eligibility rule in EIN
          Furnish 1095C report.
          Verify analysis report.
          Draft reply.

        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Could you please re-run this group tonight? I've run out of time today!

        Show
        jennifer.leugers Jennifer Leugers added a comment - Could you please re-run this group tonight? I've run out of time today!
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,

        We have re-run the report "2016 1095C for Irvine". Please refer latest run for verification.

        CC: Nandkumar Prabhakar Karlekar,Sachin Hingole,Smita Pawar

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have re-run the report "2016 1095C for Irvine". Please refer latest run for verification. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole , Smita Pawar
        ramya.tantry Ramya Tantry (Inactive) logged work - 10/Jan/17 05:34 AM
        • Time Spent:
          1.5h
           

          analysis
          report furnish
          Verify analysis report
          draft reply

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
        Time Spent 5.75h [ 20700 ] 7.25h [ 26100 ]
        Worklog Id 18156 [ 18156 ]
        cathleen.harrington@ebsbenefits.com Cathleen Harrington (Inactive) made changes -
        Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
        cathleen.harrington@ebsbenefits.com Cathleen Harrington (Inactive) made changes -
        Resolution Done [ 10000 ]
        Status Open [ 1 ] Resolved [ 5 ]
        satyap Satya made changes -
        Environment_New Production [ 18442 ]
        Transition Time In Source Status Execution Times
        Ramya Tantry (Inactive) made transition -
        Waiting for Customer Input In Progress
        29d 18h 17m 1
        Ramya Tantry (Inactive) made transition -
        In Progress Open
        59m 48s 1
        Ramya Tantry (Inactive) made transition -
        Open Waiting for Customer Input
        1h 6m 2
        Cathleen Harrington (Inactive) made transition -
        Waiting for Customer Input Open
        53d 14h 20m 1
        Cathleen Harrington (Inactive) made transition -
        Open Resolved
        8s 1

          People

          Assignee:
          jennifer.leugers Jennifer Leugers
          Reporter:
          kumar.chhajed Kumar Chhajed (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          5 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 6h Original Estimate - 6h
              6h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 7.25h
              7.25h