Hi Prashant,

Can you please check mentioned details?

Regards,
Satya Prakash

Cc: Samir Swapnil Pandhare Mandar Kulkarni

Hello Raymond Williams,

We have corrected the record on the Marymount High School company for now for this employee record and costs are coming down properly on the billing details report

This occurred due to some inconstancy in the Enrollment Data and Related Billing Details Data
We will provide more detailed explanation on the same.

@@ Prasanna Karlekar : Please look into this for root cause and scanning.

Thanks,
S Prashant.
-----------------------------------------------------------------
Satya Swapnil Pandhare Mandar Kulkarni Rajendra Pawar Avnish Yadav

Thanks Prashant Samal!

Hi Prashant Samal,

Thank you for initial analysis and correction.

cc: Gaurav Sodani

Hi Raymond Williams,

Following are the 3C's:
Concern:
The rates for Mary's Basic Life and AD&D come down on the Billing Details Report with $0's

Cause:
This issue is caused by WT-8172 and had impact on Billing Report only. After deployment of WT-8172, all records with future effective date should have been inserted in Billing table too. But this was not done, hence the record was missing from Billing table. As no record was present 0 cost was appearing in Billing Report. We have scanned all companies to check the data discrepancy. Please find company wise affected election count in WT-12048_AffectedCompanies.xlsx. Please note this issue is not there now and will not be there in future too. This issue was only for elections done before 18-Jul-2017(before deployment of WT-8172) and were having effective date greater than 18-Jul-2017.

Correction:
No code fix is required. Missing data needs to be inserted in billing table.
Correction is in progress. Correction for pending companies will be done by tomorrow. We will also provide list of all impacted employees.

Thank you!

cc: Gaurav Sodani, Satya, Prashant Samal

Hi Raymond Williams,

Corrections are done for all pending companies.

Please find attached WT-12048_AffectedCompanies&Elections.xlsx with following details:

• "Company List" tab having impacted companies data
• "Election List" tab having impacted elections data

Do let us know if anything more is required from our side.

Thank you!

cc: Gaurav Sodani