CFD_TCFDD_CLIENT_LEAD

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLIENT_LEAD_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 INTN_CLIENT_NUM BIGINT 8
4 CNTCT_ID BIGINT 8
5 EFF_STRT_DATE TIMESTAMP 8
6 CNTCT_TS TIMESTAMP 8
7 STATE_ID BIGINT 8
8 STATE_CODE CHARACTER VARYING(20) 20
9 OPRTR_CODE CHARACTER VARYING(20) 20
10 LEAD_STAT_CODE CHARACTER VARYING(20) 20
11 CNTCT_RSLT_ID BIGINT 8
12 CNTCT_RSLT_CODE CHARACTER VARYING(20) 20
13 CNTCT_RSLT_RSN_ID BIGINT 8
14 CNTCT_RSLT_RSN_CODE CHARACTER VARYING(20) 20
15 PRIM_CNTCT_IND CHARACTER VARYING(3) 3
16 MON_CNTCT_PREF_IND CHARACTER VARYING(3) 3
17 TUE_CNTCT_PREF_IND CHARACTER VARYING(3) 3
18 WED_CNTCT_PREF_IND CHARACTER VARYING(3) 3
19 THU_CNTCT_PREF_IND CHARACTER VARYING(3) 3
20 FRI_CNTCT_PREF_IND CHARACTER VARYING(3) 3
21 SAT_CNTCT_PREF_IND CHARACTER VARYING(3) 3
22 SUN_CNTCT_PREF_IND CHARACTER VARYING(3) 3
23 PRDT_SYS_PRDT_NUM CHARACTER VARYING(20) 20
24 LEAD_DUE_DATE TIMESTAMP 8
25 CNTCT_RSN_ID BIGINT 8
26 CNTCT_RSN_CODE CHARACTER VARYING(20) 20
27 LEAD_SRC_ID BIGINT 8
28 LEAD_SRC_CODE CHARACTER VARYING(20) 20
29 PRDT_SYS_PRDT_CODE CHARACTER VARYING(20) 20
30 PRDT_SYS_PRDT_SBCLS_CODE CHARACTER VARYING(20) 20
31 LEAD_ACTN_DESC CHARACTER VARYING(120) 120
32 CMPGN_CODE CHARACTER VARYING(50) 50
33 SRC_SYS_CMPGN_CODE CHARACTER VARYING(20) 20
34 NO_CLM_BONUS_IND CHARACTER VARYING(3) 3
35 EFF_END_DATE TIMESTAMP 8
36 DATA_LOAD_DATE TIMESTAMP 8
37 SNPSHT_DATE TIMESTAMP 8
38 SRC_SYS_ID CHARACTER VARYING(5) 5
39 LOAD_ID BIGINT 8
40 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8