Hello Chris Ellenberger,

We have scheduled this enhancement on Monday(04/11/2016) as per our estimation it needs 10 working days for development
and 2.5 working days for local testing.

Thanks

CC-- Samir Vinayak Kulkarni Satya Hrishikesh Deshpande Aniruddha Dev

Rohan J KhandaveKiyo Takahashi[~chimane@ebsbenefits.com]

Hi Rohan,

Can you please provide the expected date for production deployment? I need to quote ETA of next test file to the broker.

In EDI-22, ETA for QA testing deployment is 4/22/2016. +2.5 working days for local testing = 4/26 - 4/27 Prod deployment? Please confirm.

Thanks,
Chris

Chris Ellenberger

Hi Chris,

ETA for QA Testing deployment as per our patch process is given below

LB Deployment - 04/22/2016
Stage Deployment - 04/27/2016
Production Deployment - 05/03/2016

Thanks & Regards,
Aniruddha Dev

Affected Files:

1)App/BusinessLogic/ImportExportDTS/CommonExportRoutines.vb
2)App/BusinessLogic/ImportExportDTS/ExportConstants.vb
3)App/BusinessLogic/ImportExportDTS/ExportProcess.vb
4)App/BusinessLogic/ImportExportDTS/ExportProcessRowwise.vb
5)DatabaseObjects/MasterCompanyDB/
01_DDL/60_WT1667_WTB_Export_NewTable_ExportEnrollmentAndDemograhicChangeType.sql
6)Database Objects/MasterCompanyDB/01_DDL/61_WT1667_WTB_Export_NewData_Fields.sql
7)Database Objects/MasterCompanyDB/04_StoredProcedures/
OES_SP_Export_GetEnrollmentAndDemographicChangeType.sql
8)DatabaseObjects/MasterCompanyDB/01_DDL/
9)2_WT1667_WTB_Export_NewData_ExportEnrollmentAndDemograhicChangeType
10)Database Objects/OnlineEnrollment/01_DDL/10_WT1667_WTB_Export_NewData_Fields.sql
11)DatabaseObjects/OnlineEnrollment/01_DDL/
_WT1667_WTB_Export_NewTable_ExportEnrollmentAndDemograhicChangeType.sql
12) DatabaseObjects/OnlineEnrollment/01_DDL/
_WT1667_WTB_Export_NewData_ExportEnrollmentAndDemograhicChangeType.sql

Code Review: Rohan K.

Blocked for Testing as getting server error while creating new ANSI template on LB on all companies. Please find attached error log 426201695307AM_1601_2.txt

Mail sent to Ashwin with error log

Hi Aniruddha Dev,

We have solve the LB error while creating ANSI template which get wrong BaseTemplateID in ImportExportDLL.cofig file.

Please check now.

Thanks,
Ganesh

Started testing on Column wise fixed length .Template till the ANSI issue gets resolved.
1) verified Demographic change (DOB) , enrollment Change (Re-Enrollment)
Above two are working fine

As ANSI Issue is resolved now. Will continue testing with ANSI 834 template.

*Testing is in progress *

Macro Name: Enrollment And Demographic Change Type

Hi Ganesh Sadawarte

Created ANSI 834 Template , Mapped Enrollment and Demographic change type field on Subscriber, Spouse and Child sub templates (PFA screenshot for DTS values) on ASML Temp company and verified below scenarios

1) New hire Enrollment
2) Only SSN Change
3) Enrollment Coverage amount change ( by Raising QE with 05/01/2016)
4) Employee Termination
5) Terminate Dependent Plan Elections (Spouse Life and Spouse AD&D)
6) other Demographic Changes (DOB)
7) Class Change (no effect on benefits)
8) SSN Change and Coverage Amount change
9) Terminate Employee Plan Elections

Result : Scenario #5 is not working. I've terminated dependent plan election (for Spouse Life and Spouse AD&D) . Made sure these plans are selected on the template and have their segments on subscriber and spouse sub template. Still the records is not getting exported on the file. WT-2151 is created for the same

Hi Aniruddha Dev,

CC- Rohan J Khandave

As this enhancement is not blocking any record. This is field level enhancement not record level. If any record is exporting on file in that case value field need to proper and if records not exporting file these will another scenarios ca you please continue with you testing as you created separate JIRA for this we will check and update

Thanks,
Ganesh

Verified on Changes only and Full File Columnwise and City of claremont 834 5010 copy Template on ASML temp company on LB for above scenarios including Re-Enrollment scenario (where INS 04 should populate 41 ) for Enrollment and Demographic Change Type.

Working Fine

Note: Also Verified WT-2151. We can handle it through the customization.

Aniruddha Dev

Hello,

We were quoted production deployment for this enhancement today, 5/3. I see it is pending stage approval as of now. Broker just followed up asking if I will be running a file today and I have to say no.

Please advise when this will be deployed ASAP.

Thanks,
Chris

Chris Ellenberger

Hi Chris,

The patch got delayed due to an internal issue found in LB testing . It has fixed now . We will deploy this on production tomorrow and will let you know once its deployed . Regret the inconvenience caused to you .

Thanks & Regards,
Aniruddha Dev

Verified on City of Claremont for HSPL company on stage on 'City of Claremont 834 5010' Template on Stage

Working as expected

Verified this on City of Claremont for HSPL company on Production for 'City of Claremont SunLife 834 5010' template by mapping 'Enrollment and Demographic change type'macro for below fields on INS segment.

1) INS03 Maintenance Type Code
2) INS04 Maintenance Reason Code

and data transformed its values as per attached screenshots.

Working as expected

Chris Ellenberger Kiyo Takahashi

Hello,

We have deployed this on production . Can you please verify this at your end and Close this JIRA ? Please let us know in case of any queries .

Thanks & Regards,
Aniruddha Dev