Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Changes done so far in 1095C :-
      1. Employees hired after 12/01/2015 but before 12/31/2015 should be considered in IRS.
      2. Employees whose status is cobra or retired but are having benefits in 2015 should be considered in IRS.
      3. Update endate of plans,subrates and credit pools.
      4. Employees are ineligible but still enrolled in that ineligible plan
      5. Set end date in wef to end of emonth if other offer is present from next day
      6. Use minimum employment date as start date in wef if their effective date is less than employment date
      7. Set status as part time of those employees who are cobra or retired but are having benefits in 2015
      8. Update status as part time of those employees who are terminated(after term month,remaining months are set as part time)
      9. If plan start date is after months start date, then the plan should be ineligible for whole month for the employee
      10.If EE lowest cost is given, then same should be displayed as cost even if multiple subrates for the plan is mapped.
      11. Update ispartiallyenrolled as 1 for Employees whose enrollment is continuous but in transition.
      12. Consider only ACA plans of the selected list in report customization.
      13. If two subrates are eligible in amonth,then only latest subrate cost should be used.
      14. Percentage of salary changes. Percenatge of salary is used as plan cost
      15. If Employee has waived the benefit while in Limited Non assessment period (winthin 3 months),then according codes should be seen from that month.
      16. Employees who are hired and terminated in same month should not display 1H-2D for the months in which they were not hired.
      17. Use effective date for benefit as per new hire rules on Company information if employee is new hire.
      18. Use Plandesign minimum value by default.
      19. If Employee is not hired in that month,then2I will not be populated for that month for that employee.
      20. Cobra reporting and retiree reporting.
      21. Set code as 1G for Employees whose status is cobra or retired but are having benefits in 2015
      22. If 1G is displayed for atleast single month,all 12 months will show as 1G
      23. If 1G is displayed,line 16 will be blank.
      24. If 2A is on line 16,line 14 will be 1H.
      25. If line 14 has 1H and line 16 contains 2G,2F,2H, Line 16 will be set to blank for those months where 2F/G/H appears. Same case with 1F.
      26. Delete all employees from the report who have 1H and 2A for all 12 months
      27. Covered Individual part will be unmarked for the months where 1H and 2A is shown.
      28. 1I will not be displayed if line 16 contains 2A.
      29. Self insured plan will be considered for Part 3.
      30. If EElowest cost is set,only this cost will be considered for further calculations.

      Files affected:

      • 02_UDFs/dbo.OES_UDF_ACA_IsMinimumValue.sql
      • 02_UDFs/dbo.OES_UDF_ACAEmployeeData.sql
      • 03_Views/dbo.OES_VIEW_ACA_EmployeeNewHireDates.sql
      • 04_Stored Procedures/dbo.OES_SP_ACA_UpdateWEFEmployeeEligibility.StoredProcedure.sql
      • 04_Stored Procedures/dbo.OES_SP_Get_ACAEmployeeStatusInfoMonthly.StoredProcedure.sql
      • 04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095BData.StoredProcedure.sql
      • 04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

        Attachments

          Activity

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

          Please verify the above changes.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Please verify the above changes.
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          As QA team is busy on Correction and Replacement hence put this JIRA on HOLD.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - As QA team is busy on Correction and Replacement hence put this JIRA on HOLD.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified point no. 23 on LB. Its working fine.
          Attaching screenshot for additional information.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified point no. 23 on LB. Its working fine. Attaching screenshot for additional information.
          Hide
          mahendra.mungase Mahendra Mungase (Inactive) added a comment -

          We are working on Production support task.Hence keeping this ticket on hold

          Show
          mahendra.mungase Mahendra Mungase (Inactive) added a comment - We are working on Production support task.Hence keeping this ticket on hold
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified below points on LB, working fine.

          29. Self insured plan will be considered for Part 3.

          • If employee is enrolled in self insured for 1st few months and then enrolled in fully insured plan then it should refelect it i PDF

          12. Consider only ACA plans of the selected list in report customization.

          30. If EElowest cost is set,only this cost will be considered for further calculations.
          OR
          10.If EE lowest cost is given, then same should be displayed as cost even if multiple subrates for the plan is mapped.

          • If Plan has 2 or more Sub Rates and is eligible to both rates and ACA customization has cost set then it should show costs set on ACA customizations on PDF
          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified below points on LB, working fine. 29. Self insured plan will be considered for Part 3. If employee is enrolled in self insured for 1st few months and then enrolled in fully insured plan then it should refelect it i PDF 12. Consider only ACA plans of the selected list in report customization. 30. If EElowest cost is set,only this cost will be considered for further calculations. OR 10.If EE lowest cost is given, then same should be displayed as cost even if multiple subrates for the plan is mapped. If Plan has 2 or more Sub Rates and is eligible to both rates and ACA customization has cost set then it should show costs set on ACA customizations on PDF
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified below points on LB and working fine

          3. Update end date of plans,sub rates and credit pools.

          • It should consider end dates set on plans and accordingly should show the codes or costs on PDF

          20. Cobra reporting and retiree reporting.

          • Already terminated employee eligible for COBRA plan then it should show 1095C PDF with 1H 2A from the month from which employee is terminated

          21. Set code as 1G for Employees whose status is cobra or retired but are having benefits in 2015
          22. If 1G is displayed for atleast single month,all 12 months will show as 1G

          2. Employees whose status is cobra or retired but are having benefits in 2015 should be considered in IRS.

          7. Set status as part time of those employees who are cobra or retired but are having benefits in 2015

          18. Use Plandesign minimum value by default.

          14. Percentage of salary changes. Percentage of salary is used as plan cost

          4. Employees are ineligible but still enrolled in that ineligible plan

          16. Employees who are hired and terminated in same month should not display 1H-2D for the months in which they were not hired.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified below points on LB and working fine 3. Update end date of plans,sub rates and credit pools. It should consider end dates set on plans and accordingly should show the codes or costs on PDF 20. Cobra reporting and retiree reporting. Already terminated employee eligible for COBRA plan then it should show 1095C PDF with 1H 2A from the month from which employee is terminated 21. Set code as 1G for Employees whose status is cobra or retired but are having benefits in 2015 22. If 1G is displayed for atleast single month,all 12 months will show as 1G 2. Employees whose status is cobra or retired but are having benefits in 2015 should be considered in IRS. 7. Set status as part time of those employees who are cobra or retired but are having benefits in 2015 18. Use Plandesign minimum value by default. 14. Percentage of salary changes. Percentage of salary is used as plan cost 4. Employees are ineligible but still enrolled in that ineligible plan 16. Employees who are hired and terminated in same month should not display 1H-2D for the months in which they were not hired.

            People

            Assignee:
            sachin.hingole Sachin Hingole (Inactive)
            Reporter:
            ramya.tantry Ramya Tantry (Inactive)
            Developer:
            Ramya Tantry (Inactive)
            QA:
            Sachin Hingole (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Pre-Prod Due Date: