-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Environment:QA
-
Module:ACA
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Company - ACAAutomation
EE SSN - 300000174
Dep SSN - 300000191
Template - ACA Correction 1095 C Part III EmpID Dependent
1095 C- 1095C 27Dec16 223
Step To Repro -
1.Login to application
2.Add new employee + child
3.Enrolled into medical plan - WT_4579
4.Now run 1095C
5.Import dependent code correction
6.Edit 95C and select "Apply User Correction" - Yes
7.Click on "Save and Run"
Actual - same dependent record repeat
Expected - It should display only one record
Screen Shot - Repeat_Dependent_Displayed_On_95C.jpg
- causes
-
WT-4579 Import Corrected 1095C Code into system
-
- Closed
-
Concern:Same dependent displayed multiple times on 95C
Cause:As per earlier implementation, we have considered total 18 covered individual.But we changed this implementation as we were not able to maintain sequence number while importing and also we removed the blank records from covered individual table. While merging the code,we consider only EmployeeId and sequence no. Now since only Dependent codes are imported,Its internal sequence number comes to be 1.
This employee and child is already enrolled in plan so originally he comes up with sequence number 1 and 2 respectively. Due to the join condition in merge, the details of employee is updated with correction data of child.
Correction: We have removed sequence number and added mermberid and membertypeid while merging.We are updating the sequence number at the last after all data is merged.
Please verify the same scenario from ACA 1095C corrections screen
Also verify WT-6332 scenario as we removed mermberid and membertypeid from join condition to resolve this issue.
Note: As per changes done for WT-4970, we are merging Correction covered individual with original covered individual table.
For .eg.: If EE and or dependents is already covered for a month and data is imported in such a way that it shows uncovered for that month,we are not allowing this.
Ramya Tantry (Inactive)
added a comment - Concern :Same dependent displayed multiple times on 95C
Cause :As per earlier implementation, we have considered total 18 covered individual.But we changed this implementation as we were not able to maintain sequence number while importing and also we removed the blank records from covered individual table. While merging the code,we consider only EmployeeId and sequence no. Now since only Dependent codes are imported,Its internal sequence number comes to be 1.
This employee and child is already enrolled in plan so originally he comes up with sequence number 1 and 2 respectively. Due to the join condition in merge, the details of employee is updated with correction data of child.
Correction : We have removed sequence number and added mermberid and membertypeid while merging.We are updating the sequence number at the last after all data is merged.
Please verify the same scenario from ACA 1095C corrections screen
Also verify WT-6332 scenario as we removed mermberid and membertypeid from join condition to resolve this issue.
Note: As per changes done for WT-4970 , we are merging Correction covered individual with original covered individual table.
For .eg.: If EE and or dependents is already covered for a month and data is imported in such a way that it shows uncovered for that month,we are not allowing this.
We have verified above mentioned issue on LB company. Its working fine.
PFA screen shot of verified employee.
Tested scenarios are as follows.
1.Checked whether employee details are reflected on 1095-C PDF.
2.Checked whether employee's dependents are not displaying twice
3.Checked whether covered individual box is checked
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on LB company. Its working fine.
PFA screen shot of verified employee.
Tested scenarios are as follows.
1.Checked whether employee details are reflected on 1095-C PDF.
2.Checked whether employee's dependents are not displaying twice
3.Checked whether covered individual box is checked We have verified above mentioned issue on Production company. Its working fine.
PFA screen shot of verified employee.
T
ested scenarios are as follows.
1.Checked whether employee details are reflected on 1095-C PDF.
2.Checked whether employee's dependents are not displaying twice
3.Checked whether covered individual box is checked
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on Production company. Its working fine.
PFA screen shot of verified employee.
T
ested scenarios are as follows.
1.Checked whether employee details are reflected on 1095-C PDF.
2.Checked whether employee's dependents are not displaying twice
3.Checked whether covered individual box is checked 
Files Affected:
Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql