-
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
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.
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
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.
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