CFD_TCFDD_CUSTOMER_SCORES

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 CIS_CPS_CUST_NUM INTEGER 4
3 CIS_CPS_CODE CHARACTER VARYING(4) 4
4 SNPSHT_YR INTEGER 4
5 SNPSHT_MTH INTEGER 4
6 CUST_ID BIGINT 8
7 CUST_SCORE_SEGMENT_ID BIGINT 8
8 QUALIFYING_CA_NODE INTEGER 4
9 CA_NODE INTEGER 4
10 PROB_OF_CA_PREDICTION NUMERIC(7,6) 19
11 QUALIFYING_CFP_NODE INTEGER 4
12 CFP_NODE INTEGER 4
13 PROB_OF_CFP_PREDICTION NUMERIC(7,6) 19
14 QUALIFYING_ML_NODE INTEGER 4
15 ML_NODE INTEGER 4
16 PROB_OF_ML_PREDICTION NUMERIC(7,6) 19
17 QUALIFYING_TFP_NODE INTEGER 4
18 TFP_NODE INTEGER 4
19 PROB_OF_TFP_PREDICTION NUMERIC(7,6) 19
20 QUALIFYING_WW_NODE INTEGER 4
21 WW_NODE INTEGER 4
22 PROB_OF_WW_PREDICTION NUMERIC(7,6) 19
23 DATA_LOAD_DATE TIMESTAMP 8
24 SNPSHT_DATE TIMESTAMP 8
25 SRC_SYS_ID CHARACTER VARYING(5) 5
26 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
27 LOAD_ID BIGINT 8
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8