This will get complete in next sprint as we discovered new scenarios related to family rates.

cc: Satya

Concern:
Family Rates scenario not working as expected on Billing Summary Report.

Cause:
Code implementation for family rates scenario was not working as expected.
1. For Family rate - All Children customization and Require same coverage for child set to true, coverages were getting summed up. Instead, it should be considered only once.
2. For other family rate customization too, individual coverages were getting summed up. Instead maximum coverage should be considered.

Correction:
We have done implementation changes and handled following scenarios:
1. Family Rate For All Children with Require same coverage for child set true- Consider coverage only once
2. Family Rate For All Children with Require same coverage for child set false- Consider maximum coverage elected for Children.
3. Family Rate For All Dependent - Maximum coverage of Spouse and Child elected
4. Family Rate For All Dependents-Flat - Maximum coverage of Spouse and Child elected
5. Individually Calculated rates - All coverages as per election.

Affected Files:
dbo.OES_SP_Report_GetBillingSummary.StoredProcedure

Impacted areas:
Life Plan scenarios - With and without Family Rate customization.

Known issues:
1. Records displayed for Individually Calculated rates are as per coverage levels of Employee, Spouse and child. If Employee, Spouse and Child are enrolled 3 entries appear as per their coverages but premium displayed against them is calculated by considering all the elected coverages. This is discrepancy as we do not store memberwise coverage in the system. (We need to check if the cost split up can be saved.)
2. If no rate is mapped, records are not appearing for Life Plan. This was working earlier.

cc: Satya

Verified above mentioned issue for below types of Rate Calculation for Plan [ LIFE benefit type ] :

Rate Calculated for This Plan As -
Individually Calculated Rate
Family Rate For All Children
Family Rate For All Dependent
Family Rate For All Dependents-Flat

In all above rate calculation scenarios ,Coverage , Rate , Volume , Enrollment and Premium are displayed properly.

ISSUE : But, Enrollment Count are not updated properly if two different employee enrolled in same plan with same coverage. [ Billing summary report : Cost by set to Age-band]

CC - Sachin Hingole Rakesh Roy

Hi Prasanna Karlekar

Please make sure we complete this issue till 9/29/17. We can not have this extended further

Regards
Gaurav

CC: Satya

Keeping this JIRA On Hold.
Not getting time to work on this due to Support tasks that needs to be worked up on.
Will try to resume working on this if time permits.

Thank you!

cc: Gaurav Sodani

Have changed the priority from Medium to High as these changes will be required for proper output of Family rate customization and also to keep the code consistency.

cc: Gaurav Sodani, [~parmeshwar.jumbade]

All above tested changes also merged in new UI so all changes need to test along with Enrollment count discrepancy.

Below are the 3C's for Enrollment count discrepancy:

Concern: Enrollment count were mismatched in Cost By Coverage and Cost by Age-Band for LIFE benefit type.
Cause: Code was not exist to show sum of distinct enrollment count. So, it was always showing one count no matter how many number of enrollment available into specified Age band. This issue was present only in case of Cost by Age-Band for LIFE benefit type.
Correction: Modified existing implementation in a way that will calculate correct Enrollment count (i.e. Equivalent count in both cases . Now it will show exact same count in case of Cost by Age band and Cost by Coverage.

Affected Areas: Billing Summary Report
Affected Files:
/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetBillingSummary.StoredProcedure.sql

Tested Scenarios:

1. Verified Enrollment counts on Billing Summary reports For Life and Health benefit type.
2. Compared Enrollment count in both cases (i.e. Cost by Coverage and Age band).

CC: Amruta Lohiya Satya

Hi [~parmeshwar.jumbade],

I have verified the below points on Codemap on For QA KinderCare company:-

1. Family Rate For All Children with Require same coverage for child set true- Consider coverage only once
2. Family Rate For All Children with Require same coverage for child set false- Consider maximum coverage elected for Children.
3. Family Rate For All Dependent - Maximum coverage of Spouse and Child elected
4. Family Rate For All Dependents-Flat - Maximum coverage of Spouse and Child elected
5. Individually Calculated rates - All coverages as per election.

System is not behaving as per expectation. For above points system is displaying wrong data on the Billing Summary Report.

Please let me know if you need any more information on this.

Sachin Hingole,Prasad Pise

Thanks,
Venkatesh

Hi [~parmeshwar.jumbade],

Please could you assign this ticket once the issue is fixed.

Sachin Hingole

Thanks,
Venkatesh

Hi Venkatesh Pujari/Hrishikesh Deshpande

For now we have handled few scenarios which are mentioned in WB-275. Please check those scenarios and as mentioned in WB-275, remaining scenarios we can consider in WB-852.

Please let me know if require some additional details.

CC: Prashant Samal Amruta Lohiya Satya

Hi [~parmeshwar.jumbade],

Verified this issue on Lb on For QA FDU Azure company. All the scenarios worked fine as per expectation. I have tested Individual Calculated rates and*Family rates for all children* (Only Child Enrollment Allow Flag - Yes) and Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report. This is good to be deployed on Preprod.

Sachin Hingole

Thanks,
Venkatesh

Hi [~parmeshwar.jumbade],

Verified this issue on AFI For Hspl company. All the scenarios worked fine as per expectation. I have tested Individual Calculated rates*and*Family rates for all children (Only Child Enrollment Allow Flag - Yes) and Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report. This is good to be deployed on Prod.

Sachin Hingole

Thanks,
Venkatesh

Hi [~parmeshwar.jumbade],

Verified this issue on Production on AFI For Hspl company. All the scenarios worked fine as per expectation. I have tested Individual Calculated rates and Family rates for all children(Only Child Enrollment Allow Flag - Yes) and Individual Calculated rates for Employee Only and Spouse Only plans. System displaying correct coverage and premium on Billing Summary Report.

Sachin Hingole

Thanks,
Venkatesh