[WT-6604] ACA : Health Tier Changed in Feb Month coverage record is not reflecting on feb change file. - Workterra Jira

Details

Type: Bug
Status: Production Complete
Priority: Critical
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
Issue Importance:
Must Have

Description

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 .

Attachments

Activity

Ascending order - Click to sort in descending order

Revansiddha Gaur (Inactive) created issue - 23/Nov/16 07:55 AM

Revansiddha Gaur (Inactive) made changes - 23/Nov/16 07:55 AM

Field	Original Value	New Value
Assignee	Nandkumar [ satyap ]	Revansiddha Gaur [ revansiddha.gaur ]

Revansiddha Gaur (Inactive) made changes - 23/Nov/16 01:49 PM

Remaining Estimate		20h [ 72000 ]
Original Estimate		20h [ 72000 ]

Permalink

Revansiddha Gaur (Inactive) logged work - 23/Nov/16 01:54 PM

Time Spent:

4.5h

Cause findout ,Coding,Discussion with nandkumar about issue.

Revansiddha Gaur (Inactive) made changes - 23/Nov/16 01:55 PM

Remaining Estimate	20h [ 72000 ]	15.5h [ 55800 ]
Time Spent		4.5h [ 16200 ]
Worklog Id	10331 [ 10331 ]

Revansiddha Gaur (Inactive) made changes - 24/Nov/16 06:27 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Revansiddha Gaur (Inactive) made changes - 24/Nov/16 06:27 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Hide

Permalink

Revansiddha Gaur (Inactive) added a comment - 24/Nov/16 06:37 AM - edited

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

Show

Revansiddha Gaur (Inactive) added a comment - 24/Nov/16 06:37 AM - edited 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

Permalink

Revansiddha Gaur (Inactive) logged work - 24/Nov/16 06:38 AM

Time Spent:

2h

Coding,Unit testing,Patches creation,Review Ticket Creation,3C updation.

Revansiddha Gaur (Inactive) made changes - 24/Nov/16 06:39 AM

Remaining Estimate	15.5h [ 55800 ]	13.5h [ 48600 ]
Time Spent	4.5h [ 16200 ]	6.5h [ 23400 ]
Worklog Id	10350 [ 10350 ]

Permalink

Revansiddha Gaur (Inactive) logged work - 24/Nov/16 08:33 AM

Time Spent:

0.5h

Found changes while code Review,Code modification,LB Checkins with trunk.

Revansiddha Gaur (Inactive) made changes - 24/Nov/16 08:35 AM

Remaining Estimate	13.5h [ 48600 ]	13h [ 46800 ]
Time Spent	6.5h [ 23400 ]	7h [ 25200 ]
Worklog Id	10355 [ 10355 ]

Khandu Kshirsagar (Inactive) made changes - 24/Nov/16 11:29 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Revansiddha Gaur (Inactive) made changes - 25/Nov/16 05:20 AM

Assignee

Revansiddha Gaur [ revansiddha.gaur ]

Sachin Hingole [ sachin.hingole ]

Revansiddha Gaur (Inactive) made changes - 25/Nov/16 05:20 AM

Code Review Date		24/Nov/2016
Code Reviewed By		Nandkumar Karlekar [ 11904 ]

Sachin Hingole (Inactive) made changes - 25/Nov/16 05:20 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 25/Nov/16 05:20 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Sachin Hingole (Inactive) made changes - 25/Nov/16 06:08 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Permalink

Sachin Hingole (Inactive) logged work - 25/Nov/16 06:09 AM

Time Spent:

1h

<No comment>

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 25/Nov/16 06:09 AM - edited

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.

Show

Sachin Hingole (Inactive) added a comment - 25/Nov/16 06:09 AM - edited 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.

Sachin Hingole (Inactive) made changes - 25/Nov/16 06:09 AM

Remaining Estimate	13h [ 46800 ]	12h [ 43200 ]
Time Spent	7h [ 25200 ]	8h [ 28800 ]
Worklog Id	10461 [ 10461 ]

Permalink

