Files Affected:

Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

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

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