CDI_TCFDD_MEMBER_LEVEL_CUST

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 BRND_CODE CHARACTER VARYING(10) 10
4 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
5 EFF_STRT_DATE TIMESTAMP 8
6 CUST_ID BIGINT 8
7 BRND_ID BIGINT 8
8 INTN_INITIATE_MBR_ID BIGINT 8
9 ENTTYP_ID BIGINT 8
10 ENTITY_TYP_CODE CHARACTER VARYING(20) 20
11 GNDR_IND CHARACTER VARYING(3) 3
12 DERIVED_GNDR_IND CHARACTER VARYING(3) 3
13 INSERT_DATE TIMESTAMP 8
14 UPD_DATE TIMESTAMP 8
15 TITLE CHARACTER VARYING(20) 20
16 FRST_NAM CHARACTER VARYING(100) 100
17 MIDDLE_NAM CHARACTER VARYING(100) 100
18 LST_NAM CHARACTER VARYING(50) 50
19 NAM_SUFFIX CHARACTER VARYING(50) 50
20 ORG_NAM CHARACTER VARYING(150) 150
21 BRTH_DATE TIMESTAMP 8
22 DECEASED_IND CHARACTER VARYING(3) 3
23 DECEASED_DATE TIMESTAMP 8
24 OCCUP_ID BIGINT 8
25 OCCUP_CODE CHARACTER VARYING(50) 50
26 DRVR_LIC_NUM CHARACTER VARYING(20) 20
27 DRVR_LIC_STATE_DESC CHARACTER VARYING(50) 50
28 DRVR_LIC_CNTRY_ID BIGINT 8
29 DRVR_LIC_CNTRY_CODE CHARACTER VARYING(20) 20
30 ABN CHARACTER VARYING(20) 20
31 ACN_ARBN CHARACTER VARYING(10) 10
32 ANZSIC_TYP_ID BIGINT 8
33 ANZSIC_TYP_CODE CHARACTER VARYING(20) 20
34 EMP_NUM CHARACTER VARYING(20) 20
35 CONSNT_GLOBAL_FLG CHARACTER VARYING(1) 1
36 ORG_CNTCT_NAM CHARACTER VARYING(100) 100
37 ORG_CNTCT_POSN CHARACTER VARYING(50) 50
38 LIFECYCLE_STAT_ID BIGINT 8
39 LIFECYCLE_STAT_CODE CHARACTER VARYING(50) 50
40 PRSPCT_ID CHARACTER VARYING(30) 30
41 PRSPCT_LIST_ID CHARACTER VARYING(20) 20
42 PRSPCT_LIST_SUPPLY_DATE TIMESTAMP 8
43 PRSPCT_LIST_CNTCT_EXPIRY_DATE TIMESTAMP 8
44 PRSPCT_LIST_DEL_DATE TIMESTAMP 8
45 RSHIP_MGR_CODE CHARACTER VARYING(10) 10
46 PRDT_SYS_GNDR_IND CHARACTER VARYING(3) 3
47 PRDT_SYS_CUST_NAM CHARACTER VARYING(255) 255
48 PRDT_SYS_CUST_TITLE CHARACTER VARYING(20) 20
49 PRDT_SYS_CUST_FRST_NAM CHARACTER VARYING(100) 100
50 PRDT_SYS_CUST_MIDDLE_NAM CHARACTER VARYING(100) 100
51 PRDT_SYS_CUST_LST_NAM CHARACTER VARYING(100) 100
52 PRDT_SYS_CUST_NAM_SUFFIX CHARACTER VARYING(50) 50
53 EFF_END_DATE TIMESTAMP 8
54 DATA_LOAD_DATE TIMESTAMP 8
55 SNPSHT_DATE TIMESTAMP 8
56 SRC_SYS_ID CHARACTER VARYING(5) 5
57 AGGRESSIVE_LOAD_IND CHARACTER VARYING(3) 3
58 LOAD_ID BIGINT 8
59 GLOBAL_CONSNT_DATE TIMESTAMP 8
60 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
61 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
62 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
63 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8