Affected files :
D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_1_Export_WaivedEnrollment.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_Employee_Enrollment_Intermediate_Waive.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_ExportProcessedEventData.StoredProcedure.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_EligibilityForExport.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_Employee_Enrollment_Waive.sql

Test scenarios to test this enhancement.

1.Check offer & eligibility segments are reflecting correctly when employee is terminated on first day of the month.
2.Check offer & eligibility segments are reflecting correctly when employee is terminated on last day of the month.
3.Check offer & eligibility segments are reflecting correctly when employee is terminated on mid month.
4.Check whether other elements are not getting impacted
5.Waive records are coming properly after deleting run rate maintenance.

We have verified above change request on LB [ACA Automation] company.
Scenarios which are working fine are as follows
1.Waive records are coming properly after deleting run rate maintenance.
2.Checked whether entire Eligibility & Offer segments are not blank.

Issues observed are as follows.
1.'Child supplemental life' displayed in Eligibility segment even though this plan is not eligible for employee
2.Termination date is not got populated for employee who was terminated in Mar 03/15/2017.
3.Other eligible plans not displayed in Eligibility segment

Attaching files for month of Jan,Feb and March months file.
Test Employees used with SSN
1.147147147
2.148148148
3.149149149

Hi @smita,
With reference to above comment & in person discussion with you the details of scenario as below...

Used Template- Cloned Sachin BSG including waive template.

File-
Jan - COID_NETSECUREID_BenefitsImport__20170530_171919_21762063853.txt
Feb - COID_NETSECUREID_BenefitsImport__20170530_172033_34307643853.txt
Mar - COID_NETSECUREID_BenefitsImport__20170530_175800_01644902653.txt

Test Scenario :1.'Child supplemental life' displayed in Eligibility segment even though this plan is not eligible for employee
Expected: Should not be pulled on the file on Jan file for the employee ssn-147147147 as he is not eligible when checked on
ui by raising qualifying event of 1/1/2017.

Actual : Found on the file in 'ELIG' element.

Test: Fail

----------------------------------

Test Scenario : 2. Termination date is not got populated for employee who was terminated in Mar 03/15/2017.

Expected : Should be pulled out on the Jan file for the employee ssn- 148148148 in 'COVG' section with termination date
as 03/15/2017.

Actual : Reflected termination date as blank.

Test Scenario : 3. Other eligible plans not displayed in Eligibility segment

Expected : 'ACA plan for 7220' this plan should be displayed in eligibility section.[Jan file]
Actual : Not reflected 'ACA plan for 7220' the plan in elig section for the below employees-
1. 148148148
2. 147147147
3. 149149149

Thanks,
Revan

Nandkumar Prabhakar Karlekar Sachin Hingole

Hi Smita Pawar,

One request that please report the issue with precise details as above in future. So that it will help in understanding & resolve the issue in minumal time & even after long duration we can get to know clear picture of the issue.

Thanks,
Revan

Nandkumar Prabhakar Karlekar Sachin Hingole

As we discussed,Please check patch is already deployed. and confirm.

Thanks,
Revan

We have verified above mentioned issue on LB.
Its working fine. Similarly we are delivering metso files to client.

As this change request is linked with WT-9760 and other metso enhancement.
We will test this Jira when all metso related functionality will get deployed on code mapp

We have verified above mentioned issue on LB, stage and Production.
Its working fine. Now there are no mid month termination records are reflecting on full and change file.
We have delivered Full and change files for Metso 2017.
Hence closing this ticket.