[WT-6658] ACA - Mandatory field data missing for employee on Valmet Benefit Import FEB change file - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: ACA
Labels:
None

Environment:

Production
Module:
ACA
Reported by:
Harbinger
Item State:
Production Complete - Closed
Issue Importance:
Must Have

Description

for below 5 EEs missing OFFR, ELIG, COVG data.
Below are employees from FEB change file, FEB change file is exported from Valmet production

671 Dan Lanning
715 Ronnie Steen
899 David Larry
1087 Chad Surunis
1156 Mark Tierney

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

WT-6658- Analysis.xls
10 kB
28/Nov/16 06:47 AM

Issue Links

relates to

WT-2601 BSG ACA Reporting

Closed

Activity

Ascending order - Click to sort in descending order

Permalink

Revansiddha Gaur (Inactive) logged work - 24/Nov/16 05:32 AM

Time Spent:

4h

Analysis of Issue and found the cause as below for EmployeeID -671..
Concern: Event Data & Eligibility Data not reflected on the file.
Cause : Event Data will capture only those records whose enrollment datetimestamp is greater than last full exported date.
So Last full file export date is ..2016-10-21 04:43:44.000
And Enrollment Date TimeStamp is..2016-10-02 01:08:09.517
Expected datetimestamp must be greater than Last exported date i.e. .2016-10-21 04:43:44.000 but actually its not like that. This is incorrect data

@Nandkumar, @Yogesh

Permalink

Nandkumar Prabhakar Karlekar (Inactive) logged work - 24/Nov/16 06:44 AM

Time Spent:

1h

<No comment>

Sachin Hingole (Inactive) created issue - 25/Nov/16 05:29 AM

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

Field	Original Value	New Value
Link		This issue relates to ~~WT-2601~~ [ ~~WT-2601~~ ]

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

Remaining Estimate		12h [ 43200 ]
Original Estimate		12h [ 43200 ]

Hide

Permalink

Revansiddha Gaur (Inactive) added a comment - 25/Nov/16 05:32 AM

Hi Sachin Hingole,

Please attach the problematic file in the jira.

Thanks,
Revan

Show

Revansiddha Gaur (Inactive) added a comment - 25/Nov/16 05:32 AM Hi Sachin Hingole , Please attach the problematic file in the jira. Thanks, Revan

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

Item State

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

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

Remaining Estimate	12h [ 43200 ]	8h [ 28800 ]
Time Spent		4h [ 14400 ]
Worklog Id	10457 [ 10457 ]

Permalink

Revansiddha Gaur (Inactive) logged work - 25/Nov/16 06:37 AM

Time Spent:

1h

Analysis

Ref : EmployeeID 899,715

Concern:
Blank Offer Element populated , Blank Eligibility Element populated but covg element is populated as employees are enrolled in Medical Opt-Out plan.

Cause :
Blank Eligibility element : Medical Opt-Out Plan is not an ACA Plan.

Blank Offer element : Only populated the events which are related to ACA Plans.

Correction:
As per discussion with Nandkumar & Export Team Members,
1. To populate the events on file, removal the check of IsACAPlans and refer the selected plans from the template customization.-(Implementation is needed)
2. ELIG element line should not be populated in case of required field value is not present
(Implementation is needed)

@Sachin

Permalink

Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Nov/16 06:44 AM

Time Spent:

0.5h

<No comment>

Nandkumar Prabhakar Karlekar (Inactive) made changes - 25/Nov/16 06:44 AM

