CDI_TCFDS_CAMPAIGN_SUCCESS

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 CUST_NUM CHARACTER VARYING(20) 20
9 RSPNS_END_DATE TIMESTAMP 8
10 OFFER_CODE CHARACTER VARYING(10) 10
11 HOUSEHOLD_ID DOUBLE PRECISION 8
12 CMPGN_BUS_UNT_DESC CHARACTER VARYING(50) 50
13 CMPGN_BRND_DESC CHARACTER VARYING(50) 50
14 CMPGN_STRATEGY_DESC CHARACTER VARYING(50) 50
15 CNTL_CODE CHARACTER VARYING(1) 1
16 AUDIENCE_LVL_CODE CHARACTER VARYING(1) 1
17 CNTCTD_FLG CHARACTER VARYING(1) 1
18 EXPRMNTL_CELL_CODE CHARACTER VARYING(50) 50
19 DAYS_SINCE_CNTCT DOUBLE PRECISION 8
20 TARGET_PRDT_ID CHARACTER VARYING(20) 20
21 PRDT_ID DOUBLE PRECISION 8
22 PRDT_STRT_DATE TIMESTAMP 8
23 PRDT_END_DATE TIMESTAMP 8
24 PRDT_VAL_AT_CNTCT NUMERIC(18,6) 19
25 CRNT_PRDT_VAL NUMERIC(18,6) 19
26 PRDT_RSPNS_DAYS_CNT DOUBLE PRECISION 8
27 SNPSHT_DATE TIMESTAMP 8
28 DATA_LOAD_DATE TIMESTAMP 8
29 LOAD_ID DOUBLE PRECISION 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