CFD_TCFDD_CRMOD_ASL_DIALLER_RETURN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DIALLER_RTRN_INFO_ID BIGINT 8
2 OPPID CHARACTER VARYING(20) 20
3 OPP_NAME CHARACTER VARYING(100) 100
4 SALE_STAGE CHARACTER VARYING(20) 20
5 CAMPAIGN_ID CHARACTER VARYING(30) 30
6 CALL_TYP CHARACTER VARYING(20) 20
7 POL_NUM CHARACTER VARYING(30) 30
8 POL_STAT CHARACTER VARYING(20) 20
9 EXIT_DATE TIMESTAMP 8
10 EXIT_DESC CHARACTER VARYING(100) 100
11 DSHNR_PROCESSED_DATE TIMESTAMP 8
12 DSHNR_RSN CHARACTER VARYING(100) 100
13 LIFE_ASSURED CHARACTER VARYING(100) 100
14 INSD_SEX CHARACTER VARYING(1) 1
15 INSURED_DOB TIMESTAMP 8
16 INSD_AGE BIGINT 8
17 OWNR_NUM CHARACTER VARYING(120) 120
18 OWNR_NAM CHARACTER VARYING(100) 100
19 PAYT_METH_CODE CHARACTER VARYING(20) 20
20 PAYT_FREQ CHARACTER VARYING(4) 4
21 INSTLMT_PREM NUMERIC(18,6) 19
22 ANN_PREM_PAYABLE NUMERIC(18,6) 19
23 POL_DESC CHARACTER VARYING(100) 100
24 BENEF_CODE CHARACTER VARYING(200) 200
25 SUM_INSD_AMT NUMERIC(18,6) 19
26 RISK_COMMENCEMENT_DATE TIMESTAMP 8
27 PAYER_NUM CHARACTER VARYING(30) 30
28 MNDTE_STAT CHARACTER VARYING(20) 20
29 CR_CRD_NUM CHARACTER VARYING(20) 20
30 ADVSR_NUM CHARACTER VARYING(20) 20
31 AGNT_NAM CHARACTER VARYING(100) 100
32 ADVSR_HME_PH_NUM CHARACTER VARYING(20) 20
33 ADVSR_WRK_PH_NUM CHARACTER VARYING(20) 20
34 ADVSR_MOB_PH_NUM CHARACTER VARYING(20) 20
35 ADVSR_EMAIL_ADDR CHARACTER VARYING(150) 150
36 ADVSR_ADDR_LNE_1 CHARACTER VARYING(100) 100
37 ADVSR_ADDR_LNE_2 CHARACTER VARYING(100) 100
38 ADVSR_ADDR_LNE_3 CHARACTER VARYING(100) 100
39 ADVSR_ADDR_LNE_4 CHARACTER VARYING(100) 100
40 ADVSR_ADDR_LNE_5 CHARACTER VARYING(100) 100
41 ADVSR_PCODE CHARACTER VARYING(10) 10
42 CPI_IND CHARACTER VARYING(1) 1
43 BILLED_TO_DATE TIMESTAMP 8
44 PAID_TO_DATE TIMESTAMP 8
45 POTENTIAL_LAPSE_DATE TIMESTAMP 8
46 PAYT_STAT CHARACTER VARYING(20) 20
47 NXT_LODGEMENT_DATE TIMESTAMP 8
48 OPCDA_CODE CHARACTER VARYING(20) 20
49 DISC_PCTAGE NUMERIC(18,6) 19
50 CUST_NUM CHARACTER VARYING(20) 20
51 TRTMNT_CODE CHARACTER VARYING(20) 20
52 CMPGN_CODE CHARACTER VARYING(100) 100
53 REPRICING_FLG CHARACTER VARYING(1) 1
54 RECRD_ACTV_IND CHARACTER VARYING(1) 1
55 ALLOCATED_TO CHARACTER VARYING(100) 100
56 OPPRTNTY_STAGE CHARACTER VARYING(50) 50
57 CREATED_DATE TIMESTAMP 8
58 MODIFIED_DATE TIMESTAMP 8
59 CLSD_DATE TIMESTAMP 8
60 PURGE_DATE TIMESTAMP 8
61 NUM_OF_ATTEMPTS BIGINT 8
62 FINAL_CALL_RSLT CHARACTER VARYING(30) 30
63 CALL_BACK_DATE TIMESTAMP 8
64 BRND_AWARE CHARACTER VARYING(30) 30
65 PRSN_CNTCTD CHARACTER VARYING(30) 30
66 REQ_FOR_OPPRTNTY_CANCEL_FLG CHARACTER VARYING(1) 1
67 CANCEL_DRVR CHARACTER VARYING(30) 30
68 CANCEL_CAT CHARACTER VARYING(30) 30
69 CANCEL_RSN CHARACTER VARYING(30) 30
70 SAVE_METHODS CHARACTER VARYING(500) 500
71 DCLND_SAVE_OFFERS CHARACTER VARYING(500) 500
72 SAVE_CANCEL_COMMENTS CHARACTER VARYING(255) 255
73 INTEND_TO_CANCEL_FLG CHARACTER VARYING(1) 1
74 INTEND_TO_RENEW_FLG CHARACTER VARYING(1) 1
75 REFD_TO_ADVSR_FLG CHARACTER VARYING(1) 1
76 RESEARCH_STSFCTN_FLG CHARACTER VARYING(1) 1
77 EMAIL_OPTIN CHARACTER VARYING(30) 30
78 CUSTOMERS_READ CHARACTER VARYING(30) 30
79 RESEND_MKTG_MATERIAL_FLG CHARACTER VARYING(1) 1
80 CRMOD_OPPRTNTY_ID CHARACTER VARYING(30) 30
81 CRMOD_ACTY_ID CHARACTER VARYING(30) 30
82 OPPRTNTY_CALL_RSLT_ID BIGINT 8
83 OPPRTNTY_CALL_RSLT CHARACTER VARYING(30) 30
84 ATTEMPT_NUM BIGINT 8
85 OPPRTNTY_CALL_OUTCOME CHARACTER VARYING(40) 40
86 REQ_FOR_ACTV_CANCEL_FLG CHARACTER VARYING(1) 1
87 CALL_END_DATE TIMESTAMP 8
88 ACTY_OWNR_NAM CHARACTER VARYING(100) 100
89 OWNR_HME_PH_NUM CHARACTER VARYING(20) 20
90 OWNR_MOB_PH_NUM CHARACTER VARYING(20) 20
91 OWNR_BUS_PH_NUM CHARACTER VARYING(20) 20
92 OWNR_EMAIL_ADDR CHARACTER VARYING(100) 100
93 ADDRESSEE_NAM CHARACTER VARYING(50) 50
94 ADDR_LNE_1 CHARACTER VARYING(50) 50
95 ADDR_LNE_2 CHARACTER VARYING(50) 50
96 ADDR_LNE_3 CHARACTER VARYING(50) 50
97 ADDR_LNE_4 CHARACTER VARYING(50) 50
98 ADDR_LNE_5 CHARACTER VARYING(50) 50
99 CLIENT_PCODE CHARACTER VARYING(20) 20
100 STATE_OR_REGION_CODE CHARACTER VARYING(10) 10
101 EFF_STRT_DATE TIMESTAMP 8
102 EFF_END_DATE TIMESTAMP 8
103 DATA_LOAD_DATE TIMESTAMP 8
104 SNPSHT_DATE TIMESTAMP 8
105 SRC_SYS_ID CHARACTER VARYING(5) 5
106 LOAD_ID BIGINT 8
107 CALL_END_TS CHARACTER VARYING(50) 50
108 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
109 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
110 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
111 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8