-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Bug Fixed
-
Labels:None
-
Environment:Production
-
Categories:EDS
-
Company:Prime Healthcare
-
Reported by:EDI
-
Provider & Benefits:Vision VSP-Vision
COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt
Client: Prime Healthcare
Facility: Saint Mary Regional Medical Center
Group Template:
Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
Prime Healthcare_NEW HR Simplified COBRA Participant_Group
Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
Company Template affected:
NEW HRSimplified_COBRA Coverage
NEW HR Simplified COBRA Participant
NEW HR Simplified COBRA DEPENDENT
Export date: November and December 2017
Export date example: 12/4/17, 12/19/2017
Example affected: Christina Abina (terminated/per diem)
Hello Vinayak Kulkarni,
The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.
Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over St Mary Employees.xlsx on the file.
Thank you,
Alex
CC: Amit Thorve Amber Love-Jones
Adding all COBRA files requested to be sent associated with this Bug.
Files are being attached to this ticket.
In Jan 2018
St Rose
WNJ
HMC
Prime HealthCare
PrimeHealthCare
EHMC
Hallmark Aviation Services
KMC
MHIN
SRMC
Karma
El Camino
Symphony
PMC
March 2018
St Rose
Prime Healthcare
MHIN
Karma
City of Bellevue
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to EDI-2855 [ EDI-2855 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Hi Vinayak Kulkarni,
CE, Amber, is hoping it can be resolve in two days. If not, she will go through manually and look them up. Let me know if you need additional info.
They will need it on the file due to demographic and other required infos. If can't be done in time, Amber will do them manually to send over to the carrier.
Thank you,
Alex
Yes, I had word with Amber about this. Thank you.
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Rakesh Shahane [ rakesh.shahane ] |
Hi Vinayak Kulkarni,
We have checked this and shared the details in separate email.
-
- Time Spent:
- 7.8h
-
Analysis
Export File creation
Sheetal Bodhale (Inactive)
logged work - 03/Jan/18 06:34 AM -
- Time Spent:
- 7.3h
-
Discussion with Rakesh
Created script
Executed on hspl company
Mail to Vinayak
-
- Time Spent:
- 8h
-
Analysis
Export File creation
sent to client
Sheetal Bodhale (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 7.3h [ 26280 ] | |
| Worklog Id | 99273 [ 99273 ] |
Sheetal Bodhale (Inactive)
logged work - 04/Jan/18 06:41 AM -
- Time Spent:
- 7.5h
-
Discussion with Rakesh
Analysis
Tried scenario on couple of employees-working fine
Sheetal Bodhale (Inactive)
made changes -
| Time Spent | 7.3h [ 26280 ] | 14.8h [ 53280 ] |
| Worklog Id | 99278 [ 99278 ] |
-
- Time Spent:
- 3h
-
Finalized cobra missed records
| Time Spent | 14.8h [ 53280 ] | 17.8h [ 64080 ] |
| Worklog Id | 99368 [ 99368 ] |
Hi Vinayak Kulkarni,
We have shared the details in separate email.
| Assignee | Rakesh Shahane [ rakesh.shahane ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
-
- Time Spent:
- 4.5h
-
Analysis
Creation of Participant, Dependent and Covarage file.
| Attachment | PrimeHealthCareCobra.zip [ 71301 ] |
| Attachment | St Mary Employees_Updated-Final.xls [ 71302 ] |
Hi Alex,
Attached zip PrimeHealthCareCobra.zip contains cobra files(participant, dependent & coverage) for mentioned employees, there are couple of employees who are active now and cannot be pulled on cobra file, we have mentioned our comments in St Mary Employees_Updated-Final.xls .
Please post these file to HR simplified, our team is looking into issue and scanning if there are other employees affected by this.
Will email Password for zip, Thanks.
| Module | Parent values: BenAdmin(10100)Level 1 values: Export(10110) | Parent values: BenAdmin(10100)Level 1 values: EDS(10108) |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Sheetal Bodhale [ sheetal.bodhale ] |
| Attachment | PrimeHealthCareCobra.zip [ 71301 ] |
| Attachment | PrimeHealthCareCobra.zip [ 71303 ] |
| Time Spent | 17.8h [ 64080 ] | 19.8h [ 71280 ] |
| Worklog Id | 99398 [ 99398 ] |
| Time Spent | 19.8h [ 71280 ] | 23.8h [ 85680 ] |
| Worklog Id | 99400 [ 99400 ] |
| Time Spent | 23.8h [ 85680 ] | 31.6h [ 113760 ] |
| Worklog Id | 99511 [ 99511 ] |
| Time Spent | 31.6h [ 113760 ] | 39.6h [ 142560 ] |
| Worklog Id | 99512 [ 99512 ] |
| Time Spent | 39.6h [ 142560 ] | 44.1h [ 158760 ] |
| Worklog Id | 99513 [ 99513 ] |
Sheetal Bodhale (Inactive)
logged work - 06/Jan/18 01:32 AM -
- Time Spent:
- 6.5h
-
Script creation for remaining employees of prime health
Production testing with Company Admin
Analysis
| Time Spent | 44.1h [ 158760 ] | 48.1h [ 173160 ] |
| Worklog Id | 99654 [ 99654 ] |
Sheetal Bodhale (Inactive)
made changes -
| Time Spent | 48.1h [ 173160 ] | 53.6h [ 192960 ] |
| Worklog Id | 99802 [ 99802 ] |
Sheetal Bodhale (Inactive)
made changes -
| Time Spent | 53.6h [ 192960 ] | 60.1h [ 216360 ] |
| Worklog Id | 99806 [ 99806 ] |
-
- Time Spent:
- 2h
-
Analysis and discussion with Sheetal, Ganesh
| Time Spent | 60.1h [ 216360 ] | 62.1h [ 223560 ] |
| Worklog Id | 100481 [ 100481 ] |
-
- Time Spent:
- 2h
-
Analysis
Discussion with Ganesh, Sheetal
Hi Alex Nguyen,
We are doing data scanning and correction untill issue gets fixed.
CC:Swapnil PandhareVinayak Kulkarni
Thanks,
Sheetal Bodhale
Sheetal Bodhale (Inactive)
added a comment - Hi Alex Nguyen ,
We are doing data scanning and correction untill issue gets fixed.
CC: Swapnil Pandhare Vinayak Kulkarni
Thanks,
Sheetal Bodhale -
- Time Spent:
- 1h
-
Analysis and discussion with Export team.
Sheetal Bodhale (Inactive)
made changes -
| Time Spent | 62.1h [ 223560 ] | 62.85h [ 226260 ] |
| Worklog Id | 100848 [ 100848 ] |
Sheetal Bodhale (Inactive)
logged work - 18/Jan/18 02:36 AM -
- Time Spent:
- 0.75h
-
Discussion with Swapnil and export team
Data scanning
-
- Time Spent:
- 4h
-
Analysis of various employees and debugging code.
Sheetal Bodhale (Inactive)
made changes -
| Assignee | Sheetal Bodhale [ sheetal.bodhale ] | Swapnil Pandhare [ swapnil.pandhare ] |
| Time Spent | 62.85h [ 226260 ] | 66.85h [ 240660 ] |
| Worklog Id | 101339 [ 101339 ] |
| Time Spent | 66.85h [ 240660 ] | 67.85h [ 244260 ] |
| Worklog Id | 101345 [ 101345 ] |
| Time Spent | 67.85h [ 244260 ] | 69.85h [ 251460 ] |
| Worklog Id | 101349 [ 101349 ] |
| Time Spent | 69.85h [ 251460 ] | 73.85h [ 265860 ] |
| Worklog Id | 102499 [ 102499 ] |
| Time Spent | 73.85h [ 265860 ] | 74.35h [ 267660 ] |
| Worklog Id | 104297 [ 104297 ] |
-
- Time Spent:
- 0.5h
-
Discussion with Prashant, Vinayak, Hrishikesh
cc : Prashant Samal
Hi Hrishikesh Deshpande,
As per our discussion, please check if this issue is reproducible and update on same.
Thanks,
Swapnil P.
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
Vinayak Kulkarni - should this be moved to "bug"?
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Support Task Type | Customization [ 11204 ] | |
| Workflow | WT_Support [ 60824 ] | WT_Defects [ 64178 ] |
Yes Abhay Patil , We have converted this into bug. Thanks.
| Time Spent | 74.35h [ 267660 ] | 75.35h [ 271260 ] |
| Worklog Id | 105740 [ 105740 ] |
| Workflow | WB: Bugs Project Management Workflow [ 65030 ] | 0803 Copy of WB: Bugs Project Management Workflow [ 65852 ] |
Hi Satya
We need look into this on priority, because of this we got WB-560 today.
Swapnil Pandhare
It seems daily correction job is not running and we need to find out when it stopped and we would need list of employees it missed to add in RaisedEventBuilder Table to force them on cobra file.
Please treat this as high priority as COBRA notices must be sent to employees within specific window. Let us know if you have any questions on this. Thanks.
-
- Time Spent:
- 3.5h
-
Analysis and Reproducing COBRA Issue
-
- Time Spent:
- 1.5h
-
Analysis and discussion
-
- Time Spent:
- 5h
-
Check for COBRA Job issue
Reviewing JOb Script
-
- Time Spent:
- 5h
-
COBRA DB Script with Vinayak
Scanning missed employees
| Time Spent | 75.35h [ 271260 ] | 76.85h [ 276660 ] |
| Worklog Id | 108661 [ 108661 ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Rajendra Pawar [ rajendra.pawar ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
-
- Time Spent:
- 5.5h
-
Scanned missed cobra records and file export is in progress for missed records
| Time Spent | 76.85h [ 276660 ] | 82.35h [ 296460 ] |
| Worklog Id | 108952 [ 108952 ] |
| QA | Swapnil Eksambekar [ swapnil.eksambekar ] | |
| QA Estimates | 16 | |
| Original Estimate | 0h [ 0 ] |
-
- Time Spent:
- 2.5h
-
Exporting COBRA Templates .(Assisting Rajnedra)
| Sprint | WB - Sprint 45 [ 102 ] |
| Assignee | Rajendra Pawar [ rajendra.pawar ] | Niteen Surwase [ niteen.surwase ] |
-
- Time Spent:
- 5h
-
Trigger changes to resolve this problem
Checking COBRA issue
Execute correction script
| Dev Due Date | 22/Mar/2018 |
| Developer | Niteen Surwase [ niteen.surwase ] |
| Dev Estimates | 8 |
Kanchan Jalgaonkar (Inactive)
logged work - 21/Mar/18 08:48 AM -
- Time Spent:
- 6.5h
-
Exporting COBRA Templates . (Assisting Rajendra)
-
- Time Spent:
- 6.8h
-
Missed cobra records
-
- Time Spent:
- 1.5h
-
Trigger and SP to COBRA correction
Testing with Rajendra
| Time Spent | 82.35h [ 296460 ] | 87.85h [ 316260 ] |
| Worklog Id | 109297 [ 109297 ] |
| Time Spent | 87.85h [ 316260 ] | 94.65h [ 340740 ] |
| Worklog Id | 109302 [ 109302 ] |
| Worklog Id | 109302 [ 109302 ] |
| Workflow | 0803 Copy of WB: Bugs Project Management Workflow [ 65852 ] | 2203 WB: Bugs Project Management Workflow [ 67046 ] |
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 94.65h [ 340740 ] | 97.15h [ 349740 ] |
| Worklog Id | 109315 [ 109315 ] |
Kanchan Jalgaonkar (Inactive)
made changes -
| Worklog Id | 109315 [ 109315 ] |
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 97.15h [ 349740 ] | 103.65h [ 373140 ] |
| Worklog Id | 109316 [ 109316 ] |
-
- Time Spent:
- 5h
-
exporting prime files
merging
testing
Kanchan Jalgaonkar (Inactive)
logged work - 22/Mar/18 04:06 PM -
- Time Spent:
- 1.5h
-
Assising Rajendra for COBRA File Missed Records (Prime Healthcare)
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 103.65h [ 373140 ] | 105.15h [ 378540 ] |
| Worklog Id | 109429 [ 109429 ] |
Kanchan Jalgaonkar (Inactive)
logged work - 23/Mar/18 11:15 AM -
- Time Spent:
- 4h
-
Exporting COBRA Files for missed records (Assisting Rajendra)
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 105.15h [ 378540 ] | 109.15h [ 392940 ] |
| Worklog Id | 109505 [ 109505 ] |
Attached test cases WB-236.xls
| Attachment | WB-236.xls [ 75145 ] |
| Time Spent | 109.15h [ 392940 ] | 111.15h [ 400140 ] |
| Worklog Id | 109522 [ 109522 ] |
| Time Spent | 111.15h [ 400140 ] | 117.15h [ 421740 ] |
| Worklog Id | 109558 [ 109558 ] |
| Time Spent | 117.15h [ 421740 ] | 124.15h [ 446940 ] |
| Worklog Id | 109559 [ 109559 ] |
| Time Spent | 124.15h [ 446940 ] | 129.15h [ 464940 ] |
| Worklog Id | 109562 [ 109562 ] |
| Time Spent | 129.15h [ 464940 ] | 134.15h [ 482940 ] |
| Worklog Id | 109563 [ 109563 ] |
| Time Spent | 134.15h [ 482940 ] | 139.15h [ 500940 ] |
| Worklog Id | 109564 [ 109564 ] |
| Time Spent | 139.15h [ 500940 ] | 140.65h [ 506340 ] |
| Worklog Id | 109565 [ 109565 ] |
| Time Spent | 140.65h [ 506340 ] | 144.15h [ 518940 ] |
| Worklog Id | 109573 [ 109573 ] |
| Worklog Id | 109564 [ 109564 ] |
-
- Time Spent:
- 1h
-
Job script change
Discussion with Rajendra
| Time Spent | 144.15h [ 518940 ] | 145.15h [ 522540 ] |
| Worklog Id | 109576 [ 109576 ] |
| Time Spent | 145.15h [ 522540 ] | 152.15h [ 547740 ] |
| Worklog Id | 109899 [ 109899 ] |
Temporary fix for this has been done on Production and For permanent fix we'll take this into next sprint.
| Time Spent | 152.15h [ 547740 ] | 154.15h [ 554940 ] |
| Worklog Id | 110103 [ 110103 ] |
| Time Spent | 154.15h [ 554940 ] | 158.15h [ 569340 ] |
| Worklog Id | 110109 [ 110109 ] |
| Time Spent | 158.15h [ 569340 ] | 159.15h [ 572940 ] |
| Worklog Id | 110109 [ 110109 ] |
| Description |
*Client:* Prime Healthcare *Facility:* Saint Mary Regional Medical Center *Group Template:* Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group Prime Healthcare_NEW HR Simplified COBRA Participant_Group Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group *Company Template affected:* NEW HRSimplified_COBRA Coverage NEW HR Simplified COBRA Participant NEW HR Simplified COBRA DEPENDENT *Export date:* November and December 2017 *Export date example:* 12/4/17, 12/19/2017 *Example affected:* Christina Abina (terminated/per diem) Hello [~Vinayak.Kulkarni], The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17. Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file. Thank you, Alex CC: [~amitthorve] [~alov] |
*Client:* Prime Healthcare *Facility:* Saint Mary Regional Medical Center *Group Template:* Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group Prime Healthcare_NEW HR Simplified COBRA Participant_Group Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group *Company Template affected:* NEW HRSimplified_COBRA Coverage NEW HR Simplified COBRA Participant NEW HR Simplified COBRA DEPENDENT *Export date:* November and December 2017 *Export date example:* 12/4/17, 12/19/2017 *Example affected:* Christina Abina (terminated/per diem) Hello [~Vinayak.Kulkarni], The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17. Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file. Thank you, Alex CC: [~amitthorve] [~alov] |
| Sprint | WB - Sprint 45 [ 102 ] | WB - Sprint 46 [ 104 ] |
| Rank | Ranked lower |
| Dev Due Date | 22/Mar/2018 | 06/Apr/2018 |
Do we have the list of all the members/clients who were impact aligned to the client. Could you please provide one to ops team. I think this is the same list that Operation was asking and Development team was going to provide.
Please let me if I am missing anything..
Thanks, Monika.
-
- Time Spent:
- 1.5h
-
Scanning Data after Trigger Changes on production
Discussion with Rajendra and Vinayak
| Time Spent | 159.15h [ 572940 ] | 160.65h [ 578340 ] |
| Worklog Id | 111291 [ 111291 ] |
Hi Monika Demla,
Development sent missed cobra files to respective EDI analyst directly via email. We sent two set of files, first one in Jan 2018 and another in March 2018, see below details of impacted clients.
In Jan 2018
St Rose
WNJ
HMC
Prime HealthCare
PrimeHealthCare
EHMC
Hallmark Aviation Services
KMC
MHIN
SRMC
Karma
El Camino
Symphony
PMC
March 2018
St Rose
Prime Healthcare
MHIN
Karma
City of Bellevue
You can get affected records files from respective EDI executives or let us know we can send those files you as well. Thanks.
| Time Spent | 160.65h [ 578340 ] | 162.65h [ 585540 ] |
| Worklog Id | 111295 [ 111295 ] |
Thank you Vinayak Kulkarni
Please see the list attached, let me know if you need additional information. Thank you.
-
- Time Spent:
- 1.5h
-
Analysis and Discussion with Swapnil
| Time Spent | 162.65h [ 585540 ] | 164.15h [ 590940 ] |
| Worklog Id | 111409 [ 111409 ] |
-
- Time Spent:
- 7h
-
Issue Reproducing
Discussion with team
Debugging to reproduce issue.
| Time Spent | 164.15h [ 590940 ] | 171.15h [ 616140 ] |
| Worklog Id | 111542 [ 111542 ] |
| Workflow | 2203 WB: Bugs Project Management Workflow [ 67046 ] | 0604 Issues Management Workflow [ 68204 ] |
-
- Time Spent:
- 5.5h
-
Analysis and Debugging for issue reproduce
Discussion with Pratap
| Time Spent | 171.15h [ 616140 ] | 176.65h [ 635940 ] |
| Worklog Id | 111693 [ 111693 ] |
| Status | In Development [ 10007 ] | In Analysis [ 10008 ] |
| Dev Due Date | 06/Apr/2018 | 10/Apr/2018 |
-
- Time Spent:
- 3h
-
Analysis and Reproducing issue
Discussion with Swapnil.
| Time Spent | 176.65h [ 635940 ] | 179.65h [ 646740 ] |
| Worklog Id | 111770 [ 111770 ] |
-
- Time Spent:
- 8.5h
-
Analysis and Reproducing issue.
Data Logging Code
Checking missed list.
-
- Time Spent:
- 2h
-
Discussion and checking logging code
-
- Time Spent:
- 8h
-
Data logging Code to get the issue
VB Code for Event Builder and Local Test
Discussion with Swapnil
Hi All
We are putting this on hold. As we have deployed TEST PATCH on Production for logging critical scenarios to reproduce this. We'll log critical scenarios until 23rd April and then we'll revert this TEST PATCH from production.
We'll get finding from logged scenarios and we'll be able to track the exact cause.
Thanks,
Niteen S.
| Time Spent | 179.65h [ 646740 ] | 188.15h [ 677340 ] |
| Worklog Id | 112170 [ 112170 ] |
| Time Spent | 188.15h [ 677340 ] | 196.15h [ 706140 ] |
| Worklog Id | 112171 [ 112171 ] |
| Worklog Id | 112170 [ 112170 ] |
-
- Time Spent:
- 2.5h
-
TEST PATCH and Unit Testing on Production
Checking Data Log and Ticket Update
| Time Spent | 196.15h [ 706140 ] | 198.65h [ 715140 ] |
| Worklog Id | 112172 [ 112172 ] |
Thank you Niteen Surwase
Please keep us posted.
Hello,
Can we get a comprehensive file of all missed employees as a result of this gap in code from January forward on the above mentioned clients as we aren't seeing where files were provided?
In addition to providing the employees impacted please also provide if possible the transaction date the term was processed in Workterra.
thanks,
Jackie
Jackie Sivigny (Inactive)
added a comment - Hello,
Can we get a comprehensive file of all missed employees as a result of this gap in code from January forward on the above mentioned clients as we aren't seeing where files were provided?
In addition to providing the employees impacted please also provide if possible the transaction date the term was processed in Workterra.
thanks,
Jackie
Monika Demla Andrea Dennis Deborah Mascot | Attachment | Re Cobra file for missed records on Nexion.msg [ 76241 ] | |
| Attachment | WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Missing cobra records files.msg [ 76242 ] | |
| Attachment | Re Export Feed List From 01 11 2018 8AM To 01 12 2018 8AM PST.msg [ 76243 ] | |
| Attachment | WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Cobra file for missed records on Nexion.msg [ 76244 ] |
| Attachment | January 2018_Prime Healthcare.zip [ 76245 ] |
| Attachment | March 2018_Prime Healthcare.zip [ 76246 ] |
Hello All,
Missed COBRA files being uploaded to this ticket for tracking. Files received from Development and loaded by the carrier.
Thank you,
Alex
CC: Cindy Wibbing
| Link | This issue is blocked by EDI-3113 [ EDI-3113 ] |
| Attachment | EBS_TERMS_COBRA010920180331.xls [ 76251 ] |
| Attachment | EBS_TERMS_COBRA03272018_Karma [ 76252 ] |
Added missed files received for Karma
| Description |
*Client:* Prime Healthcare *Facility:* Saint Mary Regional Medical Center *Group Template:* Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group Prime Healthcare_NEW HR Simplified COBRA Participant_Group Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group *Company Template affected:* NEW HRSimplified_COBRA Coverage NEW HR Simplified COBRA Participant NEW HR Simplified COBRA DEPENDENT *Export date:* November and December 2017 *Export date example:* 12/4/17, 12/19/2017 *Example affected:* Christina Abina (terminated/per diem) Hello [~Vinayak.Kulkarni], The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17. Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file. Thank you, Alex CC: [~amitthorve] [~alov] |
*Client:* Prime Healthcare *Facility:* Saint Mary Regional Medical Center *Group Template:* Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group Prime Healthcare_NEW HR Simplified COBRA Participant_Group Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group *Company Template affected:* NEW HRSimplified_COBRA Coverage NEW HR Simplified COBRA Participant NEW HR Simplified COBRA DEPENDENT *Export date:* November and December 2017 *Export date example:* 12/4/17, 12/19/2017 *Example affected:* Christina Abina (terminated/per diem) Hello [~Vinayak.Kulkarni], The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17. Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file. Thank you, Alex CC: [~amitthorve] [~alov] Adding all COBRA files requested to be sent associated with this Bug. Files are being attached to this ticket. *{color:#333333}In Jan 2018{color}*{color:#333333} St Rose WNJ HMC Prime HealthCare PrimeHealthCare EHMC Hallmark Aviation Services KMC MHIN SRMC Karma El Camino Symphony PMC{color} {color:#333333} {color} *{color:#333333}March 2018{color}*{color:#333333} St Rose Prime Healthcare MHIN Karma City of Bellevue{color} |
| Attachment | AlectoHealthcareParticipant-St Rose201801110333.txt [ 76262 ] |
| Attachment | AlectoHealthcareDependent-St Rose201801110333.txt [ 76263 ] |
| Attachment | AlectoHealthcareCoverage-St Rose201801110333.txt [ 76264 ] |
| Attachment | COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt [ 76265 ] |
thanks so much!!
Jackie Sivigny (Inactive)
added a comment - thanks so much!! -
- Time Spent:
- 2h
-
Checking for Logged employees data.
| Time Spent | 198.65h [ 715140 ] | 200.65h [ 722340 ] |
| Worklog Id | 112348 [ 112348 ] |
What are the passwords on the files?
Deborah Mascot (Inactive)
added a comment - What are the passwords on the files? | Attachment | AlectoHealthcareParticipant-St Rose201803260323.txt [ 76308 ] |
| Attachment | AlectoHealthcareDependent-St Rose201803260325.txt [ 76309 ] |
| Attachment | AlectoHealthcareCoverage-St Rose201803260326.txt [ 76310 ] |
| Attachment | COBRA_P_EBSBenefits_Alecto_011120181120.txt [ 76315 ] |
| Attachment | COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt [ 76317 ] |
| Description |
*Client:* Prime Healthcare *Facility:* Saint Mary Regional Medical Center *Group Template:* Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group Prime Healthcare_NEW HR Simplified COBRA Participant_Group Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group *Company Template affected:* NEW HRSimplified_COBRA Coverage NEW HR Simplified COBRA Participant NEW HR Simplified COBRA DEPENDENT *Export date:* November and December 2017 *Export date example:* 12/4/17, 12/19/2017 *Example affected:* Christina Abina (terminated/per diem) Hello [~Vinayak.Kulkarni], The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17. Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file. Thank you, Alex CC: [~amitthorve] [~alov] Adding all COBRA files requested to be sent associated with this Bug. Files are being attached to this ticket. *{color:#333333}In Jan 2018{color}*{color:#333333} St Rose WNJ HMC Prime HealthCare PrimeHealthCare EHMC Hallmark Aviation Services KMC MHIN SRMC Karma El Camino Symphony PMC{color} {color:#333333} {color} *{color:#333333}March 2018{color}*{color:#333333} St Rose Prime Healthcare MHIN Karma City of Bellevue{color} |
[^COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt] *Client:* Prime Healthcare *Facility:* Saint Mary Regional Medical Center *Group Template:* Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group Prime Healthcare_NEW HR Simplified COBRA Participant_Group Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group *Company Template affected:* NEW HRSimplified_COBRA Coverage NEW HR Simplified COBRA Participant NEW HR Simplified COBRA DEPENDENT *Export date:* November and December 2017 *Export date example:* 12/4/17, 12/19/2017 *Example affected:* Christina Abina (terminated/per diem) Hello [~Vinayak.Kulkarni], The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17. Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file. Thank you, Alex CC: [~amitthorve] [~alov] Adding all COBRA files requested to be sent associated with this Bug. Files are being attached to this ticket. *{color:#333333}In Jan 2018{color}*{color:#333333} St Rose WNJ HMC Prime HealthCare PrimeHealthCare EHMC Hallmark Aviation Services KMC MHIN SRMC Karma El Camino Symphony PMC{color} {color:#333333} {color} *{color:#333333}March 2018{color}*{color:#333333} St Rose Prime Healthcare MHIN Karma City of Bellevue{color} |
For Alecto: St Rose, WNJ and FRMC are attached,
Hi Deborah Mascot,
PrimeHealthCareCobra.zip password is Cobra@StMaryPrime and was attached back in January. The recent files for Prime are not password protected. Let us know if other files prompting you for it.
Alex
Alex NguyenThe files for El Camino Hospital and Sympony are in password protected zipped files.
Thanks!
Deborah Mascot (Inactive)
added a comment - Alex Nguyen The files for El Camino Hospital and Sympony are in password protected zipped files.
Thanks! | Sprint | WB - Sprint 46 [ 104 ] | WB - Sprint 46, Carry Over from Sprint 46 [ 104, 113 ] |
| Rank | Ranked higher |
-
- Time Spent:
- 2h
-
Checking logged employee on Production.
Checking entries in RaisedEventBuilder
Discussion - Swapnil
| Time Spent | 200.65h [ 722340 ] | 202.65h [ 729540 ] |
| Worklog Id | 112529 [ 112529 ] |
-
- Time Spent:
- 1h
-
Checked Logged terminated employees for issue.
| Time Spent | 202.65h [ 729540 ] | 203.65h [ 733140 ] |
| Worklog Id | 112760 [ 112760 ] |
-
- Time Spent:
- 3h
-
Checking logged employees on Production
Analysis
-
- Time Spent:
- 4h
-
Checking issue for Logged Employee
Reproduced issue for Eff. Date Scenario on Production
Discussion with Pratap
| Time Spent | 203.65h [ 733140 ] | 207.65h [ 747540 ] |
| Worklog Id | 113018 [ 113018 ] |
-
- Time Spent:
- 3.75h
-
Reproduced issue for an employee
Checking Logged employee data
Discussed with Swapnil and Pratap
| Time Spent | 207.65h [ 747540 ] | 211.15h [ 760140 ] |
| Worklog Id | 113213 [ 113213 ] |
| Time Spent | 211.15h [ 760140 ] | 214.9h [ 773640 ] |
| Worklog Id | 113214 [ 113214 ] |
| Remaining Estimate | 0h [ 0 ] | 0.5h [ 1800 ] |
| Time Spent | 214.9h [ 773640 ] | 214.4h [ 771840 ] |
| Worklog Id | 113213 [ 113213 ] |
| Remaining Estimate | 0.5h [ 1800 ] | 0h [ 0 ] |
| Time Spent | 214.4h [ 771840 ] | 216.4h [ 779040 ] |
| Worklog Id | 113233 [ 113233 ] |
| Time Spent | 216.4h [ 779040 ] | 216.9h [ 780840 ] |
| Worklog Id | 113234 [ 113234 ] |
-
- Time Spent:
- 2.5h
-
And Checking Logged EEs and Document Prepare
-
- Time Spent:
- 3.25h
-
Reproducing issue for Classes on Production
Cross verify data for classes
Document Preparation
| Time Spent | 216.9h [ 780840 ] | 219.4h [ 789840 ] |
| Worklog Id | 113867 [ 113867 ] |
| Time Spent | 219.4h [ 789840 ] | 222.65h [ 801540 ] |
| Worklog Id | 113868 [ 113868 ] |
| Status | In Analysis [ 10008 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | LB Deployed [ 11600 ] |
| Status | LB Deployed [ 11600 ] | In LB Testing [ 10200 ] |
| Status | In LB Testing [ 10200 ] | Ready for Pre-Prod [ 11615 ] |
| Status | Ready for Pre-Prod [ 11615 ] | Pre-Prod Deployed [ 11601 ] |
| Status | Pre-Prod Deployed [ 11601 ] | IN Pre-prod Testing [ 11500 ] |
| Status | IN Pre-prod Testing [ 11500 ] | Ready for Production [ 10024 ] |
| Status | Ready for Production [ 10024 ] | Production Deployed [ 10025 ] |
| Status | Production Deployed [ 10025 ] | In Production Testing [ 10202 ] |
| Resolution | Cannot Reproduce [ 5 ] | |
| Status | In Production Testing [ 10202 ] | In Production Review [ 11501 ] |
| Attachment | WB-236 Issue.doc [ 76992 ] |
As we have reproduced this issue for 2 employees on production. We are still observing more scenarios on this.
Please find the detailed and descriptive analysis and reproducing steps in attached document.
Thanks,
Niteen S.
CC:Swapnil Pandhare Satya Vinayak Kulkarni Rajendra Pawar Prashant Samal
-
- Time Spent:
- 1.5h
-
Meeting and Discussion with Vinayak and Swapnil
Ticket Update
| Time Spent | 222.65h [ 801540 ] | 224.15h [ 806940 ] |
| Worklog Id | 114240 [ 114240 ] |
| Time Spent | 224.15h [ 806940 ] | 224.65h [ 808740 ] |
| Worklog Id | 114308 [ 114308 ] |
| Time Spent | 224.65h [ 808740 ] | 225.65h [ 812340 ] |
| Worklog Id | 114315 [ 114315 ] |
| Link | This issue is blocked by WB-1085 [ WB-1085 ] |
| Link | This issue is blocked by WB-1085 [ WB-1085 ] |
| Link | This issue is duplicated by WB-1085 [ WB-1085 ] |
-
- Time Spent:
- 3.5h
-
Analysis and Discussion with Rrajendra and Swapnil
DB Trigger for all statuses
-
- Time Spent:
- 3h
-
DB Trigger and SP writing
Employee Statuses scenarios
Unit Testing
Earlier this fix was for Active to Terminate status only, Now, we'll fix this for all the Employee statuses. So, Re-opening this JIRA as discussed with you.
Thanks,
Niteen S.
| Resolution | Cannot Reproduce [ 5 ] | Unresolved [ 10200 ] |
| Status | In Production Review [ 11501 ] | REOPENED IN PRODUCTION REVIEW [ 11605 ] |
| Status | REOPENED IN PRODUCTION REVIEW [ 11605 ] | In Development [ 10007 ] |
-
- Time Spent:
- 8h
-
Trigger and SP Fix for All Statuses
Unit Testing and Code Review
| Time Spent | 225.65h [ 812340 ] | 233.65h [ 841140 ] |
| Worklog Id | 115481 [ 115481 ] |
| Time Spent | 233.65h [ 841140 ] | 237.15h [ 853740 ] |
| Worklog Id | 115485 [ 115485 ] |
| Worklog Id | 115485 [ 115485 ] |
| Time Spent | 237.15h [ 853740 ] | 240.15h [ 864540 ] |
| Worklog Id | 115486 [ 115486 ] |
| Time Spent | 240.15h [ 864540 ] | 241.15h [ 868140 ] |
| Worklog Id | 115525 [ 115525 ] |
This has been deployed on Production. Please verify this change.
Thanks,
Niteen S.
| Assignee | Niteen Surwase [ niteen.surwase ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Status | In Development [ 10007 ] | LB Deployed [ 11600 ] |
| Status | LB Deployed [ 11600 ] | In LB Testing [ 10200 ] |
| Status | In LB Testing [ 10200 ] | Ready for Pre-Prod [ 11615 ] |
| Status | Ready for Pre-Prod [ 11615 ] | Pre-Prod Deployed [ 11601 ] |
| Status | Pre-Prod Deployed [ 11601 ] | IN Pre-prod Testing [ 11500 ] |
| Status | IN Pre-prod Testing [ 11500 ] | Ready for Production [ 10024 ] |
| Status | Ready for Production [ 10024 ] | Production Deployed [ 10025 ] |
-
- Time Spent:
- 3h
-
Unit Testing and Code Review
Check-ins on LB, Stage and Production
Discussion with Swapnil
| Time Spent | 241.15h [ 868140 ] | 244.15h [ 878940 ] |
| Worklog Id | 115557 [ 115557 ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
Hello Hrishikesh Deshpande and Swapnil Eksambekar
This ticket was just brought to our attention by management. Can you or Alex Nguyen confirm if the following files for these months were re-sent to HR Simplified, and if so, when?
In Jan 2018
HMC
Prime HealthCare
PrimeHealthCare
EHMC
KMC
MHIN
SRMC
PMC
March 2018
Prime Healthcare
MHIN
Thank you,
Amber
| Attachment | exported.jpg [ 77742 ] |
Hi Amber Love-Jones,
I stored all the files I sent out to carrie here Y:\1.CLIENT\Prime Healthcare\5. EDI\Structure_Specs\HR Simplified - COBRA\Production Files. The Jan 2018 files were all sent out on 4/10/18 and March files have been sending out weekly according to the view history.
One of the file in March had to be done manually due to errors. They were fixed and sent to carrier afterwards. Let me know if you need more info.
Alex
| Time Spent | 244.15h [ 878940 ] | 244.65h [ 880740 ] |
| Worklog Id | 115623 [ 115623 ] |
Verified following COBRA Events on Production (Company - PMC for Hspl.)
1)Active to Termination
2)Active to Deceased
3)Military Leave to Termination
4)Military Leave to LOA
5)Rehired to Termination
CC-Hrishikesh Deshpande Vinayak Kulkarni
| Status | Production Deployed [ 10025 ] | In Production Testing [ 10202 ] |
| Assignee | Swapnil Eksambekar [ swapnil.eksambekar ] | Alex Nguyen [ alexn ] |
| Assignee | Alex Nguyen [ alexn ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
Hi Alex Nguyen,
We have tried above scenarios and it is working as expected however we will try some more scenarios in order to confirm this issue is permanently fixed.
We will keep you updated with same.
Thanks,
Hrishikesh.
| Time Spent | 244.65h [ 880740 ] | 250.65h [ 902340 ] |
| Worklog Id | 115730 [ 115730 ] |
| Time Spent | 250.65h [ 902340 ] | 251.65h [ 905940 ] |
| Worklog Id | 115731 [ 115731 ] |
Thank you for the reassurance, Hrishikesh Deshpande.
-
- Time Spent:
- 8h
-
Trigger Expansion to Classes and Additional Criteria's
DB Triggers for Spouse and State
Unit Testing
-
- Time Spent:
- 9.5h
-
Triggers for Additional Criteria
Unit Testing all Triggers
Discussion with Swapnil
Help to Amit
-
- Time Spent:
- 4h
-
Analysis
Trigger Create
Discussion with Swapnil & Niteen
| Time Spent | 251.65h [ 905940 ] | 255.65h [ 920340 ] |
| Worklog Id | 116088 [ 116088 ] |
| Time Spent | 255.65h [ 920340 ] | 256.65h [ 923940 ] |
| Worklog Id | 116089 [ 116089 ] |
-
- Time Spent:
- 2h
-
Check-ins on PreProd
Testing on PreProd
Executing Company Specific triggers
| Time Spent | 256.65h [ 923940 ] | 258.65h [ 931140 ] |
| Worklog Id | 116118 [ 116118 ] |
| Time Spent | 258.65h [ 931140 ] | 266.65h [ 959940 ] |
| Worklog Id | 116119 [ 116119 ] |
| Time Spent | 266.65h [ 959940 ] | 276.15h [ 994140 ] |
| Worklog Id | 116120 [ 116120 ] |
Verified this ,It is working as expected.
Please find below scenarios covered for COBRA events.
Prime Healthcare for HSPL -
Event Name
A)Change Classs
B)Change State
C)Change Status -
1)Active to Termination
2)Active to Deceased
3)Military Leave to Termination
4)Military Leave to Termination
5)LOA to Termination
6)Rehired to Termination
Deep south for HSPL,University Health for HSPL,ATC for HSPL
Event Name
Active to Active COBRA
Wacker Neuson Corporation For HSPL --> Demographics --> PTeligibilityflag
Event Name
1. Part Time to Full Time
2.Full Time to Part Time
TIBCO For HSPL--> Status Criteria
Event Name
1.Out of Country or PT Employee
University Health For HSPL --> Type of Employment
Event Name
1.Event FT to PRN
2.Event FT to PT
Thanks,
Swapnil Eksambekar.
CC-Hrishikesh Deshpande Satya Niteen Surwase
-
- Time Spent:
- 1h
-
Code check in
Discussion with Niteen
Code review
Hello,
I wanted to circle back on this as right now all of these files have been reviewed and as of this point the only ones still in process of finalization of impact are KARMA and Alecto. As of this point, we have identified all were passed on files to COBRA.
Can you advise the type of query run as I know the lists and clients provided were supposed to be folks missed?
Also, can you advise why on KARMA we received people going back to September 2017 when the issue was initially raised as a breakdown beginning Jan 2018 forward?
Let us know.
Jackie
Jackie Sivigny (Inactive)
added a comment - Hello,
I wanted to circle back on this as right now all of these files have been reviewed and as of this point the only ones still in process of finalization of impact are KARMA and Alecto. As of this point, we have identified all were passed on files to COBRA.
Can you advise the type of query run as I know the lists and clients provided were supposed to be folks missed?
Also, can you advise why on KARMA we received people going back to September 2017 when the issue was initially raised as a breakdown beginning Jan 2018 forward?
Let us know.
Jackie
Monika Demla | Assignee | Swapnil Eksambekar [ swapnil.eksambekar ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
About your first question, list and clients provided were supposed to be folks missed?
Yes, they were missed and we scanned whole production clients and prepared cobra file as per respective client's cobra template structure for missed folk. Then we sent these cobra files to respective EDI analyst. They have uploaded/sent these file to cobra vendor.
So the point when list & clients were attached to this ticket, missed folk were sent to cobra vendor.
About your second question, why on KARMA you received people going back to September?
Actually issue occurred due to WT-9141 which got deployed to production on 19/Sep/17. However we got to know about issue toward end of 17 and that is why we sent two files.
One, EBS_TERMS_COBRA010920180331.xls was fetched on Jan 09 2018
second EBS_TERMS_COBRA03272018_Karma was fetch on March 27 2018.
First file had people from 19th September 2017 on wards.
Let us know if you have any questions on this. Thanks.
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
| Time Spent | 276.15h [ 994140 ] | 278.15h [ 1001340 ] |
| Worklog Id | 117277 [ 117277 ] |
| Time Spent | 278.15h [ 1001340 ] | 283.15h [ 1019340 ] |
| Worklog Id | 117843 [ 117843 ] |
| Time Spent | 283.15h [ 1019340 ] | 288.65h [ 1039140 ] |
| Worklog Id | 117844 [ 117844 ] |
| Time Spent | 288.65h [ 1039140 ] | 290.65h [ 1046340 ] |
| Worklog Id | 117916 [ 117916 ] |
Hi Alex Nguyen,
This issue is fixed and verified on Production,Please review it.and close the JIRA.
Let us know , if there is any query.
Thanks,
CC-Hrishikesh Deshpande Swapnil Pandhare Niteen Surwase Vinayak Kulkarni
| Resolution | Unresolved [ 10200 ] | Bug Fixed [ 10402 ] |
| Status | In Production Testing [ 10202 ] | In Production Review [ 11501 ] |
| Assignee | Swapnil Eksambekar [ swapnil.eksambekar ] | Alex Nguyen [ alexn ] |
The carrier just reported issues with records from some facilities missing coverages and tiers. This was recently reported yesterday regarding the COBRA files. I need to go through and review them and let you know whether this is something that needs to be fixed on our end. I will close ticket after if no assistance needed from Dev.
Thank you,
Alex
Closing ticket. I have run cobra term report and pulled required data requested by carrier. Carrier was stating some records on file were missing coverage tier and plans. I checked one of the record on file and didn't see this issue, but went ahead and pulled the data for short list of affected records.
| Status | In Production Review [ 11501 ] | Closed [ 6 ] |
| Sprint | WB - Sprint 46 [ 104 ] | WB - Sprint 46, WB - Sprint 50 [ 104, 116 ] |
| Rank | Ranked higher |
| Sprint | WB - Sprint 46, WB - Sprint 50 [ 104, 116 ] | WB - Sprint 46 [ 104 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
17m 18s | 1 |
|
52d 14h 11m | 1 |
|
26d 18h 23m | 1 |
|
20d 19h 6m | 1 |
|
17d 2h 54m | 1 |
|
12d 21h 10m | 1 |
|
9s | 1 |
|
23h 39m | 2 |
|
14s | 2 |
|
11s | 2 |
|
9s | 2 |
|
8s | 2 |
|
10s | 2 |
|
13s | 2 |
|
1d 1h 55m | 2 |
|
23d 21h 58m | 2 |
|
2d 11h 7m | 1 |
Hi Alex,
It seems that status change ( active to terminated ) is not captured by event builder which used in cobra processing, Will have to check with team.
Let us know how urgent is this? are mentioned employees are reported to HR simplified or do we need to get them on cobra file in order to report them?
Swapnil Pandhare We need to have call for this, There is no entry in table raisedEventBuilder even though terminated event is configured properly and employee's status changed to terminated.
Satya Gaurav Sodani