Hi regina johnson,

Below are the 3C's:

Concern: Coverage tier label doesn't show for enrollments for Spouse only
Cause: As you mentioned all enrollments which are not showing coverage tier and effective date column information are spouse only. While processing data in a query we missed to handle this scenario for spouse only enrollments.
Correction: To handle this problem we will require development and for this will require development approval. Please let us know the priority of this so we can take this up.

CC: Amruta Lohiya Gaurav SodaniSatya

regina johnson : Please update on this.

__________________________________
[~parmeshwar.jumbade] regina johnson Satya

Jennifer Johnson Can you update Dev on this?

Thanks

Jennifer Reed Jackie Sivigny Debbie Kulling Jennifer Leugers

Hey All -

I think we may need to look into this - I am not sure which other clients are having the same issue but I assume we need to understand who is all affected.

Thanks!

Jenni

Hi All,

This issue will be exist on companies where spouse only enrollments are available. For now we have scanned all clients where such scenario is exist for active enrollments . Please find attached Affected_Clients_For_Plan.xls list for all affected clients with plan name.

Please let us know if more details required.

CC: Prashant SamalAmruta Lohiya Satya

Yes, as of right now this is going to be picked up for next sprint. We'll confirm once finalized.

Below are the 3C's:

Concern: Coverage tier label doesn't show for enrollments for Spouse only
Cause: As you mentioned all enrollments which are not showing coverage tier and effective date column information are spouse only. While processing data in a query we missed to handle this scenario for spouse only enrollments.
Correction: To handle this problem we have added one condition for spose only enrollment.

Affected Files:
OES_SP_GetBillingDetailsMonthly
OES_SP_GetBillingDetailsMonthly_Demographics
dbo.OES_SP_GetEnrollmentDetailsForAllEmployee_Demographics
dbo.OES_SP_GetEnrollmentDetailsForAllEmployee.StoredProcedure

Affected Areas: Report (Normal and DemoGraphics)

Tested Scenarios:
1. Checked Coverage_Tier_Label & Effective Date column values column value with & without Enrollment related fields (i.e. QualifyingEvent.Name, Enrollment Effective, Termination Date, etc.)
2. Checked Coverage_Tier_Label & Effective Date column values with & without coverage related fields (i.e. AppliedCoverages, ApprovedCoverages, EnrollmentCoverageCount, ApprovedCoverageAmount, etc.)
3. Checked reports with and without select Coverage_Tier_Label & Effective Date column fields
4. Verified Preview and Save functionality

CC: Amruta Lohiya Satya

Hi [~parmeshwar.jumbade],

Tested this issue on Codemap on For QA CHMC For Azure company. Now the system is displaying correct tier even if only spouse is enrolled. This is ready for Stage

Sachin Hingole

Thanks,
Venkatesh

Hi Sachin Hingole,

Please include this in Sprint-46 deployment approval & get status udpated.

Regards,

Satya Prakash

cc: [~parmeshwar.jumbade] Hrishikesh Deshpande Rakesh Roy

Hi Amruta Lohiya,

While testing this issue on Pre-stage the system is displaying blank Coverage Tier Label for Spouse Only Enrollments. I have also tried this by adding a health tier label on that company but the billing details report still displays blank value for Coverage Tier Label. This issue when tested on LB was working fine as expected but now on LB also it is not working as per expectation.

Sachin Hingole

Thanks,

Venkatesh

Is there an update on this

Hello DEV,

I have linked another ticket to this WB.  Looks like all of the reports are having the same issue.  Please note, CT-4720 is for a different company.  If you want me to create a separate WB please let me know.  

Thanks,

Tiquanna

Hello DEV,

I have linked another ticket to this WB.  Different company. CT-4763

Thanks,

Tiquanna

Monika Demla- can a report be drafted on the back end by DEV for El Camino please?  The client needs the report information as soon as possible.

Hi Tiquanna

 I am afraid Dev wont be able to provide any suporrt as soon as possible. It is Saturday,  4:08Am in India right now. I will try to get a response by Monday 8:00 am PST. would that work?

Also, Please change the priority level if you need to..

Hi Monika Demla,

Below are updates :

1. We were not sure about the type of report (Enrollment/Billing) and customization details(Date range, plans etc). We went through CT-4763 JIRA and assumed the report that client requires might be 'Life Premium-All Plans' named template saved for enrollment report. We corrected script in El Camino HSPL copy and pulled the same report without any customization change. See the attached file Life Premium-All PlansLife Premium-All Plans37306_5247.zip. Will be sending password in separate mail.

2. We have provided rights for El Camino Hospital for HSPL to you and Tiquanna so that you can pull other required report if above was not correct.

3. Please note that the code fix for this will be deployed on production by tomorrow(5/8) and the same is deployed on Pre Prod today.

4. The ticket CT-4720 linked to this ticket is not related to issue here. CT-4720 is related to WB-892.

Thank you,

Jyoti Agrawal

cc:Amruta Lohiya,Tiquanna,Debbie Kulling

Tiquanna

Sending you the password via email. 

I already have the password.

Thanks

Hi Venkatesh Pujari,

This is deployed in Pre-prod and Prod. Can you please take this ahead.

Thanks,

Jyoti A.

Amruta Lohiya,Sachin Hingole

Hi Jyoti Agrawal,

Tested this issue on Preprod on CHMC For HSPL company. Now the system is displaying correct tier even if only spouse is enrolled for health plans. This is ready for Production

Sachin Hingole

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Tested this issue on Prod on CHMC For HSPL company. Now the system is displaying correct tier even if only spouse is enrolled for health plans.

Sachin Hingole

Thanks,
Venkatesh

Hi Monika Demla,

The issue has been resolved and also tested on Production. Now the system is displaying correct tier label even if only spouse is enrolled for health plans. Please could you verify and let us know if the issue has been resolved.

Sachin Hingole,Jyoti Agrawal

Thanks,

Venkatesh

hi Tiquanna

Could you please verify and let us know if this is correct.

Thank you

Monika

Monika Demla,

The enrollment report in WT shows coverages, but the recon billing summary report still doesn't show EE or ER cost for CT-4720.  I've asked that billing run a billing summary report on their end (as a second pair of eyes) to see if those costs are showing. 

CT-4763 has been fixed after deploy. 

Hi [~parmeshwar.jumbade],

Please could you look into the above concern by Tiquanna and update her after your analysis.

Thanks,

Venkatesh

Hi  Venkatesh Pujari,

Will update on this by tomorrow EOD. 

CC: Amruta Lohiya Satya

Hello Venkatesh Pujari

Recon billing details report was not showing EE or ER cost for CT-4720 because there was billing data integrity issue which is already logged in WB-892. For now we have corrected billing data on this company (i.e. Jafra) but it will get fixed on all companies once WB-892 gets completed.

Please verify reports on main company and confirm.

CC: Amruta Lohiya Satya

Hi Tiquanna,

The corrections have been done on JAFRA company. Now the billing details report is showing EE or ER cost as expected. Please could you verify and close this ticket.

[~parmeshwar.jumbade]

Thanks,

Venkatesh