CFD_TCFDR_MODEL_CAMPAIGN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MODEL_CMPGN_ID BIGINT 8
2 MODEL_CODE CHARACTER VARYING(20) 20
3 CMPGN_CODE CHARACTER VARYING(20) 20
4 CELL_CODE CHARACTER VARYING(10) 10
5 MODEL_ID BIGINT 8
6 CMPGN_ID BIGINT 8
7 EFF_STRT_DATE TIMESTAMP 8
8 EFF_END_DATE TIMESTAMP 8
9 SNPSHT_DATE TIMESTAMP 8
10 DATA_LOAD_DATE TIMESTAMP 8
11 SRC_SYS_ID CHARACTER VARYING(5) 5
12 LOAD_ID BIGINT 8
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8