Sachin Hingole

CONCERN :
Health Tier Changed in Feb Month coverage record is not reflecting on feb change file when there is exist another new one enrollement record with different effective date .

CAUSE :
Taking last enrollment record as per current system datetimestamp but effective date is not falling of exporting change file month

Ex:
There are 3 records of enrollemt for the employee id 821 as below

1.Enrollment ID: 16546
Effective Date: 2016-01-01 00:00:00
Termination Date : 2016-01-31 00:00:00
DateTimeStamp : 2016-02-08 07:10:27.817
Coverage String : 1~821~0|3~892~0

2.Enrollment ID : 18363
Effective Date: 2016-02-01 00:00:00
Termination Date : 2016-08-04 00:00:00
DateTimeStamp : 2016-08-10 09:17:34.370
Coverage String : 1~821~0|2~945~0|3~892~0

3.Enrollment ID : 24193
Effective Date: 2016-08-05 00:00:00
Termination Date : NULL
DateTimeStamp : 2016-08-10 09:17:34.873
Coverage String : 1~821~0|2~945~0|3~892~0|3~1223~0

Expected : Second Enrollment record on feb change file
Actual : As per implementation, System getting 3rd enrollment but due to effective month is of Aug not coming
on the change file.

CORRECTION :
For only ACA file processing , corrected the functionality such that to take last enrollment record which is falling effective date in the exporting month period.

REFERENCE :
Company Valmet_Inc
Employee ID-821
Change File-Feb Month
Health Tier is changed in feb month like E+S+C earlier E+C
DateTimeStamp Of Enrollment : 2016-08-10 09:17:34.370
Jan Full exported date-10/21/2016
Feb Change File exporting in 11/23/2016
Enrollment Effective Date : 2016-02-01 00:00:00
Enrollment Termination Date : 2016-08-04 00:00:00

Affected Files :
App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb
Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_Export_GetEmployeeDataChangeFile.StoredProcedure.sql

Note : Need to test normal non aca template change file behavior by exporting.

Mahendra Mungase Smita Pawar Yogesh Chaudhari Nandkumar Prabhakar Karlekar

Verified on LB, working fine.
Employee mentioned in above comment is exported on FEB change file for 2016.

NOTE - We have also verified non ACA template export too and it worked fine.

Verified on Stage, working fine.
Employee mentioned in above comment is exported on FEB change file for 2016.

NOTE - We have also verified non ACA template export too and it worked fine.

Verified on production, working fine.