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
---------------------------------------------------------------------------------------------------