-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Environment:QA
-
Module:ACA - 2017
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
1.Login to LB with Partner.
2.Edit company say 'ACA Automation'.
3.Add new employee.
4.Make sure employee is eligible to ACA plan.
5.Upload the time sheet of the employee [As for first 3 months as Full time and from April as Part time]
6.Add Measurement & stability, New Hire rules.
7.From UI change employee type to Part-time from 04/01/2016.
8.Verify 1095-C report.
Actual: 1J and 2B code reflected for entire year
Expected:1J and 2F code should reflect for Jan, Feb and Mar and 1J and 2B code should reflect for rest of months.
Concern: 2B code is not reflecting correctly on 1095-C report.
Cause: When Measurement and stability rules are set and time sheet is also loaded,employee data is dumped in ACAEmployeeData Table.OES_UDF_ACAEmployeeData UDF gives data from ACAEmployeeData table if that employee is present or else it gives data from Employee table.Due to missing brackets between AND and OR, one condtion was getting overwritten. So the UDF was giving combined data of that employee from timesheet and demographics.
Correction: Added brackets in the condition.
Ramya Tantry (Inactive)
added a comment - Concern : 2B code is not reflecting correctly on 1095-C report.
Cause : When Measurement and stability rules are set and time sheet is also loaded,employee data is dumped in ACAEmployeeData Table.OES_UDF_ACAEmployeeData UDF gives data from ACAEmployeeData table if that employee is present or else it gives data from Employee table.Due to missing brackets between AND and OR, one condtion was getting overwritten. So the UDF was giving combined data of that employee from timesheet and demographics.
Correction : Added brackets in the condition. Please verify.
Ramya Tantry (Inactive)
added a comment - Smita Pawar
Please verify. We have verified above mentioned issue on LB company [ACA Automation].
Its working fine.
Scenarios verified are as follows.
1.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 3 Months
2.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 12 Months.
3.Checked Time sheet functionality is working correctly or not
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on LB company [ACA Automation] .
Its working fine.
Scenarios verified are as follows.
1.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 3 Months
2.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 12 Months.
3.Checked Time sheet functionality is working correctly or not
This issue is due to enhancement WT_ 2629
Smita Pawar (Inactive)
added a comment - This issue is due to enhancement WT_ 2629 We have verified above mentioned issue on Stage company [ACA Automation],
Attaching scree shot of verified employee.
Fix is ready for production but we will move this fix with enhancement WT-2629
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on Stage company [ACA Automation] ,
Attaching scree shot of verified employee.
Fix is ready for production but we will move this fix with enhancement WT-2629 We have verified above mentioned issue on Production [For ACA BSG Test ACAAutomation].
Its working fine.
PFA screen shot for additional information
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on Production [For ACA BSG Test ACAAutomation] .
Its working fine.
PFA screen shot for additional information 
Files Affected:
Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_ACAEmployeeData.sql