CFD_TCFDD_CUSTOMER_CONSENT

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 CUST_ID BIGINT 8
3 CONSNT_STRT_DATE TIMESTAMP 8
4 CONSNT_END_DATE TIMESTAMP 8
5 CONSNT_GLOBAL_IND CHARACTER VARYING(3) 3
6 CONSNT_GLOBAL_DATE TIMESTAMP 8
7 CONSNT_MAIL_BNKING_IND CHARACTER VARYING(3) 3
8 CONSNT_MAIL_BNKING_DATE TIMESTAMP 8
9 CONSNT_MAIL_INS_IND CHARACTER VARYING(3) 3
10 CONSNT_MAIL_INS_DATE TIMESTAMP 8
11 CONSNT_MAIL_WEALTH_IND CHARACTER VARYING(3) 3
12 CONSNT_MAIL_WEALTH_DATE TIMESTAMP 8
13 CONSNT_EMAIL_BNKING_IND CHARACTER VARYING(3) 3
14 CONSNT_EMAIL_BNKING_DATE TIMESTAMP 8
15 CONSNT_EMAIL_INS_IND CHARACTER VARYING(3) 3
16 CONSNT_EMAIL_INS_DATE TIMESTAMP 8
17 CONSNT_EMAIL_WEALTH_IND CHARACTER VARYING(3) 3
18 CONSNT_EMAIL_WEALTH_DATE TIMESTAMP 8
19 CONSNT_PH_BNKING_IND CHARACTER VARYING(3) 3
20 CONSNT_PH_BNKING_DATE TIMESTAMP 8
21 CONSNT_PH_INS_IND CHARACTER VARYING(3) 3
22 CONSNT_PH_INS_DATE TIMESTAMP 8
23 CONSNT_PH_WEALTH_IND CHARACTER VARYING(3) 3
24 CONSNT_PH_WEALTH_DATE TIMESTAMP 8
25 CONSNT_PH_EXP_IND CHARACTER VARYING(3) 3
26 CONSNT_PH_EXP_DATE TIMESTAMP 8
27 EFF_STRT_DATE TIMESTAMP 8
28 EFF_END_DATE TIMESTAMP 8
29 DATA_LOAD_DATE TIMESTAMP 8
30 SNPSHT_DATE TIMESTAMP 8
31 SRC_SYS_ID CHARACTER VARYING(5) 5
32 LOAD_ID BIGINT 8
33 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8