Scripts for adding and inserting columns : 1.Adding CurrencyAndDateFormatRuleID column in Payroll 2.Inserting CurrencyAndDateFormatRuleID in Fields related tables 3.Other Unique Identifier - DDL(Adding) and DATA (inserting Fields related tables) 1.Script for Employee_Payroll ||| Employee_Payroll_Intermediate ||| Employee_Payroll_History --------------------------Employee Payroll tablees DDL--------------------------------------- 425_NF-7_WTB_EDS_ModTable_Employee_Payroll_Intermediate ----------------------------------------------------------------------------------------------------- 2. Script to add coloum of other unique identifier ----------------Other Unique Identifier DDL -------------------------------------- 430_NF-11_WTB_EDS_ModTable_Employee 432_NF-11_WTB_EDS_ModTable_Employee_Intermediate 432_NF-11_WTB_EDS_ModTable_Employee_Intermediate -------------------------------------------------------------------------------------- 3.Script to insert CurrencyFormatandDateID in Field related tables -------------------------------- Currency and Date format ID DATA --------------------------- 257_NF-7_WTB_EDS_NewData_Fields 259_NF-7_WTB_EDS_NewData_MemberFieldRights 258_NF-7_WTB_EDS_NewData_FieldsLabel_Multilingual 260_NF-7_WTB_EDS_NewData_FieldValidation 263_NF-7_WTB_EDS_NewData_MemberFieldRights 262_NF-7_WTB_EDS_NewData_FieldsLabel_Multilingual 265_NF-7_WTB_EDS_NewData_FieldValidation 271_NF-7_WTB_EDS_NewData_EligibilityCriteriaLookup 261_NF-7_WTB_EDS_NewData_Fields -------------------------------------------------------------------------------------------------------------------- 4. Script to insert Other Unique Identifier in Field related tables -------------------------------Other Unique Identifier Data------------------------------ 290_NF-11_WTB_EDS_NewData_Fields 291_NF-11_WTB_EDS_NewData_FieldsLabel_Multilingual 292_NF-11_WTB_EDS_NewData_MemberFieldRights 293_NF-11_WTB_EDS_NewData_FieldValidation 299_NF-11_WTB_EDS_NewData_Fields 299_NF-11_WTB_EDS_NewData_Fields 301_NF-11_WTB_EDS_NewData_EligibilityCriteriaLookup 300_NF-11_WTB_EDS_NewData_FieldsLabel_Multilingual 302_NF-11_WTB_EDS_NewData_MemberFieldRights 303_NF-11_WTB_EDS_NewData_FieldValidation ---------------------------------------------------------------------------------------------------