Hi Swapnil Pandhare

CC:Rakesh Roy,Hrishikesh Deshpande,Satya,Gaurav Sodani

Verified TIBCO for hspl this issue it comes when we try to initiate qualifying event for employee
Refer below error Log:

ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetRaiseQualifyingEventCollection->GenericEligblityCheck.FetchDemographicEligibility
ErrorMessage: Incorrect syntax near ')'.
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput)
TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Thanks,
Rashmita

Hi Rashmita Dudhe,

Please find below 3C's:

Please Verify And Confirm.

Thanks And Regards,
Rohit Shete

CC:Debbie Kulling,Amruta Lohiya,Jyoti Mayne,Avnish Yadav,Umesh Kadam

Hi Debbie Kulling,

CC:Rakesh Roy,Amruta Lohiya,Rohit Shete,Hrishikesh Deshpande

1) Server error Issue is Fixed, We have also tested same on TIBCO company.

2) Issue of ER contribution does not show on the confirmation statement or enrollment summary -

We have tried all scenarios for this and it is not getting reproduced at our end.
Can you please share Employee Details whose ER cost is not showing. Also, let us know on which user (Admin/Partner) you are facing this.

Please refer screenshot of our testing where ER cost is showing proper. In the screenshot, the employee is same which you had reported in WT-10635.

Thanks,
Rashmita

Please stop marking an issue as resolved when you cannot reproduce it.

Hi Debbie Kulling,

Development has considered this issue for 'Qualifying event' server error, which occurred due to Generic Eligibility migration. That has been fixed, however for 'ER contribution not showing on Confirmation statement' - development is looking into this in jira WT-10635. We have re-opened this and will share update in related jira ticket.

Regards,
Satya Prakash.

Hi Debbie Kulling, The issue reprted in WT-10635 got Reproduced at our end. Development team is working on same.
We will Keep you updated with Status.

Let us know in case you required call for this issue from our end?
—

Hi Rohit Shete,

This issue is getting Reproduced follow below steps:

As per view history of PAIGE N RAUTIO employee.
1]Insert Employee data through import template Employee Test Import refer attached file for demographics data
2]Done Election Import in a medical plan through template Election Import no PCP with effective date 6/1
3]HSA plan is contingent on Medical plan(eligibility contingency).
4]Partner login through UI Enrolled into the HSA plan with effective date 7/1 Qualifying event BCC admin.
Cross verified on Ui it is not showing ER contribution.

Refer attached screen shots.

CC:Rakesh Roy,Hrishikesh Deshpande,Satya,Hrishikesh Deshpande,Gaurav Sodani

Thanks,
Rashmita

Hi Debbie Kulling,

We are working on this and we will update you.

Thanks And Regards,
Rohit Shete.

CC:Amruta Lohiya,Jyoti Mayne,Gaurav Sodani,Rashmita Dudhe

Hi Rashmita Dudhe,

Please find below 3C's:

Thanks And Regards,
Rohit Shete

CC:Satya,Amruta Lohiya,Jyoti Mayne,Umesh Kadam,Gaurav Sodani

Hi Debbie Kulling,

We found around 4900+ employees across 49 do not received employer coverage. Please find attached list of affected employees and company names.
We will target data correction on Quincy and TIBCO first. Please go through the attached list first. Many of these enrollments might have gone on export files with 0 employer coverage. Once we do the correction the changes will reflect on export files again. Please let us know if you are OK with this.

AffectedEEList(WT10957).xls CompnayList(WT10957).xls

Thanks And Regards,
Rohit Shete.

CC:Satya,Amruta Lohiya,Jaideep Vinchurkar,Jyoti Mayne,Umesh Kadam,Rashmita Dudhe

Please give me an ETA on the fix for TIBCO and Quincy. BCC also had this issue with COSB.

I will inform the other CEs of the other groups impacted.

Hi Debbie Kulling,

