Hi Prasanna Karlekar,

Verified this issue for EE 'Aaron Taylor'. Already created Billing details report named 'Packard Billing Details' shows coverage count '2' for plan 'Basic life and AD&D' and when new report is created with the same date range and other details, coverage count is '0'

The confirmation statement of EE 'Aaron Taylor' for plan 'Basic life and AD&D' shows coverage count as '1' in both current and future enrollment summary.

(Please refer the screen shot below)

Request you to please look into this.
Thank you,
------------------------------------------------------------------------------
CC: Mandar Kulkarni, Satya

Verified mentioned issue and below are the 3Cs:

Concern: Enrollment coverage count mismatch on confirmation statement and Billing report

Cause: There was two problems due which leads Enrollment coverage count mismatch on confirmation statement and Billing report.
1. Incorrect grouping was there because currently we are storing data into two tables (i.e. main table and Intermediate table) but while calculate count we have done grouping on Enrollment Id but it should be as Enrollment Id and Intermediate flag.
2. Enrollment coverage count value appearing as zero when there is no enrollment fields selected (i.e. Enrollment effective date, termination date, etc.) in display fields along with Enrollment coverage count. Because we were checking flag before update enrollment coverage count in temporary table.

Correction:
1. Now while grouping we have considered Intermediate flag so it will show correct values of count.
2. Removed condition of enrollment fields before update enrollment coverage count into temporary table. So when we select enrollment count it will not be depend on enrollment fields.

Affected Areas: Billing Report (i.e. With and without Demographics)

Affected Files:
OES_SP_GetBillingDetailsMonthly
OES_SP_GetBillingDetailsMonthly_Demographics

Tested Scenarios:
1. Check billing type both (i.e. With and without Demographics) reports
2. Compare enrollment coverage count on confirmation statement and billing details report.

Note: We have resolved above issues on The Packard Companies only. This will get deployed on all other companies through our process.

Prasad Patil, Could you please verify above changes on The Packard Companies company?

CC: Prasanna Karlekar Mandar KulkarniGaurav Sodani Satya

Hi Robyn Adkison,

Enrollment Coverage Count is the field which represents the count of members enrolled in a particular plan. If only EE is enrolled in the plan, the Enrollment Coverage Count will be '1'. If EE and Spouse are enrolled in a plan count will be '2' and so on.

EE 'Aaron Taylor' was the only one enrolled in the 'Basic life and AD&D' so his count should be '1'.

As mentioned in above comment, correction is made for this issue. We have verified the reports of type 'Billing Details' and 'Enrollment' at our end and they are working fine.

Request you to please check this at your end and let us know for any issues.
Thank you,
-----------------------------------------------------------------------------------
CC: Mandar Kulkarni, Satya, Prasanna Karlekar, [~parmeshwar.jumbade]

Hi Parmeshwar,

Re-opening this ticket, since after deploying fix for all companies, it would be marked production complete.

For Packard company - correction has been completed.
Regards,
Satya Prakash

Cc: Gaurav Sodani Prasanna Karlekar Jaideep Vinchurkar

Thank you Prasad Patil for the explanation. We'll take a look at the file for packard and let you know if we have any additional questions.

Hi Gaurav Sodani,

Have attached WT-12723- Issue and implementation Approach.xls file for deployment approval. This file include all details (i.e. issues, current implementation, Bug Resolution Approach and etc.).

Please check and let us know if need more details.

CC: Prasanna Karlekar Satya Samir

Hi All,

Attaching development approval email for reference: Unable to embed resource: FW Hot Fix and Development Approval Request.msg of type application/octet-stream

Regards
Gaurav

Hi [~parmeshwar.jumbade],

I have tested this issue on LB on For QA Caiso For Hspl company. It is working fine as expected. This is ready for Stage.

Sachin Hingole,Prasanna Karlekar,Hrishikesh Deshpande

Thanks,
Venkatesh

We have verified this issue on Stage and observed that it's working as expected. Hence marking ready for Production.

Mahendra

Hi All,

This ticket has been approved for stage deployment on 12/21/17.

Regards
Gaurav

Hi Robyn Adkison,

The issue has been resolved and also tested on Production. Please could you verify and close this ticket.

Sachin Hingole,Prasanna Karlekar,[~parmeshwar.jumbade]

Thanks,
Venkatesh

Hi Venkatesh Pujari,
I ran a billing details for packard for 2/1/18 and I am seeing that the counts are still not matching what the enrollment counts are.
For instance, Amy Alpaugh is showing 1, however, her coverage tier is EE +SP + CH so I would expect her count to be 3.
Denise Huerta is showing EE only, however, her count is showing 3.

Thanks,
Robyn

Hi Robyn Adkison,

We have verified this on our end observed that the count is matching as per the members enrolled in a plan for an Employee. Please could you send us the report details(From Date,To Date,Plan selection and field selections ) for which you are facing this issue.

Thanks,
Venkatesh

Hi All,

Attaching the production deployment approval email for reference

Regards
Gaurav