-
Type:
Bug
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Production
-
Module:BenAdmin - Export
-
Reported by:Client
-
Company:Prime Healthcare
-
Item State:Production Complete
Hello,
HR Simplified confirmed that a notification to send a COBRA packet was sent for overage dependent Cailynn Shields. This is a dependent of Hospital Business Services employee Janice Johnson (EEID 13307). The overage dependent turned 26 in October of 2016, and is showing on the HR Simplified file as being eligible for the EPO Medical Plan. The employee is not enrolled in any medical plans - she has the Waive Opt Out Medical Plan.
Please research why this record transmitted over to HR Simplified.
Thank you.
-
- Time Spent:
- 4h
-
1) Checked logic of fetch cobra reason
2) Checked logic processing member
3) Verified template customization
4) Checked enrollment and coverage data
Field | Original Value | New Value |
---|---|---|
Assignee | Shubhankar Joshi [ shubhankar ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Attachment | View Enrollment Summary.png [ 35677 ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Remaining Estimate | 3.5h [ 12600 ] | |
Original Estimate | 3.5h [ 12600 ] |
Remaining Estimate | 3.5h [ 12600 ] | 0h [ 0 ] |
Time Spent | 3.5h [ 12600 ] | |
Worklog Id | 14858 [ 14858 ] |
Worklog Id | 14858 [ 14858 ] |
Remaining Estimate | 0h [ 0 ] | 0.5h [ 1800 ] |
Original Estimate | 3.5h [ 12600 ] | 4h [ 14400 ] |
Remaining Estimate | 0.5h [ 1800 ] | 0h [ 0 ] |
Time Spent | 3.5h [ 12600 ] | 4h [ 14400 ] |
Worklog Id | 14858 [ 14858 ] |
Attachment | Waive_medical.png [ 35808 ] |
Attachment | screenshot-1.png [ 35809 ] |
Attachment | screenshot-2.png [ 35810 ] |
Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
Status | In Progress [ 3 ] | Open [ 1 ] |
Support Task Type | Data Correction [ 11203 ] | |
Workflow | WT_Support [ 29322 ] | WT_Defects [ 29401 ] |
Time Spent | 4h [ 14400 ] | 10h [ 36000 ] |
Worklog Id | 15289 [ 15289 ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Status | Open [ 1 ] | In Development [ 10007 ] |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | |
Original Estimate | 4h [ 14400 ] | 10h [ 36000 ] |
-
- Time Spent:
- 4.5h
-
1) Discussion with team for approach
2) Analysis
3) Checked event builder implementation
Time Spent | 10h [ 36000 ] | 14.5h [ 52200 ] |
Worklog Id | 16944 [ 16944 ] |
Time Spent | 14.5h [ 52200 ] | 15.5h [ 55800 ] |
Worklog Id | 16953 [ 16953 ] |
Original Estimate | 10h [ 36000 ] | 15.5h [ 55800 ] |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Remaining Estimate | 0h [ 0 ] | 2h [ 7200 ] |
Original Estimate | 15.5h [ 55800 ] | 17.5h [ 63000 ] |
Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
Time Spent | 15.5h [ 55800 ] | 17.5h [ 63000 ] |
Worklog Id | 18102 [ 18102 ] |
-
- Time Spent:
- 2.75h
- <No comment>
Time Spent | 17.5h [ 63000 ] | 20h [ 72000 ] |
Worklog Id | 19579 [ 19579 ] |
Time Spent | 20h [ 72000 ] | 20.5h [ 73800 ] |
Worklog Id | 19579 [ 19579 ] |
Remaining Estimate | 0h [ 0 ] | 0.2h [ 720 ] |
Time Spent | 20.5h [ 73800 ] | 20.3h [ 73080 ] |
Worklog Id | 19579 [ 19579 ] |
Remaining Estimate | 0.2h [ 720 ] | 0.4h [ 1440 ] |
Time Spent | 20.3h [ 73080 ] | 20.1h [ 72360 ] |
Worklog Id | 19579 [ 19579 ] |
Remaining Estimate | 0.4h [ 1440 ] | 0.25h [ 900 ] |
Time Spent | 20.1h [ 72360 ] | 20.25h [ 72900 ] |
Worklog Id | 19579 [ 19579 ] |
Remaining Estimate | 0.25h [ 900 ] | 10h [ 36000 ] |
Original Estimate | 17.5h [ 63000 ] | 30.25h [ 108900 ] |
Remaining Estimate | 10h [ 36000 ] | 9.25h [ 33300 ] |
Time Spent | 20.25h [ 72900 ] | 21h [ 75600 ] |
Worklog Id | 19915 [ 19915 ] |
Remaining Estimate | 9.25h [ 33300 ] | 8.5h [ 30600 ] |
Time Spent | 21h [ 75600 ] | 21.75h [ 78300 ] |
Worklog Id | 19919 [ 19919 ] |
Remaining Estimate | 8.5h [ 30600 ] | 8h [ 28800 ] |
Time Spent | 21.75h [ 78300 ] | 22.25h [ 80100 ] |
Worklog Id | 19923 [ 19923 ] |
Remaining Estimate | 8h [ 28800 ] | 7h [ 25200 ] |
Time Spent | 22.25h [ 80100 ] | 23.25h [ 83700 ] |
Worklog Id | 20009 [ 20009 ] |
-
- Time Spent:
- 0.75h
-
Design team meeting - COBRA logic on Export feeds
Remaining Estimate | 7h [ 25200 ] | 6h [ 21600 ] |
Time Spent | 23.25h [ 83700 ] | 24.25h [ 87300 ] |
Worklog Id | 20080 [ 20080 ] |
Remaining Estimate | 6h [ 21600 ] | 5.25h [ 18900 ] |
Time Spent | 24.25h [ 87300 ] | 25h [ 90000 ] |
Worklog Id | 20148 [ 20148 ] |
Remaining Estimate | 5.25h [ 18900 ] | 4.5h [ 16200 ] |
Time Spent | 25h [ 90000 ] | 25.75h [ 92700 ] |
Worklog Id | 20204 [ 20204 ] |
Remaining Estimate | 4.5h [ 16200 ] | 3.75h [ 13500 ] |
Time Spent | 25.75h [ 92700 ] | 26.5h [ 95400 ] |
Worklog Id | 20304 [ 20304 ] |
Worklog Id | 20304 [ 20304 ] |
-
- Time Spent:
- 2h
-
1) fetched additional field column list for cobra events.
Remaining Estimate | 3.75h [ 13500 ] | 1.75h [ 6300 ] |
Time Spent | 26.5h [ 95400 ] | 28.5h [ 102600 ] |
Worklog Id | 20677 [ 20677 ] |
Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Export(10110) |
-
- Time Spent:
- 1h
-
1) Get additional macro name and details.
Remaining Estimate | 1.75h [ 6300 ] | 0.75h [ 2700 ] |
Time Spent | 28.5h [ 102600 ] | 29.5h [ 106200 ] |
Worklog Id | 22760 [ 22760 ] |
Remaining Estimate | 0.75h [ 2700 ] | 0h [ 0 ] |
Time Spent | 29.5h [ 106200 ] | 33.5h [ 120600 ] |
Worklog Id | 24136 [ 24136 ] |
Attachment | Macro Details.xls [ 39524 ] |
-
- Time Spent:
- 2.5h
-
1) Modified logic in store procedure.
2) Internal Discussion.
Time Spent | 33.5h [ 120600 ] | 36h [ 129600 ] |
Worklog Id | 24482 [ 24482 ] |
Time Spent | 36h [ 129600 ] | 37h [ 133200 ] |
Worklog Id | 24994 [ 24994 ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Rakesh Shahane [ rakesh.shahane ] |
Developer | Rakesh Shahane [ rakesh.shahane ] |
Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
Time Spent | 37h [ 133200 ] | 41h 5m [ 147959 ] |
Worklog Id | 25618 [ 25618 ] |
Time Spent | 41h 5m [ 147959 ] | 46h 29m [ 167399 ] |
Worklog Id | 25624 [ 25624 ] |
Time Spent | 46h 29m [ 167399 ] | 46h 53m [ 168839 ] |
Worklog Id | 25624 [ 25624 ] |
Time Spent | 46h 53m [ 168839 ] | 51h 41m [ 186119 ] |
Worklog Id | 25837 [ 25837 ] |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Time Spent | 51h 41m [ 186119 ] | 52h 41m [ 189719 ] |
Worklog Id | 26082 [ 26082 ] |
Dev Due Date | 28/Feb/2017 |
Time Spent | 52h 41m [ 189719 ] | 59h 5m [ 212759 ] |
Worklog Id | 26973 [ 26973 ] |
Time Spent | 59h 5m [ 212759 ] | 65h 35m [ 236159 ] |
Worklog Id | 26975 [ 26975 ] |
Time Spent | 65h 35m [ 236159 ] | 65h 59m [ 237599 ] |
Worklog Id | 26977 [ 26977 ] |
-
- Time Spent:
- 2.5h
-
COBRA File setup with Rakesh
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Code Reviewed By | Ganesh Sadawarte ,Vinalyak Kulkarni [ 12101, 12100 ] |
Time Spent | 65h 59m [ 237599 ] | 72h 11m [ 259919 ] |
Worklog Id | 27328 [ 27328 ] |
Time Spent | 72h 11m [ 259919 ] | 72h 51m [ 262319 ] |
Worklog Id | 27332 [ 27332 ] |
Dev Due Date | 28/Feb/2017 | 01/Mar/2017 |
Time Spent | 72h 51m [ 262319 ] | 75h 21m [ 271319 ] |
Worklog Id | 27536 [ 27536 ] |
Attachment | AffectedFiles.txt [ 41000 ] |
Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Assignee | Rakesh Shahane [ rakesh.shahane ] | Aniruddha Dev [ aniruddha.dev ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Time Spent | 75h 21m [ 271319 ] | 75h 41m [ 272519 ] |
Worklog Id | 28245 [ 28245 ] |
Assignee | Aniruddha Dev [ aniruddha.dev ] | Prajakta Belhe [ prajakta.belhe ] |
-
- Time Spent:
- 5h
-
testing
discussion with anirudha
-
- Time Spent:
- 4h
-
testing
discussion with anirudha
Assignee | Prajakta Belhe [ prajakta.belhe ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Time Spent | 75h 41m [ 272519 ] | 78h 41m [ 283319 ] |
Worklog Id | 29012 [ 29012 ] |
Time Spent | 78h 41m [ 283319 ] | 79h 41m [ 286919 ] |
Worklog Id | 29019 [ 29019 ] |
Time Spent | 79h 41m [ 286919 ] | 80h 41m [ 290519 ] |
Worklog Id | 29042 [ 29042 ] |
Time Spent | 80h 41m [ 290519 ] | 85h 41m [ 308519 ] |
Worklog Id | 29106 [ 29106 ] |
Time Spent | 85h 41m [ 308519 ] | 89h 41m [ 322919 ] |
Worklog Id | 29115 [ 29115 ] |
Attachment | AffectedFiles.txt [ 41000 ] |
Attachment | AffectedFiles.txt [ 41473 ] |
Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
Time Spent | 89h 41m [ 322919 ] | 90h 41m [ 326519 ] |
Worklog Id | 29230 [ 29230 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Aniruddha Dev [ aniruddha.dev ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
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) |
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) |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
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) |
Time Spent | 90h 41m [ 326519 ] | 91h 41m [ 330119 ] |
Worklog Id | 29896 [ 29896 ] |
Time Spent | 91h 41m [ 330119 ] | 93h 41m [ 337319 ] |
Worklog Id | 29912 [ 29912 ] |
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) |
Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Resolution | Fixed [ 1 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Time Spent | 93h 41m [ 337319 ] | 95h 5m [ 342359 ] |
Worklog Id | 30319 [ 30319 ] |
Assignee | Aniruddha Dev [ aniruddha.dev ] | Amber Love-Jones [ alov ] |
Item State | Parent values: Production Complete(10222)Level 1 values: Closed(10223) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Production Complete(10222) |
Time Spent | 95h 5m [ 342359 ] | 96h 5m [ 345959 ] |
Worklog Id | 31076 [ 31076 ] |
Time Spent | 96h 5m [ 345959 ] | 97h 5m [ 349559 ] |
Worklog Id | 31757 [ 31757 ] |
Environment_New | Production [ 18442 ] |
Transition | Time In Source Status | Execution Times |
---|
|
3m 50s | 1 |
|
16h 38m | 1 |
|
11d 17h 4m | 1 |
|
6d 51m | 1 |
|
2s | 1 |
|
57d 1h 42m | 2 |
|
1d 4h 7m | 1 |
|
1d 16m | 1 |
|
2m 55s | 1 |
Hi Amber Love-Jones,
Please find below 3C'S
Concern: why this record transmitted over to HR Simplified.
Cause: The employee Janice Johnson (EEID 13307) enrolled in EPO1 Plan and on 11/17/2016 export this employee exported on file because of overage dependent event ideally this should not be export because Cailynn Shields was not enrolled into medical EPO1 Plan. Please find snap.
Correction: We will update you corrective action soon.
CC-Rohan J Khandave,Vinayak Kulkarni, Ganesh Sadawarte
Thanks,
Ganesh