MKT_TCFDD_CUSTOMER_CONTACT

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CMPGN_CODE CHARACTER VARYING(50) 50
2 CUST_NUM_CNTCT CHARACTER VARYING(20) 20
3 OPRTNL_CELL_CODE CHARACTER VARYING(2) 2
4 COMMUNICATION_TYP_CODE CHARACTER VARYING(10) 10
5 CNTCT_STRT_DATE TIMESTAMP 8
6 PRDT_SYS_CODE CHARACTER VARYING(10) 10
7 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
8 AUDIENCE_LVL_CODE CHARACTER VARYING(1) 1
9 CUST_NUM CHARACTER VARYING(20) 20
10 CMPY_ID BIGINT 8
11 CMPY_CUST_NUM CHARACTER VARYING(20) 20
12 PRDT_SYS_CUST_NUM CHARACTER VARYING(20) 20
13 HOUSEHOLD_ID BIGINT 8
14 EXPRMNTL_CELL_CODE CHARACTER VARYING(50) 50
15 OFFER_CODE CHARACTER VARYING(10) 10
16 CREATIVE_CODE CHARACTER VARYING(50) 50
17 RSPNS_END_DATE TIMESTAMP 8
18 OFFER_PROG_STAT_CODE CHARACTER VARYING(1) 1
19 CNTL_CODE CHARACTER VARYING(1) 1
20 DEPLOYMENT_LOAD_DATE TIMESTAMP 8
21 CES_CODE CHARACTER VARYING(50) 50
22 TRTMNT_CODE CHARACTER VARYING(10) 10
23 LST_UPD_DATE TIMESTAMP 8
24 SNPSHT_DATE TIMESTAMP 8
25 DATA_LOAD_DATE TIMESTAMP 8
26 SRC_SYS_ID CHARACTER VARYING(5) 5
27 LOAD_ID BIGINT 8
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8