-
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
-
- 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)
logged work - 04/Jan/18 06:41 AM -
- Time Spent:
- 7.5h
-
Discussion with Rakesh
Analysis
Tried scenario on couple of employees-working fine
-
- Time Spent:
- 3h
-
Finalized cobra missed records
-
- Time Spent:
- 4.5h
-
Analysis
Creation of Participant, Dependent and Covarage file.
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:
- 2h
-
Analysis and discussion with Sheetal, Ganesh
-
- Time Spent:
- 2h
-
Analysis
Discussion with Ganesh, Sheetal
-
- Time Spent:
- 1h
-
Analysis and discussion with Export team.
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.
-
- Time Spent:
- 0.5h
-
Discussion with Prashant, Vinayak, Hrishikesh
-
- 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:
- 5.5h
-
Scanned missed cobra records and file export is in progress for missed records
-
- Time Spent:
- 2.5h
-
Exporting COBRA Templates .(Assisting Rajnedra)
-
- Time Spent:
- 5h
-
Trigger changes to resolve this problem
Checking COBRA issue
Execute correction script
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:
- 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)
logged work - 23/Mar/18 11:15 AM -
- Time Spent:
- 4h
-
Exporting COBRA Files for missed records (Assisting Rajendra)
-
- Time Spent:
- 1h
-
Job script change
Discussion with Rajendra
-
- Time Spent:
- 1.5h
-
Scanning Data after Trigger Changes on production
Discussion with Rajendra and Vinayak
-
- Time Spent:
- 1.5h
-
Analysis and Discussion with Swapnil
-
- Time Spent:
- 7h
-
Issue Reproducing
Discussion with team
Debugging to reproduce issue.
-
- Time Spent:
- 5.5h
-
Analysis and Debugging for issue reproduce
Discussion with Pratap
-
- Time Spent:
- 3h
-
Analysis and Reproducing issue
Discussion with Swapnil.
-
- 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
-
- Time Spent:
- 2.5h
-
TEST PATCH and Unit Testing on Production
Checking Data Log and Ticket Update
-
- Time Spent:
- 2h
-
Checking for Logged employees data.
-
- Time Spent:
- 2h
-
Checking logged employee on Production.
Checking entries in RaisedEventBuilder
Discussion - Swapnil
-
- Time Spent:
- 1h
-
Checked Logged terminated employees for issue.
-
- 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:
- 3.75h
-
Reproduced issue for an employee
Checking Logged employee data
Discussed with Swapnil and Pratap
-
- 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:
- 1.5h
-
Meeting and Discussion with Vinayak and Swapnil
Ticket Update
-
- 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
-
- Time Spent:
- 8h
-
Trigger and SP Fix for All Statuses
Unit Testing and Code Review
-
- Time Spent:
- 3h
-
Unit Testing and Code Review
Check-ins on LB, Stage and Production
Discussion with Swapnil
-
- 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:
- 2h
-
Check-ins on PreProd
Testing on PreProd
Executing Company Specific triggers
-
- Time Spent:
- 1h
-
Code check in
Discussion with Niteen
Code review
