CDI_TCFDD_CUSTOMER

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_ID BIGINT 8
2 CUST_NUM CHARACTER VARYING(20) 20
3 ENTTYP_ID BIGINT 8
4 ENTITY_TYP_CODE CHARACTER VARYING(20) 20
5 LIFECYCLE_STAT_ID BIGINT 8
6 LIFECYCLE_STAT_CODE CHARACTER VARYING(50) 50
7 DECEASED_IND CHARACTER VARYING(3) 3
8 DECEASED_DATE TIMESTAMP 8
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 GNDR_IND CHARACTER VARYING(3) 3
16 ORG_NAM CHARACTER VARYING(150) 150
17 ABN CHARACTER VARYING(20) 20
18 ACN_ARBN CHARACTER VARYING(10) 10
19 DRVR_LIC_NUM CHARACTER VARYING(20) 20
20 DRVR_LIC_STATE_DESC CHARACTER VARYING(50) 50
21 DRVR_LIC_CNTRY_ID BIGINT 8
22 DRVR_LIC_CNTRY_CODE CHARACTER VARYING(20) 20
23 HOUSEHOLD_ID BIGINT 8
24 EFF_STRT_DATE TIMESTAMP 8
25 EFF_END_DATE TIMESTAMP 8
26 DATA_LOAD_DATE TIMESTAMP 8
27 SNPSHT_DATE TIMESTAMP 8
28 SRC_SYS_ID CHARACTER VARYING(5) 5
29 LOAD_ID BIGINT 8
30 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
32 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
33 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8