Revansiddha Gaur (Inactive) logged work - 28/Nov/16 07:04 AM

Time Spent:

0.5h

code checkins

Revansiddha Gaur (Inactive) made changes - 28/Nov/16 07:05 AM

Remaining Estimate	12h [ 43200 ]	11.5h [ 41400 ]
Time Spent	8h [ 28800 ]	8.5h [ 30600 ]
Worklog Id	10544 [ 10544 ]

Khandu Kshirsagar (Inactive) made changes - 28/Nov/16 07:45 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Sachin Hingole (Inactive) made changes - 28/Nov/16 10:00 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 28/Nov/16 10:00 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Permalink

Sachin Hingole (Inactive) logged work - 28/Nov/16 10:08 AM

Time Spent:

1h

<No comment>

Sachin Hingole (Inactive) made changes - 28/Nov/16 10:08 AM

Remaining Estimate	11.5h [ 41400 ]	10.5h [ 37800 ]
Time Spent	8.5h [ 30600 ]	9.5h [ 34200 ]
Worklog Id	10588 [ 10588 ]

Sachin Hingole (Inactive) made changes - 28/Nov/16 10:08 AM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 28/Nov/16 10:10 AM

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.

Show

Sachin Hingole (Inactive) added a comment - 28/Nov/16 10:10 AM 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.

Permalink

Revansiddha Gaur (Inactive) logged work - 30/Nov/16 04:12 AM

Time Spent:

20m

Production code checkins

Revansiddha Gaur (Inactive) made changes - 30/Nov/16 04:12 AM

Remaining Estimate	10.5h [ 37800 ]	10h 10m [ 36600 ]
Time Spent	9.5h [ 34200 ]	9h 50m [ 35400 ]
Worklog Id	10770 [ 10770 ]

Ashwin Wankhede (Inactive) made changes - 30/Nov/16 06:28 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Sachin Hingole (Inactive) made changes - 02/Dec/16 06:40 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Sachin Hingole (Inactive) made changes - 02/Dec/16 06:40 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Permalink

Sachin Hingole (Inactive) logged work - 02/Dec/16 07:16 AM

Time Spent:

0.5h

<No comment>

Sachin Hingole (Inactive) made changes - 02/Dec/16 07:16 AM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 02/Dec/16 07:16 AM

Verified on production, working fine.

Show

Sachin Hingole (Inactive) added a comment - 02/Dec/16 07:16 AM Verified on production, working fine.

Sachin Hingole (Inactive) made changes - 02/Dec/16 07:16 AM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Sachin Hingole (Inactive) made changes - 02/Dec/16 07:16 AM

Remaining Estimate	10h 10m [ 36600 ]	9h 40m [ 34800 ]
Time Spent	9h 50m [ 35400 ]	10h 20m [ 37200 ]
Worklog Id	11231 [ 11231 ]

Satya made changes - 04/Nov/17 06:19 AM

Environment_New

LB [ 18444 ]

Transition	Time In Source Status	Execution Times

Revansiddha Gaur (Inactive) made transition - 24/Nov/16 06:27 AM

Open

In Development

22h 32m

Sachin Hingole (Inactive) made transition - 25/Nov/16 05:20 AM

In Development

In LB Testing

22h 53m

Sachin Hingole (Inactive) made transition - 28/Nov/16 10:00 AM

In LB Testing

Stage Testing

3d 4h 39m

Sachin Hingole (Inactive) made transition - 02/Dec/16 06:40 AM

Stage Testing

In Production Testing

3d 20h 40m

Sachin Hingole (Inactive) made transition - 02/Dec/16 07:16 AM

In Production Testing

Production Complete

35m 51s

People

Assignee:: Sachin Hingole (Inactive)

Reporter:: Revansiddha Gaur (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 23/Nov/16 07:55 AM

Updated:: 04/Nov/17 06:19 AM

Resolved:: 02/Dec/16 07:16 AM

Code Review Date:: 24/Nov/2016

Time Tracking

Estimated:

20h

Remaining:

9h 40m

Logged:

10h 20m