CDI_TCFDS_CUST_SCORE_WKLY_SNP
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CUST_NUM | CHARACTER VARYING(20) | 20 |
| 2 | WEEK_END_DATE | TIMESTAMP | 8 |
| 3 | DATE_ID | BIGINT | 8 |
| 4 | PERS_TXN_SCORE_VAL | DOUBLE PRECISION | 8 |
| 5 | BUS_TXN_SCORE_VAL | DOUBLE PRECISION | 8 |
| 6 | SAVINGS_ACCT_SCORE_VAL | DOUBLE PRECISION | 8 |
| 7 | TRM_DPTS_SCORE_VAL | DOUBLE PRECISION | 8 |
| 8 | HME_LN_SCORE_VAL | DOUBLE PRECISION | 8 |
| 9 | BUS_LN_SCORE_VAL | DOUBLE PRECISION | 8 |
| 10 | PERS_LN_SCORE_VAL | DOUBLE PRECISION | 8 |
| 11 | ASSET_LNE_MRGN_SCORE_VAL | DOUBLE PRECISION | 8 |
| 12 | CR_CRD_SCORE_VAL | DOUBLE PRECISION | 8 |
| 13 | EQUIPMENT_FIN_SCORE_VAL | DOUBLE PRECISION | 8 |
| 14 | TREASURY_SCORE_VAL | DOUBLE PRECISION | 8 |
| 15 | MRCH_SCORE_VAL | DOUBLE PRECISION | 8 |
| 16 | SUPER_INVSTMT_SCORE_VAL | DOUBLE PRECISION | 8 |
| 17 | LIFE_RISK_SCORE_VAL | DOUBLE PRECISION | 8 |
| 18 | HME_INS_SCORE_VAL | DOUBLE PRECISION | 8 |
| 19 | MOT_INS_SCORE_VAL | DOUBLE PRECISION | 8 |
| 20 | RETAIL_INS_SCORE_VAL | DOUBLE PRECISION | 8 |
| 21 | COMPLETE_CUST_SCORE_VAL | DOUBLE PRECISION | 8 |
| 22 | DATA_LOAD_DATE | TIMESTAMP | 8 |
| 23 | SNPSHT_DATE | TIMESTAMP | 8 |
| 24 | SRC_SYS_ID | CHARACTER VARYING(5) | 5 |
| 25 | LOAD_ID | DOUBLE PRECISION | 8 |
| 26 | HOUSEHOLD_ID | BIGINT | 8 |
| 27 | RB_DOM_CODE | CHARACTER VARYING(100) | 100 |
| 28 | RB_DOM_NAM | CHARACTER VARYING(100) | 100 |
| 29 | RB_DOM_RULE_NUM | DOUBLE PRECISION | 8 |
| 30 | RB_DOM_RULE_DESC | CHARACTER VARYING(100) | 100 |
| 31 | RB_MFI_TXN_FLG | CHARACTER VARYING(1) | 1 |
| 32 | RB_MFI_RETIREE_FLG | CHARACTER VARYING(1) | 1 |
| 33 | RB_CHNL_PREF_1 | CHARACTER VARYING(10) | 10 |
| 34 | RB_CHNL_PREF_2 | CHARACTER VARYING(10) | 10 |
| 35 | RB_CHNL_PREF_3 | CHARACTER VARYING(10) | 10 |
| 36 | RB_CHNL_PREF_4 | CHARACTER VARYING(10) | 10 |
| 37 | RB_CHNL_PREF_5 | CHARACTER VARYING(10) | 10 |
| 38 | RB_FOOTING_CALL_RANK | DOUBLE PRECISION | 8 |
| 39 | RB_FOOTING_LN_RANK | DOUBLE PRECISION | 8 |
| 40 | RB_FOOTING_TRM_RANK | DOUBLE PRECISION | 8 |
| 41 | RSHIP_MANAGED_FLG | CHARACTER VARYING(1) | 1 |
| 42 | SGMNT_DESC | CHARACTER VARYING(20) | 20 |
| 43 | CMPLT_CUST_FLG | CHARACTER VARYING(1) | 1 |
| 44 | CMPLT_CUST_BANK_ONLY_FLG | CHARACTER VARYING(1) | 1 |
| 45 | CMPLT_CUST_BANK_OTH_FLG | CHARACTER VARYING(1) | 1 |
| 46 | ALMOST_CMPLT_CUST_FLG | CHARACTER VARYING(1) | 1 |
| 47 | ALMOST_CMPLT_CUST_NO_WLTH_FLG | CHARACTER VARYING(1) | 1 |
| 48 | ALMOST_CMPLT_CUST_NO_INS_FLG | CHARACTER VARYING(1) | 1 |
| 49 | LEAST_CMPLT_CUST_FLG | CHARACTER VARYING(1) | 1 |
| 50 | BANK_AT_RISK_FLG | CHARACTER VARYING(1) | 1 |
| 51 | INS_AT_RISK_FLG | CHARACTER VARYING(1) | 1 |
| 52 | WLTH_AT_RISK_FLG | CHARACTER VARYING(1) | 1 |
| 53 | CMRCL_INS_SCORE_VAL | DOUBLE PRECISION | 8 |
| 54 | MARG_LEND_SCORE_VAL | DOUBLE PRECISION | 8 |
| 55 | FLEXI_VAL | DOUBLE PRECISION | 8 |
| 56 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 57 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 58 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 59 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |