Estimations 20 days

Please start the Documentation development for the same.
Yogesh Chaudhari

Mahendra Mungase Smita Pawar Sachin Hingole
Ramya Tantry Kumar Chhajed Yogesh Chaudhari Nandkumar Prabhakar Karlekar

Please find the analysis document and specification.
Import Specification.xls WT-4579 Analysis Document.doc Test Cases.xls

Regards,
Revan

Hi Ramya Tantry,

Scenario : Plan start month is not provided uniquely in the importing file.

Reference : "Analysis Document Point : 10. PlanStartMonth (1095 c Part-2) : Always latest from correction table. if first time import will refer from import file of first record."

As per discussion again with Nandkumar, Without any modifying data of plan start month should save in underlying correction table but should refer latest record's plan start month while generating 1095c pdf file.

Regards,
Revan

Mahendra Mungase Smita Pawar Sachin Hingole
Yogesh Chaudhari Kumar Chhajed Nandkumar Prabhakar Karlekar

Revansiddha Gaur

This is already implemented from my side as this was discussed in the analysis meeting.
This change has been already deployed on LB.

CC: Nandkumar Prabhakar Karlekar Sachin Hingole

Hi Mahendra Mungase,

Please share TCs with Revan

Thanks,
Sachin Hingole

Revansiddha Gaur Nandkumar Prabhakar Karlekar

Hi Revansiddha Gaur

We have attached P1 test cases with same ticket.

File Name- "P1_Test_Case_WT4579.xls"

Sachin Hingole Nandkumar Prabhakar Karlekar

Thanks,
Mahendra

From 17th october working on BSG FILES .Hence this task is kept on hold.

Nandkumar Prabhakar Karlekar Sachin Hingole shyam sharma

Hi Revansiddha Gaur,

I am done with coding for following changes,

• Add button on 1095C Correction page to redirect it on import page and redierction functionality.
• Add button on 1095C Correction page to download 1095C import template and its download functionality.

As there are no titles mentioned in Analysis document for newly added buttons, I have kept them as "Import Corrections" and "Download Template". You can change them as per your convenience.

I have raised a code review request to you for these changes.

I couldn't find any sample import file attached with JIRA to check test scenarios, please provide it so that I can start with testing.

CC: Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Abhijeet Khandagale

Please find the test cases and test files which I have already done. You need to fire the test cases for the remaining. Import Dummy Data.zip Test Cases.xls

Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Abhijeet Khandagale

Code review will be done once all test cases finished by testing.

1. "Import Corrections" change to "Bulk Import Correction" and "Download Template" change to "Download Specification".

Nandkumar Prabhakar Karlekar Ramya Tantry

Hi Revansiddha Gaur,

I was not able to work on this because of other priority issues and code setup videos. I will start working on remaining test cases tomorrow.

CC: Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Hi Revansiddha Gaur,

Working on WT-5957 today.

CC: Yogesh Chaudhari Nandkumar Prabhakar Karlekar

Hi Revansiddha Gaur,

Working on ACA report issue on Pre-Stage, after that I will continue on this.

CC: Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Hi Revansiddha Gaur,.

Please find testing details in an attachment. Testing Files.zip

I will start fixing failed scenarios from these test cases from today after understanding import logic and functionality.

I am going to need your help to do so.

CC: Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Revansiddha Gaur,

Is this enhancement is going to deploy on LB today?

Affected Files :
/branches/LB/App/BusinessLogic/CollectionManager/CollectionManager.vb
/branches/LB/App/BusinessLogic/Employee/ImportExportSettings.vb
/branches/LB/App/BusinessLogic/ImportExportDTS/ExecuteImportDTS.vb
/branches/LB/App/BusinessLogic/ImportExportDTS/ImportValidation.vb
/branches/LB/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Export_GetSubtemplateFieldsMappingData.StoredProcedure.sql
/branches/LB/Database Objects/MasterCompanyDB/07_Data/219_WT-4579_WTB_ACA_NewData_ImportExportType.sql
/branches/LB/Database Objects/MasterCompanyDB/07_Data/220_WT-4579_WTB_ACA_NewData_TableRef.sql
/branches/LB/Database Objects/MasterCompanyDB/07_Data/221_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/149_WT-4579_WTB_ACA_NewData_ImportExportType.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/150_WT-4579_WTB_ACA_NewData_ImportExportType.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/151_WT-4579_WTB_ACA_NewData_TableRef.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/152_WT-4579_WTB_ACA_NewData_TableRef.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/153_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/154_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/155_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/156_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/157_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/158_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/159_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/160_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/161_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/162_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/163_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/164_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/165_WT-4579_WTB_ACA_NewData_Fields.sql
/branches/LB/Database Objects/OnlineEnrollment/07_Data/166_WT-4579_WTB_ACA_NewData_Fields.sql

Abhijeet Khandagale

Please update the affected files list in the comment.

Thanks &regards,
Revan

Code Review- Revansiddha & Nandkumar,Jaideep for import Functionality

Affected files:

• Database Objects/OnlineEnrollment/07_Data/149_WT-4579_WTB_ACA_NewData_PageLevelAccess.sql
• Shared Library/WORKTERRALocalization/WORKTERRAResource.Designer.cs
• Shared Library/WORKTERRALocalization/WORKTERRAResource.es-mx.resx
• Shared Library/WORKTERRALocalization/WORKTERRAResource.fr-CA.resx
• Shared Library/WORKTERRALocalization/WORKTERRAResource.resx
• Web/Web Projects/BenAdmin/Areas/ACA/Controllers/ACA1095CCorrection/ACA1095CCorrectionController.cs
• Web/Web Projects/BenAdmin/Areas/ACA/Models/ACA1095CCorrection/ACA1095CCorrectionModel.cs
• Web/Web Projects/BenAdmin/Areas/ACA/Views/ACA/ACA1095CCorrection/ACA1095CCorrection.cshtml

As all related issues are tested on LB and enhancement is working fine.
Change request is not considered in this release.
Enhancement is ready for Stage.

We have completed basic testing of Part II on Production [Marqutte ] production company.
Testing of Part III import is in progress