CDI_TCFDD_BRAND_LEVEL_CUST

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 BRND_CODE CHARACTER VARYING(10) 10
3 EFF_STRT_DATE TIMESTAMP 8
4 CUST_ID BIGINT 8
5 BRND_ID BIGINT 8
6 ENTTYP_ID BIGINT 8
7 ENTITY_TYP_CODE CHARACTER VARYING(20) 20
8 GNDR_IND CHARACTER VARYING(3) 3
9 TITLE CHARACTER VARYING(20) 20
10 FRST_NAM CHARACTER VARYING(100) 100
11 MIDDLE_NAM CHARACTER VARYING(100) 100
12 LST_NAM CHARACTER VARYING(50) 50
13 NAM_SUFFIX CHARACTER VARYING(50) 50
14 BRTH_DATE TIMESTAMP 8
15 ORG_NAM CHARACTER VARYING(150) 150
16 DECEASED_IND CHARACTER VARYING(3) 3
17 DECEASED_DATE TIMESTAMP 8
18 DRVR_LIC_NUM CHARACTER VARYING(20) 20
19 DRVR_LIC_STATE_DESC CHARACTER VARYING(50) 50
20 DRVR_LIC_CNTRY_ID BIGINT 8
21 DRVR_LIC_CNTRY_CODE CHARACTER VARYING(20) 20
22 ABN CHARACTER VARYING(20) 20
23 ACN_ARBN CHARACTER VARYING(10) 10
24 EMP_NUM CHARACTER VARYING(20) 20
25 CONSNT_GLOBAL_FLG CHARACTER VARYING(1) 1
26 LIFECYCLE_STAT_ID BIGINT 8
27 LIFECYCLE_STAT_CODE CHARACTER VARYING(50) 50
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 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
33 LOAD_ID BIGINT 8
34 GLOBAL_CONSNT_DATE TIMESTAMP 8
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8