Remaining Estimate	8h [ 28800 ]	7.5h [ 27000 ]
Time Spent	4h [ 14400 ]	4.5h [ 16200 ]
Worklog Id	10463 [ 10463 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 25/Nov/16 06:45 AM

Remaining Estimate	7.5h [ 27000 ]	6.5h [ 23400 ]
Time Spent	4.5h [ 16200 ]	5.5h [ 19800 ]
Worklog Id	10464 [ 10464 ]

Revansiddha Gaur (Inactive) made changes - 25/Nov/16 06:55 AM

Remaining Estimate	6.5h [ 23400 ]	5.5h [ 19800 ]
Time Spent	5.5h [ 19800 ]	6.5h [ 23400 ]
Worklog Id	10469 [ 10469 ]

Permalink

Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Nov/16 01:02 PM

Time Spent:

2h

production issue tracing the issue on all servers

Nandkumar Prabhakar Karlekar (Inactive) made changes - 25/Nov/16 01:02 PM

Remaining Estimate	5.5h [ 19800 ]	3.5h [ 12600 ]
Time Spent	6.5h [ 23400 ]	8.5h [ 30600 ]
Worklog Id	10522 [ 10522 ]

Permalink

Revansiddha Gaur (Inactive) logged work - 25/Nov/16 02:16 PM

Time Spent:

7h

Export Error Causing Analysis.
Found issue on Valmet Company while exporting & find out the root cause issue.
Due to bad data export reporting an error.

Whoes employee id is not exist in demographic table that ids are present in Ratechange log table.

Revansiddha Gaur (Inactive) made changes - 25/Nov/16 02:18 PM

Remaining Estimate	3.5h [ 12600 ]	0h [ 0 ]
Time Spent	8.5h [ 30600 ]	15.5h [ 55800 ]
Worklog Id	10532 [ 10532 ]

Revansiddha Gaur (Inactive) made changes - 28/Nov/16 06:47 AM

Attachment

WT-6658- Analysis.xls [ 33525 ]

Hide

Permalink

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

Hi Sachin Hingole

Concern:
Blank Offer Element populated , Blank Eligibility Element populated but covg element is populated as employees are enrolled in Medical Opt-Out plan.
Cause :
Blank Eligibility element : Medical Opt-Out Plan is not an ACA Plan.
Blank Offer element : Only populated the events which are related to ACA Plans.
Correction:
As per discussion with Nandkumar & Export Team Members,
1. To populate the events on file, removal the check of IsACAPlans and refer the selected plans from the template customization.-(Implementation is needed)
2. ELIG element line should not be populated in case of required field value is not present
(Implementation is needed)-Discarded this implementation by discussion with Nandkumar Prabhakar Karlekar as results are reflecting on the files by implementing the point no-1 functionality.

Please find the excel sheet analysed details. WT-6658- Analysis.xls

Affected Files :
\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_ExportProcessedEventData.StoredProcedure.sql
Smita Pawar Mahendra Mungase Yogesh Chaudhari

Show

Revansiddha Gaur (Inactive) added a comment - 28/Nov/16 06:48 AM - edited Hi Sachin Hingole Concern: Blank Offer Element populated , Blank Eligibility Element populated but covg element is populated as employees are enrolled in Medical Opt-Out plan. Cause : Blank Eligibility element : Medical Opt-Out Plan is not an ACA Plan. Blank Offer element : Only populated the events which are related to ACA Plans. Correction: As per discussion with Nandkumar & Export Team Members, 1. To populate the events on file, removal the check of IsACAPlans and refer the selected plans from the template customization.-(Implementation is needed) 2. ELIG element line should not be populated in case of required field value is not present (Implementation is needed)-Discarded this implementation by discussion with Nandkumar Prabhakar Karlekar as results are reflecting on the files by implementing the point no-1 functionality. Please find the excel sheet analysed details. WT-6658- Analysis.xls Affected Files : \Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_ExportProcessedEventData.StoredProcedure.sql Smita Pawar Mahendra Mungase Yogesh Chaudhari

Revansiddha Gaur (Inactive) made changes - 28/Nov/16 06:59 AM

Item State

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

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

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

Status

Open [ 1 ]

In Development [ 10007 ]

Permalink

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

Time Spent:

20m

Code Checkins trunk & LB

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

Code Reviewed By		Revansiddha [ 13002 ]
Dev Due Date		27/Nov/2016

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

Time Spent	15.5h [ 55800 ]	15h 50m [ 57000 ]
Worklog Id	10543 [ 10543 ]

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 28/Nov/16 07:20 AM - edited

below three employee missing mandatory fields data for ELIG, OFFR, COVG, As last exported date was 21-OCT-2016 and enrollment changed by raising QE date before exported date i.e. either 18/02/13-OCT-2016.

Mark Tierney
Dan Lanning
Chad Surunis

Revansiddha Gaur Nandkumar Prabhakar Karlekar

Show

Sachin Hingole (Inactive) added a comment - 28/Nov/16 07:20 AM - edited below three employee missing mandatory fields data for ELIG, OFFR, COVG, As last exported date was 21-OCT-2016 and enrollment changed by raising QE date before exported date i.e. either 18/02/13-OCT-2016. Mark Tierney Dan Lanning Chad Surunis Revansiddha Gaur Nandkumar Prabhakar Karlekar

Khandu Kshirsagar (Inactive) made changes - 28/Nov/16 10:35 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)

Rakesh Roy (Inactive) made changes - 28/Nov/16 10:41 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Rakesh Roy (Inactive) made changes - 28/Nov/16 10:42 AM

Assignee

