Below are 3Cs :-
Concern :- Invoice is not showing all the employee records completely
Cause :- We were showing records which were in 'Rates' table. We were not showing records to which rate was not mapped
Correction :- Now we are considering all records even which do not have rate mapped, with blank cost.

Testing in progress

Hi Jyoti Agrawal,

Verified this fix on LB on FOR QA - DO NOT USE company. Please find the scenarios tested as below:-

1] Verified whether the Invoice record count matches with Enrollment report for health plans only or not.
2] Verified whether the Invoice record count matches with Enrollment report for Life plans only or not.
3] Verified whether the Invoice record count matches with Enrollment report for health & Life plans or not.
4] Terminated some enrollments and verified whether these are reflected as well in the Invoice report or not.

This is ready for Stage.

Alankar Chavan,Prasanna Karlekar

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Verified this fix on Stage on City Of Irvin for Hspl company. Please find the scenarios tested as below:-

1] Verified whether the Invoice record count matches with Enrollment report for health plans only or not.
2] Verified whether the Invoice record count matches with Enrollment report for Life plans only or not.
3] Verified whether the Invoice record count matches with Enrollment report for health & Life plans or not.
4] Terminated some enrollments and verified whether these are reflected as well in the Invoice report or not.

This is ready for Production

Alankar Chavan,Prasanna Karlekar

Thanks,
Venkatesh

Re-opening this ticket as not getting expected result. Few records are still missing.

Prasanna Karlekar , Venkatesh Pujari , Alankar Chavan

Below are 3cs :-
Concern :- Invoice is not showing all the employee records completely
Cause :- Employee and plan were not considered from intermediate table for records which were in intermediate table. We missed a code block in previous check-in.
Correction :- Consider records from intermediate table. Give a code fix

Hi Jyoti Agrawal,

Verified this fix on LB on For QA Do Not Use company. Please find the scenarios tested as below:-

1] Verified whether the Invoice record count matches with Enrollment report for health plans only or not.
2] Verified whether the Invoice record count matches with Enrollment report for Life plans only or not.
3] Verified whether the Invoice record count matches with Enrollment report for health & Life plans or not.
4] Terminated some enrollments and verified whether these are reflected as well in the Invoice report or not.
5] Also verified if the enrollment is in intermediate table and no rate mapped to it.

Working fine as expected

This is ready for Stage.

Alankar Chavan,Prasanna Karlekar

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Verified this fix on Stage on Decurion for Hspl company. Please find the scenarios tested as below:-
1] Verified whether the Invoice record count matches with Enrollment report for health plans only or not.
2] Verified whether the Invoice record count matches with Enrollment report for Life plans only or not.
3] Verified whether the Invoice record count matches with Enrollment report for health & Life plans or not.
4] Terminated some enrollments and verified whether these are reflected as well in the Invoice report or not.
5] Also verified if the enrollment is in intermediate table and no rate mapped to it.

Working fine as expected

This is ready for Production.

Alankar Chavan,Prasanna Karlekar

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Tested this on Production on City of Denton For HSPL company. Issue still exists as all enrollments are not being displayed on Invoice. I have verified this for Medical Gold Plan and Basic Life plan. Please note that this is happening for Intermediate enrollments.

Alankar Chavan,Prasanna Karlekar

Thanks,
Venkatesh

This needs to be verified.

cc: Venkatesh Pujari, Jyoti Agrawal

Hi Venkatesh Pujari,

We have tried fixing code for most issues.
There are few scenarios for which discrepancy can still be seen :-
1. Discrepancy due to Show Enrolled flag in enrollment report. When flag is set to Enrolled , this will give only active enrollments in report. While Invoice will show all records that are active as well as records that have been Terminated in that span.
Flag Enrolled and Terminated in enrollment report will give all record which are active as well terminated in provided span.

2. When there is enrollment change in mid of month (due to Tier change, Plan change etc), enrollment report picks both enrollments. Where as Invoice picks either single record or both depending on the Billing Policy set.

There can be more such scenarios which can create discrepancy. After analysis and testing we have found two. We request you check these from your end and let us know if you find any discrepancy. We will verify those records.

We will be giving code fix in LB on Monday (2/27/17).

Thanks,
Jyoti Agrawal

CC : Prasanna Karlekar

Hi Jyoti Agrawal,

Verified the above points on LB on ASML company and observed the records are being displayed correctly.

Prasanna Karlekar

This is ready for Stage.

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Verified the above points on Stage on AFI For Hspl company and observed the records are being displayed correctly.

Prasanna Karlekar

This is ready for Production.

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Verified the above points on Production on City Of Redding For Hspl company and observed the records are being displayed correctly.

Prasanna Karlekar

Thanks,
Venkatesh