TCFDS_CUST_SCORE_MTHY_SNP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 MTH_END_DATE DATE 4
3 DATE_ID INTEGER 4
4 PERS_TXN_SCORE_VAL BIGINT 8
5 BUS_TXN_SCORE_VAL BIGINT 8
6 SAVINGS_ACCT_SCORE_VAL BIGINT 8
7 TRM_DPTS_SCORE_VAL BIGINT 8
8 HME_LN_SCORE_VAL BIGINT 8
9 BUS_LN_SCORE_VAL BIGINT 8
10 PERS_LN_SCORE_VAL BIGINT 8
11 ASSET_LNE_MRGN_SCORE_VAL BIGINT 8
12 CR_CRD_SCORE_VAL BIGINT 8
13 EQUIPMENT_FIN_SCORE_VAL BIGINT 8
14 TREASURY_SCORE_VAL BIGINT 8
15 MRCH_SCORE_VAL BIGINT 8
16 SUPER_INVSTMT_SCORE_VAL BIGINT 8
17 LIFE_RISK_SCORE_VAL BIGINT 8
18 HME_INS_SCORE_VAL BIGINT 8
19 MOT_INS_SCORE_VAL BIGINT 8
20 RETAIL_INS_SCORE_VAL BIGINT 8
21 COMPLETE_CUST_SCORE_VAL BIGINT 8
22 DATA_LOAD_DATE DATE 4
23 SNPSHT_DATE DATE 4
24 SRC_SYS_ID CHARACTER VARYING(5) 5
25 LOAD_ID BIGINT 8
26 HOUSEHOLD_ID INTEGER 4
27 RB_DOM_CODE CHARACTER VARYING(100) 100
28 RB_DOM_NAM CHARACTER VARYING(100) 100
29 RB_DOM_RULE_NUM BIGINT 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 BIGINT 8
39 RB_FOOTING_LN_RANK BIGINT 8
40 RB_FOOTING_TRM_RANK BIGINT 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 BIGINT 8
54 MARG_LEND_SCORE_VAL BIGINT 8
55 FLEXI_VAL BIGINT 8