CDI_TCFDD_CUSTOMER_LEADS

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LEAD_NUM CHARACTER VARYING(20) 20
2 LEAD_CUST_NUM CHARACTER VARYING(20) 20
3 CMPY_CUST_NUM CHARACTER VARYING(20) 20
4 LEAD_BRND_CODE CHARACTER VARYING(10) 10
5 LEAD_CREATED_DATE TIMESTAMP 8
6 LEAD_REN_DUE_DATE TIMESTAMP 8
7 LEAD_CHNL_DESC CHARACTER VARYING(50) 50
8 LEAD_PRDT_TYP_DESC CHARACTER VARYING(100) 100
9 LEAD_PRDT_SUBTYP_DESC CHARACTER VARYING(100) 100
10 EFF_STRT_DATE TIMESTAMP 8
11 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
12 CUST_NUM CHARACTER VARYING(20) 20
13 CMPGN_CODE CHARACTER VARYING(20) 20
14 TRTMNT_CODE CHARACTER VARYING(10) 10
15 POL_NUM CHARACTER VARYING(20) 20
16 CAMAIGN_DESC CHARACTER VARYING(50) 50
17 LST_UPDD_DATE TIMESTAMP 8
18 CRNT_STAT_FLG CHARACTER VARYING(1) 1
19 LEAD_CREATE_USER_ID CHARACTER VARYING(20) 20
20 SRC_CUST_NAM CHARACTER VARYING(50) 50
21 CRNT_GRP_RSHIP_FLG CHARACTER VARYING(1) 1
22 CRNT_PI_RSHIP_FLG CHARACTER VARYING(1) 1
23 CRNT_GIO_RSHIP_FLG CHARACTER VARYING(1) 1
24 CRNT_AAMI_RSHIP_FLG CHARACTER VARYING(1) 1
25 CRNT_SUN_RSHIP_FLG CHARACTER VARYING(1) 1
26 CRNT_INSRR_DESC CHARACTER VARYING(20) 20
27 CRNT_PREM_AMT NUMERIC(18,2) 19
28 ESTMD_CNTCT_DATE TIMESTAMP 8
29 FOLLOWUP_CMPGN_CODE CHARACTER VARYING(20) 20
30 TITLE CHARACTER VARYING(20) 20
31 LST_NAM CHARACTER VARYING(50) 50
32 FRST_NAM CHARACTER VARYING(100) 100
33 ADDR_TYP_CODE CHARACTER VARYING(20) 20
34 ADDR_LNE_1 CHARACTER VARYING(50) 50
35 ADDR_LNE_2 CHARACTER VARYING(50) 50
36 ADDR_LNE_3 CHARACTER VARYING(50) 50
37 SBRB_CODE CHARACTER VARYING(50) 50
38 PCODE CHARACTER VARYING(20) 20
39 STATE_DESC CHARACTER VARYING(50) 50
40 CNTRY_CODE CHARACTER VARYING(20) 20
41 DPID CHARACTER VARYING(20) 20
42 DPID_TYP_CODE CHARACTER VARYING(4) 4
43 POSTAL_ADDR_TYP_CODE CHARACTER VARYING(20) 20
44 ADDR_STD_CODE CHARACTER VARYING(10) 10
45 RTRN_MAIL_FLG CHARACTER VARYING(1) 1
46 EMAIL_ADDR CHARACTER VARYING(100) 100
47 PH1_TYP_CODE CHARACTER VARYING(4) 4
48 MOB_PHONE_NUM CHARACTER VARYING(20) 20
49 PH2_TYP_CODE CHARACTER VARYING(4) 4
50 WORK_PHONE_NUM CHARACTER VARYING(20) 20
51 EFF_END_DATE TIMESTAMP 8
52 SRC_SYS_ID CHARACTER VARYING(5) 5
53 SNPSHT_DATE TIMESTAMP 8
54 DATA_LOAD_DATE TIMESTAMP 8
55 LOAD_ID BIGINT 8
56 RISK_POST_CODE CHARACTER VARYING(4) 4
57 SATISFIED_FLAG CHARACTER VARYING(1) 1
58 INSURED_AGE SMALLINT 2
59 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
60 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
61 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
62 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8