Revansiddha Gaur [ revansiddha.gaur ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 28/Nov/16 10:58 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 - 29/Nov/16 05:24 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)

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 29/Nov/16 05:24 AM

Verified on LB, working fine.

Now ELIG, OFFR and COVG elemtns mandatory data is coming properly.

Show

Sachin Hingole (Inactive) added a comment - 29/Nov/16 05:24 AM Verified on LB, working fine. Now ELIG, OFFR and COVG elemtns mandatory data is coming properly.

Permalink

Sachin Hingole (Inactive) logged work - 29/Nov/16 05:38 AM

Time Spent:

0.5h

<No comment>

Sachin Hingole (Inactive) made changes - 29/Nov/16 05:39 AM

Time Spent	15h 50m [ 57000 ]	16h 20m [ 58800 ]
Worklog Id	10635 [ 10635 ]

Khandu Kshirsagar (Inactive) made changes - 29/Nov/16 10:44 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 - 30/Nov/16 06:17 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 - 30/Nov/16 07:06 AM

Time Spent:

1h

<No comment>

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 30/Nov/16 07:06 AM

Verified on Stage, working fine.

Show

Sachin Hingole (Inactive) added a comment - 30/Nov/16 07:06 AM Verified on Stage, working fine.

Sachin Hingole (Inactive) made changes - 30/Nov/16 07:06 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)

Sachin Hingole (Inactive) made changes - 30/Nov/16 07:06 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 30/Nov/16 07:07 AM

Time Spent	16h 20m [ 58800 ]	17h 20m [ 62400 ]
Worklog Id	10802 [ 10802 ]

Permalink

Revansiddha Gaur (Inactive) logged work - 01/Dec/16 04:04 AM - edited

Time Spent:

1h

Production Checkin- & Veriifcation

Ashwin Wankhede (Inactive) made changes - 01/Dec/16 07:03 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)

Revansiddha Gaur (Inactive) made changes - 02/Dec/16 04:50 AM

Time Spent	17h 20m [ 62400 ]	18h 20m [ 66000 ]
Worklog Id	11208 [ 11208 ]

Revansiddha Gaur (Inactive) made changes - 02/Dec/16 04:51 AM

Worklog Id

11208 [ 11208 ]

Revansiddha Gaur (Inactive) made changes - 02/Dec/16 04:51 AM

Worklog Id

11208 [ 11208 ]

Revansiddha Gaur (Inactive) made changes - 02/Dec/16 04:51 AM

Worklog Id

11208 [ 11208 ]

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)

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:41 AM

Remaining Estimate	0h [ 0 ]	18h 20m [ 66000 ]
Original Estimate	12h [ 43200 ]	21h [ 75600 ]

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

Remaining Estimate

18h 20m [ 66000 ]

2h 40m [ 9600 ]

Permalink

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

Time Spent:

0.75h

<No comment>

Sachin Hingole (Inactive) made changes - 02/Dec/16 07:08 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:08 AM

Verified on production, working fine.

Mandatory field data for mentioned employees is fetched properly.

Show

Sachin Hingole (Inactive) added a comment - 02/Dec/16 07:08 AM Verified on production, working fine. Mandatory field data for mentioned employees is fetched properly.

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

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

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

Remaining Estimate	2h 40m [ 9600 ]	1h 55m [ 6900 ]
Time Spent	18h 20m [ 66000 ]	19h 5m [ 68700 ]
Worklog Id	11230 [ 11230 ]

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

Status

Production Complete [ 10028 ]

Closed [ 6 ]

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

Environment_New

Production [ 18442 ]

Transition	Time In Source Status	Execution Times

Revansiddha Gaur (Inactive) made transition - 28/Nov/16 07:02 AM

Open

In Development

3d 1h 32m

Rakesh Roy (Inactive) made transition - 28/Nov/16 10:41 AM

In Development

In LB Testing

3h 39m

Sachin Hingole (Inactive) made transition - 30/Nov/16 07:06 AM

In LB Testing

Stage Testing

1d 20h 25m

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

Stage Testing

In Production Testing

1d 23h 33m

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

In Production Testing

Production Complete

27m 48s

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

Production Complete

Closed

53s

People

Assignee:: Sachin Hingole (Inactive)

Reporter:: Sachin Hingole (Inactive)

Developer:: Revansiddha Gaur (Inactive)

QA:: Sachin Hingole (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 25/Nov/16 05:29 AM

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

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

Dev Due Date:: 27/Nov/2016

Time Tracking

Estimated:

21h

Remaining:

1h 55m

Logged:

19h 5m