There was one condition missed in earlier scanning script. Now we have corrected scanning script and found attached EE Tibco COSSB Quincy EE list.xls were having issue of blank ER Coverage for TIBCO, Quincy and COSB.

We have also checked these EEs impact on file. Please find below details.

For Correction we will do following:
1. Update ER coverage amount
2. Recalculate ER cost with Consider Export Flag to True

After correction, ER Coverage and cost will roll out on file. Please confirm if you want same to be roll out on file or not for these 3 companies.

Our correction script is ready. After your approval, we will correct these 3 companies data immediately.

Note: We are in progress of scanning EEs for all production companies and will share result with you. Please ignore previously shared list of affected EEs and companies.

Cc: Amruta Lohiya, Jyoti Mayne

Hi Debbie Kulling,

Code fix is deployed under WT-10635 JIRA today on LB. After QA approval, we will move it to Stage and Production.

This JIRA is correction purpose.

Cc: Amruta Lohiya, Jyoti Mayne

Hello,

Can you give me a specific date for release to PROD?

Thank you,
Kira
Debbie Kulling

Hi Kira Hamilton,

CC:Debbie Kulling,Hrishikesh Deshpande,Rohit Shete

WT-10635 is deployed and verified on the local environment. We will deploy this on production with next production patch 19 September 2017.

Thanks,
Rashmita

Hi Debbie Kulling,

As per our discussion in a call, we will do correction for TIBCO, Quincy and COSB companies tomorrow on priority. Also as discussed, this correction will be roll out on file.

We have also scanned others companies and found only Castleberry and Rogers Memorial Hospital having impact on file for blank ER Coverage. These companies have only 4 affected records. Among those 4 records, Castleberry has 1 affected record and Rogers Memorial Hospital has 3 affected record.

Code fix for this issue has been deployed on LB under WT-10635. We will deploy the same on Stage tomorrow and Production on Monday.

Thanks and Regards,
Rohit Shete

CC : Satya, Amruta Lohiya, Jyoti Mayne, Umesh Kadam

Hi Hrishikesh Deshpande,

Correction is done on Tibco for HSPL and COSB for HSPL. Please verify ER coverage and Cost for impacted EEs.

Cc: Amruta Lohiya

Hi Jyoti Mayne,

CC:Hrishikesh Deshpande

Verified impacted employee sheet on COSB for hspl and Tibco for hspl .
employees are getting proper ER coverage.

You can do this on the main company.

Thanks,
Rashmita

Hi Debbie Kulling,

We have done correction on TIBCO, Quincy and COSB companies.

Note:

• On COSB there is plan 'Mass Transit II' having ER contribution customized as $0 and ShowEmployerCoverage flag on cost and coverage is set to No. There are 9 EEs enrolled in this plan and we have not done any correction to them.
• On Quincy there is plan 'Health Savings Account 2017 No Annual-A' having having ER contribution customized as $0 and ShowEmployerCoverage flag on cost and coverage is set to No. There are 3 EEs enrolled in this plan and we have not done any correction to them.

Please confirm and let us know if you face any issue.

Cc: Amruta Lohiya, Satya

Hi Hrishikesh Deshpande,

Please verify correction on TIBCO, Quincy and COSB company.

Cc: Amruta Lohiya, Satya, Rashmita Dudhe

Verified affected employee list for TIBCO, Quincy and COSB company showing proper ER coverage
1]View enrollment summary
2]Enroll now screen
3]Confrimation Statement
4]View history

Hi Debbie Kulling/Kira Hamilton

This is deployed and verified on production.
Data correction Done on TIBCO, Quincy and COSB company.

Thanks,
Rashmita

Hi Debbie Kulling,

Regarding remaining two companies, Castleberry and Rogers Memorial Hospital there were only 4 EE found and they don't required correction as ShowEmployerCoverage is flag is set to No and Employer coverage is customized as $0.

Cc: Satya, Amruta Lohiya