DELETE FROM f1_bus_obj_alg WHERE f1_bus_obj_alg.bus_obj_cd = 'C1-AccountBO' AND f1_bus_obj_alg.alg_cd = 'TA-CRECON   ';
Insert into F1_BUS_OBJ_ALG (BUS_OBJ_CD,BO_SEVT_FLG,SEQ_NUM,ALG_CD,VERSION,OWNER_FLG) values ('C1-AccountBO                  ','F1PO',10,'TA-CRECON   ',1,'CM  ');
----------------------------------------------------------------------------------------------------------------------------------Automatic Contract Creation
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'PERS' AND CHAR_TYPE_CD = 'TA_BRTDT';
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'PERS' AND CHAR_TYPE_CD = 'TA_PERCT';
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','PERS','TA_BRTDT','N','N',1,' ');
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','PERS','TA_PERCT','N','N',1,' ');
----------------------------------------------------------------------------------------------------------------------------------Person Party Char Configuration
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'ACCT' AND CHAR_TYPE_CD = 'TA_F_ANO';
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'ACCT' AND CHAR_TYPE_CD = 'TA_F_ATY';
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'ACCT' AND CHAR_TYPE_CD = 'TA_F_BEX';
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'ACCT' AND CHAR_TYPE_CD = 'TA_F_IGA';
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'ACCT' AND CHAR_TYPE_CD = 'TA_TAXST';
DELETE FROM CI_CIS_DIV_VLD_CTY WHERE CIS_DIVISION = 'USA' AND CHAR_ENTITY_FLG = 'ACCT' AND CHAR_TYPE_CD = 'TA_BLNGP';
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','ACCT','TA_F_ANO','N','N',1,' ');
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','ACCT','TA_F_ATY','N','N',1,' ');
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','ACCT','TA_F_BEX','N','N',1,' ');
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','ACCT','TA_F_IGA','N','N',1,' ');
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','ACCT','TA_TAXST','N','N',1,' ');
Insert into CI_CIS_DIV_VLD_CTY (CIS_DIVISION,CHAR_ENTITY_FLG,CHAR_TYPE_CD,MANDATORY_SW,ACTIVE_SW,VERSION,ENABLED_FLG) values ('USA  ','ACCT','TA_BLNGP','N','N',1,' ');
----------------------------------------------------------------------------------------------------------------------------------Account Party Char Configuration
DELETE FROM CI_ADJ_TY_ALG WHERE ADJ_TYPE_CD = 'TA_WO   ';
DELETE FROM CI_ADJ_TYPE_L WHERE ADJ_TYPE_CD = 'TA_WO   ';
DELETE FROM CI_ADJ_TYPE WHERE ADJ_TYPE_CD = 'TA_WO   ';
Insert into CI_ADJ_TY_ALG (ADJ_TYPE_CD,ATY_ALG_ENTITY_FLG,SEQ_NUM,ALG_CD,VERSION) values ('TA_WO   ','ADJT',1,'TA_ADJT-NM  ',1);
Insert into CI_ADJ_TYPE_L (ADJ_TYPE_CD,LANGUAGE_CD,DESCR,DESCR_ON_BILL,VERSION) values ('TA_WO   ','ENG','WRITEOFF - Bill Writeoff Adjustment type',' ',3);
Insert into CI_ADJ_TYPE (ADJ_TYPE_CD,AP_REQ_TYPE_CD,DST_ID,CURRENCY_CD,SYNCH_CUR_SW,DFLT_AMT,AP_1099_FLG,VERSION,PRT_DFLT_SW,AD_FRZ_OPT_FLG,ADJ_AMT_TYPE_FLG,APPR_PROF_CD,INFLNC_BILL_BAL,REF_OPTION_FLG) values ('TA_WO   ','        ','BK - A/R  ','USD','N',0,'  ',3,'N','ATWL','AMT ','                              ','N','    ');
----------------------------------------------------------------------------------------------------------------------------------Adjustment Type Creation
delete from CI_ADJ_TYP_PROF where ADJ_TYPE_PROF_CD='TA_ATP1 ';
delete from CI_ADJ_TYP_PROF_L where ADJ_TYPE_PROF_CD='TA_ATP1 ';
Insert into CI_ADJ_TYP_PROF (VERSION,ADJ_TYPE_PROF_CD) values (1,'TA_ATP1 ');
Insert into CI_ADJ_TYP_PROF_L (ADJ_TYPE_PROF_CD,LANGUAGE_CD,DESCR,VERSION) values ('TA_ATP1 ','ENG','Adjustment Type Profie for Write Off (FOP Generation)',1);
----------------------------------------------------------------------------------------------------------------------------------Adjustment Type Profile
delete from CI_SAT_ADJ_PROF where CIS_DIVISION='USA  ' and SA_TYPE_CD = 'FEES    ' and ADJ_TYPE_PROF_CD = 'TA_ATP1 ';
Insert into CI_SAT_ADJ_PROF (SA_TYPE_CD,ADJ_TYPE_PROF_CD,CIS_DIVISION,VERSION) values ('FEES    ','TA_ATP1 ','USA  ',1);
----------------------------------------------------------------------------------------------------------------------------------Contract Type Adjustment Profile
SET DEFINE OFF;
delete from CI_ACCT_NBR_TYPE where ACCT_NBR_TYPE_CD = 'C1_F_ANO';
Insert into CI_ACCT_NBR_TYPE (ACCT_NBR_TYPE_CD,BUS_OBJ_CD,BO_STATUS_CD,BO_DATA_AREA,VERSION,ACCT_NBR_VAL_ALG_CD) values ('C1_F_ANO','2                             ','            ','<CLOB>',3,'C1_DIVACCNBR');
----------------------------------------------------------------------------------------------------------------------------------Account Identifier Validation
SET DEFINE OFF;
delete from CI_WFM where WFM_NAME = 'C1_PRASNORDR';
delete from CI_WFM_L where WFM_NAME = 'C1_PRASNORDR';
delete from CI_WFM_OPT where WFM_NAME = 'C1_PRASNORDR';
Insert into CI_WFM (WFM_NAME,VERSION,EXT_SYS_TYP_FLG) values ('C1_PRASNORDR',2,'ORDR');
Insert into CI_WFM_L (WFM_NAME,LANGUAGE_CD,VERSION,DESCR) values ('C1_PRASNORDR','ENG',1,'Global Person Crawl Order');
Insert into CI_WFM_OPT (WFM_NAME,SEQ_NUM,VERSION,WFM_OPT_VAL,EXT_OPT_TYPE) values ('C1_PRASNORDR',10,1,'C1_PRASN_PP','ALGO');
Insert into CI_WFM_OPT (WFM_NAME,SEQ_NUM,VERSION,WFM_OPT_VAL,EXT_OPT_TYPE) values ('C1_PRASNORDR',1,4,'AGREED_PRICELIST','ORDR');
Insert into CI_WFM_OPT (WFM_NAME,SEQ_NUM,VERSION,WFM_OPT_VAL,EXT_OPT_TYPE) values ('C1_PRASNORDR',2,2,'ASCENDING','ORDR');
----------------------------------------------------------------------------------------------------------------------------------Price Assignment Search for Global Person
SET DEFINE OFF;
delete from CI_FILETYPE_DIVISION where UPLD_FLTY_CD = 'TA_PUPL ';
delete from CI_FILETYPE_MAPPING where UPLD_FLTY_CD = 'TA_PUPL ';
delete from CI_UPLD_FLTM where UPLD_FLTY_CD = 'TA_PUPL ';
delete from CI_UPLD_FLTM_L where UPLD_FLTY_CD = 'TA_PUPL ';
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','ACCOUNT ID',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','ACCOUNT IDENTIFIER',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','ACCOUNT IDENTIFIER TYPE',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','BANK ACCOUNT',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','CHECK NUMBER',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','CURRENCY',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','DATE RECEIVED',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','MATCH TYPE',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','MATCH VALUE',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','MICR ID',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT AMOUNT',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR TYPE1',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR TYPE2',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR TYPE3',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR TYPE4',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR TYPE5',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR VALUE1',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR VALUE2',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR VALUE3',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR VALUE4',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT CHAR VALUE5',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYMENT TYPE',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','PAYOR ID',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','TENDER AMOUNT',null,' ',' ');
Insert into CI_FILETYPE_MAPPING (UPLD_FLTY_CD,FEED_FOR_FLG,BASE_LABEL,CUSTOM_LABEL,TBL_NAME,FLD_NAME) values ('TA_PUPL ','PAYT','TENDER ID',null,' ',' ');
Insert into CI_UPLD_FLTM (UPLD_FLTY_CD,PARSING_ALG_CD,VALIDATION_ALG_CD,SA_TYPE_CD,FEED_FOR,INFO_ALG_CD,TODO_ALG_CD,BO_STATUS_CD,BUS_OBJ_CD,BO_DATA_AREA,STATUS_UPD_DTTM,CREATED_BY,CRET_DTTM,LAST_UPDATED_BY,LAST_UPD_DTTM,VERSION,EXTRACT_ALG_CD,CUSTOM_MOV_STAG_SW) values ('TA_PUPL ','C1-CSVUPLPAY','C1-PUPLVALID','        ','PAYT','            ','            ','            ','                              ',' ',to_date('22-05-24','DD-MM-RR'),'SYSUSER',to_date('22-05-24','DD-MM-RR'),'SYSUSER',to_date('22-05-24','DD-MM-RR'),2,'            ','N');
Insert into CI_UPLD_FLTM_L (UPLD_FLTY_CD,LANGUAGE_CD,DESCR,VERSION) values ('TA_PUPL ','ENG','Payment Upload File Type',1);
----------------------------------------------------------------------------------------------------------------------------------File Type
delete from CI_MATCH_TYPE where match_type_cd = 'BILL-R  ';
delete from CI_MATCH_TYPE_L where match_type_cd = 'BILL-R  ';
Insert into CI_MATCH_TYPE (MATCH_TYPE_CD,PAY_DIST_OVRD_ALG,VERSION,MANL_DIST_ALG,MATCH_TYPE_ENTITY_TYPE,MATCH_TYPE_SRCH_ZONE,MATCH_TYPE_ENTITY_FLG) values ('BILL-R  ','C1-PDOV-PYBL',15,'C1-MD-BILL  ','BILL','C1-ARCSRCH  ','BILL');
Insert into CI_MATCH_TYPE_L (MATCH_TYPE_CD,LANGUAGE_CD,DESCR,VERSION) values ('BILL-R  ','ENG','By Bill Regular',15);
----------------------------------------------------------------------------------------------------------------------------------Match Type
delete from CI_TNDR_SRCE where TNDR_SOURCE_CD = 'CASH    ';
delete from CI_TNDR_SRCE_L where TNDR_SOURCE_CD = 'CASH    ';
Insert into CI_TNDR_SRCE (TNDR_SOURCE_CD,TNDR_SRCE_TYPE_FLG,SA_ID,CURRENCY_CD,EXT_SOURCE_ID,BANK_ACCT_KEY,BANK_CD,VERSION,DFLT_START_BALANCE,MAX_AMT_BALANCE) values ('CASH    ','CASH','0058804408','USD','CASH                          ','BK  ','RMBBK',3,0,0);
Insert into CI_TNDR_SRCE_L (TNDR_SOURCE_CD,LANGUAGE_CD,DESCR,VERSION) values ('CASH    ','ENG','Online Payment',3);
----------------------------------------------------------------------------------------------------------------------------------Tender Source Code
delete from CI_TENDER_TYPE where TENDER_TYPE_CD IN ('CHCK', 'APCK');
delete from CI_TENDER_TYPE_L where TENDER_TYPE_CD IN ('CHCK', 'APCK');
Insert into CI_TENDER_TYPE (TENDER_TYPE_CD,VERSION,LIKE_CASH_SW,GENERATE_APAY_SW,EXT_TYPE_FLG,REQ_EXT_SRC_ID_SW,REQ_EXPIRE_DT_SW,ALLOW_CASH_BACK_SW,BUS_OBJ_CD,TENDER_AUTH_FLG) values ('APCK',1,'N','Y','27','N','N','Y','                              ','C1NR');
Insert into CI_TENDER_TYPE (TENDER_TYPE_CD,VERSION,LIKE_CASH_SW,GENERATE_APAY_SW,EXT_TYPE_FLG,REQ_EXT_SRC_ID_SW,REQ_EXPIRE_DT_SW,ALLOW_CASH_BACK_SW,BUS_OBJ_CD,TENDER_AUTH_FLG) values ('CHCK',1,'N','N','  ','N','N','N','                              ','C1NR');
Insert into CI_TENDER_TYPE_L (TENDER_TYPE_CD,LANGUAGE_CD,DESCR,VERSION) values ('APCK','ENG','Checking - Auto Pay',1);
Insert into CI_TENDER_TYPE_L (TENDER_TYPE_CD,LANGUAGE_CD,DESCR,VERSION) values ('CHCK','ENG','Cheque',1);
----------------------------------------------------------------------------------------------------------------------------------Tender Type
SET DEFINE OFF;
delete from C1_CUST_REG_TMPL where TEMPLATE_CD = 'PERSN_BNK     ';
delete from C1_CUST_REG_TMPL_L where TEMPLATE_CD = 'PERSN_BNK     ';
delete from C1_CUST_REG_TMPL_PAGE where TEMPLATE_CD = 'PERSN_BNK     ';
delete from C1_CUST_REG_TMPL_PAGE_FLD where TEMPLATE_CD = 'PERSN_BNK     ';
delete from C1_CUST_REG_TMPL_PAGE_SECTION where TEMPLATE_CD = 'PERSN_BNK     ';
Insert into C1_CUST_REG_TMPL (TEMPLATE_CD,TEMPLATE_CAT_FLG,BUS_OBJ_CD,BO_DATA_AREA,VERSION) values ('PERSN_BNK     ','PERS','C1-CustomerRegistrationTmplBK ',' ',3);
Insert into C1_CUST_REG_TMPL_L (TEMPLATE_CD,LANGUAGE_CD,DESCR,DESCRLONG,VERSION) values ('PERSN_BNK     ','ENG','Person Template - Banking','Person Template - Banking',1);
Insert into C1_CUST_REG_TMPL_PAGE (TEMPLATE_CD,TEMPLATE_PAGE_FLG,VERSION) values ('PERSN_BNK     ','ACCT',2);
Insert into C1_CUST_REG_TMPL_PAGE (TEMPLATE_CD,TEMPLATE_PAGE_FLG,VERSION) values ('PERSN_BNK     ','CTIN',3);
Insert into C1_CUST_REG_TMPL_PAGE (TEMPLATE_CD,TEMPLATE_PAGE_FLG,VERSION) values ('PERSN_BNK     ','DEAL',3);
Insert into C1_CUST_REG_TMPL_PAGE (TEMPLATE_CD,TEMPLATE_PAGE_FLG,VERSION) values ('PERSN_BNK     ','MAIN',3);
Insert into C1_CUST_REG_TMPL_PAGE (TEMPLATE_CD,TEMPLATE_PAGE_FLG,VERSION) values ('PERSN_BNK     ','PCHR',3);
Insert into C1_CUST_REG_TMPL_PAGE (TEMPLATE_CD,TEMPLATE_PAGE_FLG,VERSION) values ('PERSN_BNK     ','PEHC',3);
Insert into C1_CUST_REG_TMPL_PAGE (TEMPLATE_CD,TEMPLATE_PAGE_FLG,VERSION) values ('PERSN_BNK     ','REGC',3);
Insert into C1_CUST_REG_TMPL_PAGE_FLD (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,FLD_NAME,VERSION,SEQNO,REQUIRED_SW,EDITABLE_SW_1,FLD_VAL,CHAR_TYPE_CD,CHAR_VAL,ADHOC_CHAR_VAL,CHAR_VAL_FK1,CHAR_VAL_FK2,CHAR_VAL_FK3,CHAR_VAL_FK4,CHAR_VAL_FK5,SRCH_CHAR_VAL,EDITABLE_SW_2,PRIM_SW,FLD_TYPE_VAL) values ('PERSN_BNK     ','MAIN','PEMA','BIRTH_DT                      ',1,2,'N','Y','2019-01-01','        ','                ',' ',' ',' ',' ',' ',' ',' ','N','N',' ');
Insert into C1_CUST_REG_TMPL_PAGE_FLD (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,FLD_NAME,VERSION,SEQNO,REQUIRED_SW,EDITABLE_SW_1,FLD_VAL,CHAR_TYPE_CD,CHAR_VAL,ADHOC_CHAR_VAL,CHAR_VAL_FK1,CHAR_VAL_FK2,CHAR_VAL_FK3,CHAR_VAL_FK4,CHAR_VAL_FK5,SRCH_CHAR_VAL,EDITABLE_SW_2,PRIM_SW,FLD_TYPE_VAL) values ('PERSN_BNK     ','MAIN','PEMA','CIS_DIVISION                  ',1,1,'N','N','CAL','        ','                ',' ',' ',' ',' ',' ',' ',' ','N','N',' ');
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','CTIN','PEAD',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','CTIN','PEEM',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','DEAL','DEMA',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','MAIN','PEID',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','MAIN','PEMA',3);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','MAIN','PENA',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','MAIN','PEPH',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','PCHR','PECH',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','PEHC','PHCH',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','PEHC','PHMA',2);
Insert into C1_CUST_REG_TMPL_PAGE_SECTION (TEMPLATE_CD,TEMPLATE_PAGE_FLG,TEMPLATE_SEC_FLG,VERSION) values ('PERSN_BNK     ','REGC','CURC',2);
----------------------------------------------------------------------------------------------------------------------------------Customer Registration Template
delete from C1_CUST_REG_TYPE_TMPL where CUST_REG_TYPE_CD = 'BANKING                       ' and TEMPLATE_CAT_FLG = 'PERS';
Insert into C1_CUST_REG_TYPE_TMPL (CUST_REG_TYPE_CD,SEQNO,TEMPLATE_CAT_FLG,TEMPLATE_CD,VERSION,REFERRED_COUNT) values ('BANKING                       ',10,'PERS','PERSN_BNK     ',1,71);
----------------------------------------------------------------------------------------------------------------------------------Customer Registration Type