CFD_TCFDD_DIALLER_RETURN_INFO

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DIALLER_RTRN_INFO_ID DOUBLE PRECISION 8
2 DIALLER_UNIQUE_CODE CHARACTER VARYING(40) 40
3 SRC_LEAD_ID CHARACTER VARYING(20) 20
4 LEAD_CAT_CODE CHARACTER VARYING(10) 10
5 CMPGN_CODE CHARACTER VARYING(20) 20
6 CMPGN_NAM CHARACTER VARYING(100) 100
7 CMPGN_DESC CHARACTER VARYING(500) 500
8 FOLLOW_UP_DATE TIMESTAMP 8
9 CUST_CONSNT_FLG CHARACTER VARYING(3) 3
10 CUST_NUM_1 CHARACTER VARYING(20) 20
11 CUST_1_FULL_NAM CHARACTER VARYING(100) 100
12 CUST_1_TITLE CHARACTER VARYING(50) 50
13 CUST_1_FRST_NAM CHARACTER VARYING(50) 50
14 CUST_1_LST_NAM CHARACTER VARYING(50) 50
15 CUST_1_BRTH_DATE TIMESTAMP 8
16 CUST_1_GNDR_IND CHARACTER VARYING(3) 3
17 CUST_NUM_2 CHARACTER VARYING(20) 20
18 CUST_2_FULL_NAM CHARACTER VARYING(100) 100
19 CUST_2_TITLE CHARACTER VARYING(50) 50
20 CUST_2_FRST_NAM CHARACTER VARYING(50) 50
21 CUST_2_LST_NAM CHARACTER VARYING(50) 50
22 CUST_2_BRTH_DATE TIMESTAMP 8
23 CUST_2_GNDR_IND CHARACTER VARYING(3) 3
24 FULL_ADDR_TEXT CHARACTER VARYING(100) 100
25 ADDR_LNE_1 CHARACTER VARYING(50) 50
26 ADDR_LNE_2 CHARACTER VARYING(50) 50
27 ADDR_LNE_3 CHARACTER VARYING(50) 50
28 SBRB_CODE CHARACTER VARYING(50) 50
29 STATE_CODE CHARACTER VARYING(10) 10
30 POST_CODE CHARACTER VARYING(10) 10
31 PH_NUM_1 CHARACTER VARYING(20) 20
32 PH_NUM_2 CHARACTER VARYING(20) 20
33 PH_NUM_3 CHARACTER VARYING(20) 20
34 BRND_CODE CHARACTER VARYING(20) 20
35 PRDT_DUE_DATE TIMESTAMP 8
36 PRDT_VAL_AMT NUMERIC(18,6) 19
37 PRDT_NUM CHARACTER VARYING(20) 20
38 NOTE_TEXT CHARACTER VARYING(100) 100
39 CUST_1_AGE_YR CHARACTER VARYING(10) 10
40 CUST_2_AGE_YR CHARACTER VARYING(10) 10
41 PRDT_TYP_DESC CHARACTER VARYING(30) 30
42 PRDT_SGMNT_TYP_DESC CHARACTER VARYING(30) 30
43 RECORD_GNRTN_DATE TIMESTAMP 8
44 CUST_1_SGMNT_DESC CHARACTER VARYING(20) 20
45 CUST_2_SGMNT_DESC CHARACTER VARYING(20) 20
46 EMAIL_ADDR CHARACTER VARYING(100) 100
47 TRTMNT_CODE CHARACTER VARYING(10) 10
48 OFFER_CODE CHARACTER VARYING(10) 10
49 CMPGN_CHNL_DESC CHARACTER VARYING(20) 20
50 GENERIC_1_NUM CHARACTER VARYING(10) 10
51 GENERIC_2_NUM CHARACTER VARYING(10) 10
52 GENERIC_3_NUM CHARACTER VARYING(10) 10
53 CNTCT_STRT_DATE TIMESTAMP 8
54 GENERIC_1_DATE TIMESTAMP 8
55 GENERIC_2_DATE TIMESTAMP 8
56 GENERIC_3_DATE TIMESTAMP 8
57 GENERIC_4_DATE TIMESTAMP 8
58 GENERIC_5_DATE TIMESTAMP 8
59 GENERIC_6_DATE TIMESTAMP 8
60 GENERIC_7_DATE TIMESTAMP 8
61 GENERIC_8_DATE TIMESTAMP 8
62 CALL_EXPIRY_DATE TIMESTAMP 8
63 GENERIC_1_TEXT CHARACTER VARYING(50) 50
64 CMPY_CUST_NUM CHARACTER VARYING(30) 30
65 GENERIC_2_TEXT CHARACTER VARYING(50) 50
66 GENERIC_3_TEXT CHARACTER VARYING(50) 50
67 GENERIC_4_TEXT CHARACTER VARYING(100) 100
68 GENERIC_5_TEXT CHARACTER VARYING(50) 50
69 CUST_CNT_TEXT CHARACTER VARYING(50) 50
70 GENERIC_6_TEXT CHARACTER VARYING(50) 50
71 GENERIC_7_TEXT CHARACTER VARYING(50) 50
72 GENERIC_8_TEXT CHARACTER VARYING(50) 50
73 GENERIC_9_TEXT CHARACTER VARYING(50) 50
74 GENERIC_10_TEXT CHARACTER VARYING(50) 50
75 GENERIC_11_TEXT CHARACTER VARYING(50) 50
76 GENERIC_12_TEXT CHARACTER VARYING(50) 50
77 GENERIC_13_TEXT CHARACTER VARYING(50) 50
78 GENERIC_14_TEXT CHARACTER VARYING(50) 50
79 GENERIC_16_TEXT CHARACTER VARYING(50) 50
80 GENERIC_17_TEXT CHARACTER VARYING(50) 50
81 GENERIC_18_TEXT CHARACTER VARYING(50) 50
82 GENERIC_19_TEXT CHARACTER VARYING(50) 50
83 GENERIC_20_TEXT CHARACTER VARYING(50) 50
84 GENERIC_21_TEXT CHARACTER VARYING(50) 50
85 GENERIC_22_TEXT CHARACTER VARYING(50) 50
86 GENERIC_23_TEXT CHARACTER VARYING(50) 50
87 GENERIC_24_TEXT CHARACTER VARYING(50) 50
88 CMNT_TEXT CHARACTER VARYING(250) 250
89 CMPGN_PRTY_CODE CHARACTER VARYING(10) 10
90 AGNT_CODE CHARACTER VARYING(50) 50
91 RECENT_CALL_DATE TIMESTAMP 8
92 RECENT_CALL_STAT_CODE CHARACTER VARYING(10) 10
93 RECENT_CALL_STAT_ID BIGINT 8
94 SYS_ENTRY_DATE TIMESTAMP 8
95 STAT_FLG CHARACTER VARYING(10) 10
96 CALL_ATTEMPT_CNT DOUBLE PRECISION 8
97 RECALL_DATE TIMESTAMP 8
98 RECALL_PH_NUM CHARACTER VARYING(20) 20
99 RECALL_CNT DOUBLE PRECISION 8
100 RECORD_AGE_DAYS_CNT DOUBLE PRECISION 8
101 CRNT_DIALLED_PH_NUM_CODE CHARACTER VARYING(10) 10
102 DUP_RECORD_FLG CHARACTER VARYING(4) 4
103 PH_STAT_CODE CHARACTER VARYING(10) 10
104 JOB_NAM CHARACTER VARYING(20) 20
105 FINAL_AGNT_CODE CHARACTER VARYING(50) 50
106 SALE_CODE CHARACTER VARYING(10) 10
107 SHADOW_JOB_NAM CHARACTER VARYING(20) 20
108 JOB_ID CHARACTER VARYING(20) 20
109 MSTR_TME_ZONE_CODE CHARACTER VARYING(10) 10
110 DUP_RECORD_NUM CHARACTER VARYING(20) 20
111 CALL_DURATION_TME CHARACTER VARYING(20) 20
112 PH_1_SYS_TME_ZONE_FLG CHARACTER VARYING(4) 4
113 PH_2_SYS_TME_ZONE_FLG CHARACTER VARYING(4) 4
114 PH_1_CALL_ATTEMPT_CNT DOUBLE PRECISION 8
115 PH_2_CALL_ATTEMPT_CNT DOUBLE PRECISION 8
116 PH_1_FRST_CALL_ATTEMPT_DATE TIMESTAMP 8
117 PH_1_FRST_CALL_STAT_CODE CHARACTER VARYING(10) 10
118 PH_1_FRST_CALL_STAT_ID BIGINT 8
119 PH_1_SCND_CALL_ATTEMPT_DATE TIMESTAMP 8
120 PH_1_SCND_CALL_STAT_CODE CHARACTER VARYING(10) 10
121 PH_1_SCND_CALL_STAT_ID BIGINT 8
122 PH_1_THRD_CALL_ATTEMPT_DATE TIMESTAMP 8
123 PH_1_THRD_CALL_STAT_CODE CHARACTER VARYING(10) 10
124 PH_1_THRD_CALL_STAT_ID BIGINT 8
125 PH_1_FRTH_CALL_ATTEMPT_DATE TIMESTAMP 8
126 PH_1_FRTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
127 PH_1_FRTH_CALL_STAT_ID BIGINT 8
128 PH_1_FFTH_CALL_ATTEMPT_DATE TIMESTAMP 8
129 PH_1_FFTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
130 PH_1_FFTH_CALL_STAT_ID BIGINT 8
131 PH_1_LST_CALL_ATTEMPT_DATE TIMESTAMP 8
132 PH_1_LST_CALL_STAT_CODE CHARACTER VARYING(10) 10
133 PH_1_LST_CALL_STAT_ID BIGINT 8
134 PH_2_FRST_CALL_ATTEMPT_DATE TIMESTAMP 8
135 PH_2_FRST_CALL_STAT_CODE CHARACTER VARYING(10) 10
136 PH_2_FRST_CALL_STAT_ID BIGINT 8
137 PH_2_SCND_CALL_ATTEMPT_DATE TIMESTAMP 8
138 PH_2_SCND_CALL_STAT_CODE CHARACTER VARYING(10) 10
139 PH_2_SCND_CALL_STAT_ID BIGINT 8
140 PH_2_THRD_CALL_ATTEMPT_DATE TIMESTAMP 8
141 PH_2_THRD_CALL_STAT_CODE CHARACTER VARYING(10) 10
142 PH_2_THRD_CALL_STAT_ID BIGINT 8
143 PH_2_FRTH_CALL_ATTEMPT_DATE TIMESTAMP 8
144 PH_2_FRTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
145 PH_2_FRTH_CALL_STAT_ID BIGINT 8
146 PH_2_FFTH_CALL_ATTEMPT_DATE TIMESTAMP 8
147 PH_2_FFTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
148 PH_2_FFTH_CALL_STAT_ID BIGINT 8
149 PH_2_LST_CALL_ATTEMPT_DATE TIMESTAMP 8
150 PH_2_LST_CALL_STAT_CODE CHARACTER VARYING(10) 10
151 PH_2_LST_CALL_STAT_ID BIGINT 8
152 PH_3_FRST_CALL_ATTEMPT_DATE TIMESTAMP 8
153 PH_3_FRST_CALL_STAT_CODE CHARACTER VARYING(10) 10
154 PH_3_FRST_CALL_STAT_ID BIGINT 8
155 PH_3_SCND_CALL_ATTEMPT_DATE TIMESTAMP 8
156 PH_3_SCND_CALL_STAT_CODE CHARACTER VARYING(10) 10
157 PH_3_SCND_CALL_STAT_ID BIGINT 8
158 PH_3_THRD_CALL_ATTEMPT_DATE TIMESTAMP 8
159 PH_3_THRD_CALL_STAT_CODE CHARACTER VARYING(10) 10
160 PH_3_THRD_CALL_STAT_ID BIGINT 8
161 PH_3_FRTH_CALL_ATTEMPT_DATE TIMESTAMP 8
162 PH_3_FRTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
163 PH_3_FRTH_CALL_STAT_ID BIGINT 8
164 PH_3_FFTH_CALL_ATTEMPT_DATE TIMESTAMP 8
165 PH_3_FFTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
166 PH_3_FFTH_CALL_STAT_ID BIGINT 8
167 PH_3_LST_CALL_ATTEMPT_DATE TIMESTAMP 8
168 PH_3_LST_CALL_STAT_CODE CHARACTER VARYING(10) 10
169 PH_3_LST_CALL_STAT_ID BIGINT 8
170 EFF_STRT_DATE TIMESTAMP 8
171 EFF_END_DATE TIMESTAMP 8
172 DATA_LOAD_DATE TIMESTAMP 8
173 SNPSHT_DATE TIMESTAMP 8
174 SRC_SYS_ID CHARACTER VARYING(5) 5
175 LOAD_ID BIGINT 8
176 RECRD_ACTVE_IND CHARACTER VARYING(2) 2
177 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
178 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
179 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
180 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8