Affected Files :
D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_WEFGetProcessTypeID_Rule.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_1_Export_WaivedEnrollment.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_Export_Eligibility.View.sql
D:\WTBranches\LB\App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb
D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Update_WEFEmployeeEligibility_IneligibleEEUpdate.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\01_DDL\573_WT-9760_WTB_ACA_NewTable_ACA_WEFEmployeeEligibilityLockRun.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_ExportProcessedEventData.StoredProcedure.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_EligibilityForExport.sql
D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Export_GetBillingDetailsWithDatewise.StoredProcedure.sql

Smita Pawar Please update test case and update testing status.

Sachin HingoleRevansiddha Gaur

We have started testing after restoring production data on LB.
When have deleted run rate maintenance, we receive server error,
Server error issue on manual import export is already reported.(Jira NF-3271 for reference.)

Testing status

1. Every Year of first month event should be of Open Enrollment. Tested working fine.
5. WEF Process Flag whether to run or not. As discussed this point can not be tested by UI

Smita Pawar Please update stage and Production ETA.
Sachin Hingole

WT-10131 & WT-10132 are open hence assigning back to Dev once all issues will get fixed pl assign to QA

There is no outstanding blockage to fix the issue. So I am assigning to you back.

Thanks,
Revan

Testing of above incremental transactions is done

Testing status :

1. Every Year of first month event should be of Open Enrollment - Done
2. Should have offer specific coverage element on the file. (OFFR=COVG)
Ex.
If OFFR IS open enrollment then should coverage event must be of Open Enrollment - Done
3. Employee has Continuous enrollment from last year his enrollment effective must be
reflected as current year start date.
Ex.
Employee Name - Abc
Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
Termination Date- Null - Done
Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null.
4.Should be identifiable eligibility records associated with offer as unique - Done Checked for random employees.
5.WEF Process Flag whether to run or not - Unable to check by UI

This is working as expected . Hence marking it as ready for stage.

Thanks,
Yogita

CC - Mandar Kulkarni Smita Pawar Prajakta Belhe

Revansiddha Gaur

Hi Revan,

While testing the incremental transactions on metso we found below issues

1. OFFER != COVG(Some employees got multiple offers and single COVG).
2. ELIG seg is not rolled out for some employees even they are eligible for plans.

Please check.

Please find below template details for same:

Environment - Stage
Company - Metso benefits
Template name - Metso_ADP_ACA_WT9760

Let me know if something else needed.

Thanks,
Yogita

CC - Mandar Kulkarni Prajakta Belhe Smita Pawar

Revansiddha Gaur

Hi Revan,

Below employees got multiple offers but only one COVG segment:

Tester Holt
Mario Test
Gertrude Testton
Bruce Tester

I have attached exported file of date range 01/01/2017 - 09/27/2017.

Sending you password of file in mail.

Below are the template details:

Environment - Stage
Company - Metso benefits
Template name - Metso_ADP_ACA_WT9760

Let me know if something else needed.

Thanks,
Yogita

CC - Mandar Kulkarni | Smita Pawar | Prajakta Belhe

Hi Revansiddha Gaur,

Check in was needs to be done against Jira 'WT-10131' as its status is Reopen.

We have verified above mentioned issue on Stage [Metso for Hspl.
Its working fine.]
Verified points are as follows.
1. Every Year of first month event should be of Open Enrollment - Done
This is only for open enrollment changes
2. Should have offer specific coverage element on the file. (OFFR=COVG)
Ex.
If OFFR IS open enrollment then should coverage event must be of Open Enrollment - Done
3. Employee has Continuous enrollment from last year his enrollment effective must be
reflected as current year start date.
Ex.
Employee Name - Abc
Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
Termination Date- Null - Done
4.Should be identifiable eligibility records associated with offer as unique - Done Checked for random employees.

This change request is ready for Production

Hi All,
Attaching production deployment approval email for reference:
!Re Request for Production deployment - 25 Nov 2017.msg
Regards
Gaurav