CDI_TCFDS_CUST_SCORE_WKLY_SNP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

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