CFD_MCFDD_MY_BUSINESS_FLAGS

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 HOUSEHOLD_ID BIGINT 8
2 CUST_NUM CHARACTER VARYING(20) 20
3 MFI_TXN_FLG CHARACTER VARYING(1) 1
4 MFI_RETIREE_FLG CHARACTER VARYING(1) 1
5 DOM_CODE CHARACTER VARYING(20) 20
6 DOM_NAM CHARACTER VARYING(100) 100
7 DOM_RULE_CODE CHARACTER VARYING(20) 20
8 DOM_RULE_DESC CHARACTER VARYING(100) 100
9 CHNL_PREF_1 CHARACTER VARYING(50) 50
10 CHNL_PREF_2 CHARACTER VARYING(50) 50
11 CHNL_PREF_3 CHARACTER VARYING(50) 50
12 CHNL_PREF_4 CHARACTER VARYING(50) 50
13 CHNL_PREF_5 CHARACTER VARYING(50) 50
14 SUB_LIFE_STAGE_GRP_CODE CHARACTER VARYING(10) 10
15 FAMILY_LIFE_STAGE_CODE CHARACTER VARYING(10) 10
16 LIFE_STAGE_SCORE CHARACTER VARYING(10) 10
17 TOT_SCORE_TXN_AMT NUMERIC(18,6) 19
18 TOT_SCORE_SAVING_AMT NUMERIC(18,6) 19
19 TOT_SCORE_LNDG_AMT NUMERIC(18,6) 19
20 TOT_SCORE_AMT NUMERIC(18,6) 19
21 TXN_RATING_CODE CHARACTER VARYING(10) 10
22 SAVING_RATING_CODE CHARACTER VARYING(10) 10
23 LNDG_RATING_CODE CHARACTER VARYING(10) 10
24 TOT_RATING_CODE CHARACTER VARYING(10) 10
25 SAVING_FLG CHARACTER VARYING(1) 1
26 TXN_FLG CHARACTER VARYING(1) 1
27 TRM_DEPOSIT_FLG CHARACTER VARYING(1) 1
28 TXN_FREQ_CODE CHARACTER VARYING(10) 10
29 TXN_VAL_CODE CHARACTER VARYING(10) 10
30 PRIM_SGMNT_CODE CHARACTER VARYING(10) 10
31 SCNDRY_SGMNT_CODE CHARACTER VARYING(10) 10
32 VAL_FLG CHARACTER VARYING(1) 1
33 SHARP_INCRS_FLG CHARACTER VARYING(1) 1
34 NET_VAL_FLG CHARACTER VARYING(1) 1
35 PRIOR_TRM_DPTS_FLG CHARACTER VARYING(1) 1
36 SALARY_AMT NUMERIC(18,6) 19
37 TXN_DORMANCY_1_MTH_FLG CHARACTER VARYING(1) 1
38 TXN_DORMANCY_3_MTH_FLG CHARACTER VARYING(1) 1
39 TOP_150_CALL_FLG CHARACTER VARYING(10) 10
40 FOOTING_CALL_RANK DOUBLE PRECISION 8
41 TOP_150_LN_FLG CHARACTER VARYING(10) 10
42 FOOTING_LN_RANK DOUBLE PRECISION 8
43 TOP_150_TRM_FLG CHARACTER VARYING(10) 10
44 FOOTING_TRM_RANK DOUBLE PRECISION 8
45 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
46 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
47 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
48 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8