CFD_TCFDD_SALMAT_DIALLER_RETURN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

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