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

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.

Hi Vinayak Kulkarni,

We have checked this and shared the details in separate email.

CC-Rajendra Pawar, Ganesh Sadawarte

Hi Vinayak Kulkarni,

We have shared the details in separate email.

CC-Rajendra Pawar, Ganesh Sadawarte

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.

Hi Alex Nguyen,

We are doing data scanning and correction untill issue gets fixed.

CC:Swapnil PandhareVinayak Kulkarni

Thanks,
Sheetal Bodhale

cc : Prashant Samal
Hi Hrishikesh Deshpande,

As per our discussion, please check if this issue is reproducible and update on same.

Thanks,
Swapnil P.

Vinayak Kulkarni - should this be moved to "bug"?

Yes Abhay Patil , We have converted this into bug. Thanks.

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.

Attached test cases WB-236.xls

CC-Hrishikesh DeshpandeRakesh Roy

Temporary fix for this has been done on Production and For permanent fix we'll take this into next sprint.

CC: Swapnil Pandhare Satya Rakesh Roy Vinayak Kulkarni

Hi Niteen Surwase

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.

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.

Thank you Vinayak Kulkarni

cc Jackie Sivigny

Please see the list attached, let me know if you need additional information. Thank you.

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.

CC: Swapnil Pandhare Satya Prashant Samal

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

Monika Demla Andrea Dennis Deborah Mascot

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

Added missed files received for Karma

cc Damion M Velasquez

thanks so much!!

What are the passwords on the files?  

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 MascotAlex Nguyen
Passwords:
Passwords

Cobra@HallmarkAviation

ech2016

Symphony!2018

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.

WB-236 Issue.doc

Thanks,

Niteen S.

CC:Swapnil Pandhare Satya Vinayak Kulkarni Rajendra Pawar Prashant Samal

HI Hrishikesh Deshpande

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.

CC:Swapnil Pandhare Rajendra Pawar Satya

Hi Hrishikesh Deshpande

This has been deployed on Production. Please verify this change.

Thanks,

Niteen S.

CC: Swapnil Pandhare Satya

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

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

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

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.

Thank you for the reassurance, Hrishikesh Deshpande.

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

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

Hi Jackie Sivigny

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,

Swapnil Eksambekar

CC-Hrishikesh Deshpande Swapnil Pandhare Niteen Surwase Vinayak Kulkarni

Hi Swapnil Eksambekar,

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.