Hi All,

We have scanned Production and LB for mismatch in number of columns in main and history tables related export, attached Export_History_table_Count.xls are the details. Below is short summary.

MasterCompanyDB

table ImportExportsettings_History has missing column IsACATemplate.
table ImportExportdeliveryInformation_History has missing column ServiceID

OnlineEnrollmentDB

table ImportExportGlobalTemplate_History has missing column IsACATemplate.
table ImportExportdeliveryInformation_History has missing column ServiceID
table ImportExportGlobaldeliveryInformation_History has missing column ServiceID

We have added serviceID columns in ImportExportDeliveryInformation_History and ImportExportGlobalDeliveryInformation_History tables. Nandkumar Prabhakar Karlekar/Revansiddha Gaur can you please look for IsACATemplate column?

Below are the affected files

/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgUpdImportExportGlobalDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgUpdImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgInsImportExportGlobalDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgInsImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgDelImportExportGlobalDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgDelImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/01_DDL/071_WT-6931_WTB_Export_ModTable_ImportExportGlobalDeliveryInformation_History.sql
/branches/LB/Database Objects/OnlineEnrollment/01_DDL/070_WT-6931_WTB_Export_ModTable_ImportExportDeliveryInformation_History.sql
/branches/LB/Database Objects/MasterCompanyDB/05_Triggers/OES_TR_trgUpdImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/MasterCompanyDB/05_Triggers/OES_TR_trgInsImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/MasterCompanyDB/05_Triggers/OES_TR_trgDelImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/MasterCompanyDB/01_DDL/377_WT-6931_WTB_Export_ModTable_ImportExportDeliveryInformation_History.sql

Hi Nandkumar Prabhakar Karlekar Any update on this?

Hi Nandkumar Prabhakar Karlekar,

As per dicussion with you, This task is on low priority and whenever I will get the free time will focus on this task.

Regards,
Revan

Hi Vinayak Kulkarni

As per above comments, we are going to add only one column ISACATemplate in ImportExportSettings_History table and will make respective changes required for that column.
So we will not scanned again export related data table.

Thanks,
Yogesh Chaudhari

Nandkumar Prabhakar KarlekarNandkumar Prabhakar KarlekarSmita Pawar

We have verified above mentioned change request on LB.
Its working fine.
PFA test cases and testing status.
Enhancement is ready for Stage.

Verified all scenarios mentioned in test cases ,

• MasterCompanyDB
  Verified
  table ImportExportsettings_History has column IsACATemplate. - Pass
  table ImportExportdeliveryInformation_History has column ServiceID - Pass

• OnlineEnrollmentDB
  table ImportExportGlobalTemplate_History has column IsACATemplate.- Pass
  table ImportExportdeliveryInformation_History has column ServiceID- Pass
  table ImportExportGlobaldeliveryInformation_History has column ServiceID- Pass

It is working as expected.

CC-Hrishikesh DeshpandeRakesh Roy