CFD_TCFDD_CLIENT_LEAD_FOLLOWUP

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 INTN_CLIENT_NUM BIGINT 8
3 CNTCT_ID BIGINT 8
4 RFRL_NUM BIGINT 8
5 EFF_STRT_DATE TIMESTAMP 8
6 CLIENT_LEAD_ID BIGINT 8
7 RFRL_OPRTR_CODE CHARACTER VARYING(20) 20
8 RFRL_TS TIMESTAMP 8
9 RFRL_DIAL_TME_IND CHARACTER VARYING(3) 3
10 CNTCT_RSLT_ID BIGINT 8
11 CNTCT_RSLT_CODE CHARACTER VARYING(20) 20
12 UPD_UID CHARACTER VARYING(20) 20
13 UPD_TS TIMESTAMP 8
14 STATE_ID BIGINT 8
15 STATE_CODE CHARACTER VARYING(20) 20
16 PRDT_SYS_PRDT_CODE CHARACTER VARYING(20) 20
17 FOLLOWUP_STAT_CODE CHARACTER VARYING(20) 20
18 CNTCT_RSN_ID BIGINT 8
19 CNTCT_RSN_CODE CHARACTER VARYING(20) 20
20 CMPGN_CODE CHARACTER VARYING(50) 50
21 SRC_SYS_CMPGN_CODE CHARACTER VARYING(20) 20
22 EFF_END_DATE TIMESTAMP 8
23 DATA_LOAD_DATE TIMESTAMP 8
24 SNPSHT_DATE TIMESTAMP 8
25 SRC_SYS_ID CHARACTER VARYING(5) 5
26 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
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