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

          ramya.tantry Ramya Tantry (Inactive) created issue -
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Field Original Value New Value
          Assignee Nandkumar [ satyap ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Developer Ramya Tantry [ ramya.tantry ]
          QA Sachin Hingole [ sachin.hingole ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment 1G.png [ 18719 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Stage Due Date 29/Jun/16 [ 2016-06-29 ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Issue Category EBS [ 10350 ] Harbinger [ 10700 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]

            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: