Untitled

delete from kb_case_field where KCF_PROD_CODE = 171;

INSERT INTO kb_case_field
(KCF_PROD_CODE, KCF_SEC_CODE, KCF_FILD_NAME, KCF_SEQ, KCF_SEC_BREAK, KCF_KBP_TYPE)
VALUES
(171,'APPLY_FORM','CASE_APPLY_LANG',10,'Y',NULL),
(171,'APPLY_FORM','CASE_UPSELL_CONSENT',20,'N',NULL),

(171,'CMP_INFO','CASE_CAMP_DESC',5,'Y',NULL),
(171,'CMP_INFO','CASE_PRODUCTNAME',15,'N',NULL),
(171,'CMP_INFO','CASE_MARKETING_CODE',25,'N',NULL),
(171,'CMP_INFO','CASE_PARTNER_NAME',50,'N',NULL),

(171,'CRDT_INFO','CASE_EXIST_PROV_CC',10,'Y',NULL),
(171,'CRDT_INFO','CASE_CC_EXPIRY_DT',20,NULL,NULL),
(171,'CRDT_INFO','CASE_CREDIT_HIST',30,NULL,NULL),
(171,'CRDT_INFO','CASE_HP_HIST',40,'N',NULL),
(171,'CRDT_INFO','CASE_MG_HIST',50,'N',NULL),
(171,'CRDT_INFO','CASE_PL_HIST',60,'N',NULL),
(171,'CRDT_INFO','CASE_CRED_FAC_DURATION',70,'N',NULL),
(171,'CRDT_INFO','CASE_PTPTN_LOAN',80,'N',NULL),
(171,'CRDT_INFO','CASE_ASB_LOAN',90,'N',NULL),
(171,'CRDT_INFO','CASE_CARD_TYPE',95,'N',NULL),

(171,'CSE_INFO','CASE_UPLOAD_STATUS_REASON',10,'Y',NULL),
(171,'CSE_INFO','CASE_FOLLOW_UP_REASON',15,'N',NULL),
(171,'CSE_INFO','CASE_NOTES',20,'N',NULL),
(171,'CSE_INFO','CASE_STATEMENT_LOCATION',30,NULL,NULL),

(171,'CUST_INFO','CASE_NAME',10,'Y',NULL),
(171,'CUST_INFO','CASE_SALUTATION',11,NULL,NULL),
(171,'CUST_INFO','CASE_SOW',12,NULL,NULL),
(171,'CUST_INFO','CASE_NAME_ON_CARD',13,NULL,NULL),
(171,'CUST_INFO','CASE_PHONE',20,NULL,NULL),
(171,'CUST_INFO','CASE_EMAILADDR',30,NULL,NULL),
(171,'CUST_INFO','CASE_MONTHLY_INCOME',40,NULL,NULL),
(171,'CUST_INFO','CASE_PREFERRED_LANG',50,NULL,NULL),
(171,'CUST_INFO','CASE_PRIVACY_NOTICE',60,'Y',NULL),
(171,'CUST_INFO','CASE_GENDER',70,NULL,NULL),

(171,'EMPT_INFO','CASE_BUS_CLASS',10,NULL,NULL),
(171,'EMPT_INFO','CASE_CUSTOMER_OCCUP',11,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_STS',20,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_TYPE',21,NULL,NULL),
(171,'EMPT_INFO','CASE_DATE_JOIN',30,'Y',NULL),
(171,'EMPT_INFO','CASE_EMP_NAME',40,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_SECTOR',50,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_SUBSECTOR',60,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_PHONE',70,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_ADDR1',80,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_ADDR2',90,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_ADDR3',100,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_CITY',110,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_STATE',120,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_POSTCODE',130,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_MTH',140,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_YEAR',150,NULL,NULL),
(171,'EMPT_INFO','CASE_PREV_EMP',160,NULL,NULL),
(171,'EMPT_INFO','CASE_PREV_OCCP',170,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_PREV_MTH',180,NULL,NULL),
(171,'EMPT_INFO','CASE_EMP_PREV_YEAR',190,NULL,NULL),

(171,'RCPT_INFO','CASE_REG_NO_TYPE',10,NULL,NULL),
(171,'RCPT_INFO','CASE_REG_NO',20,NULL,NULL),
(171,'RCPT_INFO','CASE_RACE',30,NULL,NULL),
(171,'RCPT_INFO','CASE_NUM_DEPENT',40,NULL,NULL),
(171,'RCPT_INFO','CASE_EDU_LEVEL',50,NULL,NULL),
(171,'RCPT_INFO','CASE_MART_STATUS',60,NULL,NULL),

(171,'OTHR_DTLS','CASE_EMG_CONT_NAME',10,'Y',NULL),
(171,'OTHR_DTLS','CASE_EMG_REL',20,NULL,NULL),
(171,'OTHR_DTLS','CASE_EMG_CONT_PHONE',30,NULL,NULL),
(171,'OTHR_DTLS','CASE_MOTHER_NAME',40,NULL,NULL),
(171,'OTHR_DTLS','CASE_SOURCE_FND',50,NULL,NULL),
(171,'OTHR_DTLS','CASE_PURPOSE_ACCTOPN',60,NULL,NULL),

(171,'PRSL_INFO','CASE_OTH_ADDR1',10,'Y',NULL),
(171,'PRSL_INFO','CASE_OTH_ADDR2',20,NULL,NULL),
(171,'PRSL_INFO','CASE_OTH_ADDR3',30,NULL,NULL),
(171,'PRSL_INFO','CASE_OTH_CITY',50,NULL,NULL),
(171,'PRSL_INFO','CASE_OTH_STATE',58,NULL,NULL),
(171,'PRSL_INFO','CASE_OTH_POSTCODE',60,NULL,NULL),
(171,'PRSL_INFO','CASE_ADDR1',61,'N',NULL),
(171,'PRSL_INFO','CASE_ADDR2',62,'N',NULL),
(171,'PRSL_INFO','CASE_ADDR3',63,'N',NULL),
(171,'PRSL_INFO','CASE_CITY',65,'N',NULL),
(171,'PRSL_INFO','CASE_STATE',66,'N',NULL),
(171,'PRSL_INFO','CASE_POSTCODE',67,'N',NULL),
(171,'PRSL_INFO','CASE_RESIDENCY',70,NULL,NULL),
(171,'PRSL_INFO','CASE_RESIDENCY_START_DT',75,'N',NULL),
(171,'PRSL_INFO','CASE_MOVEIN_YEAR',80,NULL,NULL),
(171,'PRSL_INFO','CASE_MOVEIN_MONTH',90,NULL,NULL),

(171,'BSNS_LN','CASE_BL_REG_NO',10,NULL,NULL),
(171,'BSNS_LN','CASE_RHB_DIRECTORSHIP',20,NULL,NULL),
(171,'BSNS_LN','CASE_EMP_REG_DATE',30,NULL,NULL),
(171,'BSNS_LN','CASE_MNC_COMP',40,NULL,NULL),
(171,'BSNS_LN','CASE_PAID_CAPITAL',50,NULL,NULL);