-
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
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
Please verify the above changes.