CDI_TCFDS_CAMPAIGN_ANALYSIS

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 CUST_NUM CHARACTER VARYING(20) 20
7 LST_UPD_DATE TIMESTAMP 8
8 AUDIENCE_LVL_CODE CHARACTER VARYING(1) 1
9 RSPNS_END_DATE TIMESTAMP 8
10 HOUSEHOLD_ID DOUBLE PRECISION 8
11 CMPGN_BUS_UNT_DESC CHARACTER VARYING(50) 50
12 CMPGN_BRND_DESC CHARACTER VARYING(50) 50
13 CMPGN_STRATEGY_DESC CHARACTER VARYING(50) 50
14 CNTL_CODE CHARACTER VARYING(1) 1
15 EXPRMNTL_CELL_CODE CHARACTER VARYING(50) 50
16 OFFER_CODE CHARACTER VARYING(10) 10
17 CREATIVE_CODE CHARACTER VARYING(50) 50
18 CNTCTD_FLG CHARACTER VARYING(1) 1
19 OFFER_PROG_STAT_CODE CHARACTER VARYING(1) 1
20 TARGET_PRDT_ID CHARACTER VARYING(20) 20
21 CNTCT_WAVE_MTH_WITH_YR CHARACTER VARYING(10) 10
22 CNTCT_WAVE_WK_NUM_IN_YR DOUBLE PRECISION 8
23 CMPGN_SUCCESS_FLG CHARACTER VARYING(1) 1
24 CNTCT_LIVE_DAYS_CNT DOUBLE PRECISION 8
25 FRST_RSPNS_DAYS_CNT DOUBLE PRECISION 8
26 BASE_TARGET_PRDT_CNT DOUBLE PRECISION 8
27 BASE_TARGET_PRDT_VAL NUMERIC(18,6) 19
28 CRNT_TARGET_PRDT_CNT DOUBLE PRECISION 8
29 CRNT_TARGET_PRDT_VAL NUMERIC(18,6) 19
30 SNPSHT_DATE TIMESTAMP 8
31 DATA_LOAD_DATE TIMESTAMP 8
32 LOAD_ID DOUBLE PRECISION 8
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8