CFDM_TCFDD_DIALLER_RESULT

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 UNIQUE_CODE CHARACTER VARYING(40) 40
2 SNPSHT_DATE TIMESTAMP 8
3 INCIDENT_NUM CHARACTER VARYING(20) 20
4 CMPGN_CODE CHARACTER VARYING(20) 20
5 CMPGN_CAT_CODE CHARACTER VARYING(10) 10
6 CMPGN_NAM CHARACTER VARYING(50) 50
7 CALL_RSN_DESC CHARACTER VARYING(250) 250
8 FOLLOW_UP_DATE CHARACTER VARYING(20) 20
9 CUST_NUM_1 CHARACTER VARYING(20) 20
10 CUST_1_FULL_NAM CHARACTER VARYING(100) 100
11 CUST_1_TITLE CHARACTER VARYING(100) 100
12 CUST_1_FRST_NAM CHARACTER VARYING(100) 100
13 CUST_1_LST_NAM CHARACTER VARYING(100) 100
14 CUST_1_AGE CHARACTER VARYING(10) 10
15 CUST_1_DOB CHARACTER VARYING(20) 20
16 CUST_1_GNDR_IND CHARACTER VARYING(10) 10
17 CUST_NUM_2 CHARACTER VARYING(20) 20
18 CUST_2_FULL_NAM CHARACTER VARYING(100) 100
19 CUST_2_TITLE CHARACTER VARYING(100) 100
20 CUST_2_FRST_NAM CHARACTER VARYING(100) 100
21 CUST_2_LST_NAM CHARACTER VARYING(100) 100
22 CUST_2_AGE CHARACTER VARYING(10) 10
23 CUST_2_DOB CHARACTER VARYING(20) 20
24 CUST_2_GNDR_IND CHARACTER VARYING(10) 10
25 CUST_1_SEGMENT_CODE CHARACTER VARYING(50) 50
26 CUST_2_SEGMENT_CODE CHARACTER VARYING(50) 50
27 FULL_ADDR_TEXT CHARACTER VARYING(150) 150
28 ADDR_LNE_1 CHARACTER VARYING(100) 100
29 ADDR_LNE_2 CHARACTER VARYING(50) 50
30 ADDR_LNE_3 CHARACTER VARYING(50) 50
31 SBRB_CODE CHARACTER VARYING(50) 50
32 STATE_CODE CHARACTER VARYING(20) 20
33 POST_CODE CHARACTER VARYING(10) 10
34 PH_NUM_1 CHARACTER VARYING(20) 20
35 PH_NUM_2 CHARACTER VARYING(20) 20
36 BRND_CODE CHARACTER VARYING(20) 20
37 POL_NUM CHARACTER VARYING(20) 20
38 INS_TYP_CODE CHARACTER VARYING(50) 50
39 COV_TYP_CODE CHARACTER VARYING(50) 50
40 PREM_AMT CHARACTER VARYING(20) 20
41 DUE_DATE CHARACTER VARYING(20) 20
42 NOTES_TEXT CHARACTER VARYING(250) 250
43 RECORD_GEN_DATE CHARACTER VARYING(20) 20
44 EMAIL_ID CHARACTER VARYING(200) 200
45 CMNT_TEXT CHARACTER VARYING(250) 250
46 CMPGN_PRTY_CODE CHARACTER VARYING(10) 10
47 AGNT_CODE CHARACTER VARYING(20) 20
48 RECENT_CALL_DATE CHARACTER VARYING(20) 20
49 RECENT_CALL_TME CHARACTER VARYING(20) 20
50 RECENT_CALL_STAT_CODE CHARACTER VARYING(10) 10
51 SYS_ENTRY_DATE CHARACTER VARYING(20) 20
52 STAT_FLG CHARACTER VARYING(10) 10
53 CALL_ATTEMPT_CNT CHARACTER VARYING(4) 4
54 RECALL_DATE CHARACTER VARYING(10) 10
55 RECALL_TME CHARACTER VARYING(10) 10
56 RECALL_PH_NUM CHARACTER VARYING(20) 20
57 RECALL_NUM CHARACTER VARYING(20) 20
58 RECORD_AGE_DAYS_CNT CHARACTER VARYING(10) 10
59 CRNT_DIALLED_PH_NUM_CODE CHARACTER VARYING(20) 20
60 DUP_RECORD_FLG CHARACTER VARYING(4) 4
61 PH_STAT_CODE CHARACTER VARYING(10) 10
62 JOB_NAM CHARACTER VARYING(20) 20
63 FINAL_AGNT_CODE CHARACTER VARYING(20) 20
64 SALE_CODE CHARACTER VARYING(10) 10
65 SHADOW_JOB_NAM CHARACTER VARYING(20) 20
66 JOB_ID CHARACTER VARYING(10) 10
67 MSTR_TME_ZONE_CODE CHARACTER VARYING(10) 10
68 DUP_RECORD_NUM CHARACTER VARYING(4) 4
69 CALL_DURATION_TME CHARACTER VARYING(20) 20
70 PH_1_SYS_TME_ZONE_FLG CHARACTER VARYING(4) 4
71 PH_2_SYS_TME_ZONE_FLG CHARACTER VARYING(4) 4
72 PH_1_CALL_ATTEMPT_CNT CHARACTER VARYING(4) 4
73 PH_2_CALL_ATTEMPT_CNT CHARACTER VARYING(4) 4
74 PH_1_FRST_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
75 PH_1_FRST_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
76 PH_1_FRST_CALL_STAT_CODE CHARACTER VARYING(10) 10
77 PH_1_FRST_CALL_STAT_ID NUMERIC(22,0) 19
78 PH_1_SCND_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
79 PH_1_SCND_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
80 PH_1_SCND_CALL_STAT_CODE CHARACTER VARYING(10) 10
81 PH_1_SCND_CALL_STAT_ID NUMERIC(22,0) 19
82 PH_1_THRD_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
83 PH_1_THRD_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
84 PH_1_THRD_CALL_STAT_CODE CHARACTER VARYING(10) 10
85 PH_1_THRD_CALL_STAT_ID NUMERIC(22,0) 19
86 PH_1_FRTH_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
87 PH_1_FRTH_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
88 PH_1_FRTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
89 PH_1_FRTH_CALL_STAT_ID NUMERIC(22,0) 19
90 PH_1_FFTH_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
91 PH_1_FFTH_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
92 PH_1_FFTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
93 PH_1_FFTH_CALL_STAT_ID NUMERIC(22,0) 19
94 PH_1_LST_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
95 PH_1_LST_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
96 PH_1_LST_CALL_STAT_CODE CHARACTER VARYING(10) 10
97 PH_1_LST_CALL_STAT_ID NUMERIC(22,0) 19
98 PH_2_FRST_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
99 PH_2_FRST_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
100 PH_2_FRST_CALL_STAT_CODE CHARACTER VARYING(10) 10
101 PH_2_FRST_CALL_STAT_ID NUMERIC(22,0) 19
102 PH_2_SCND_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
103 PH_2_SCND_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
104 PH_2_SCND_CALL_STAT_CODE CHARACTER VARYING(10) 10
105 PH_2_SCND_CALL_STAT_ID NUMERIC(22,0) 19
106 PH_2_THRD_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
107 PH_2_THRD_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
108 PH_2_THRD_CALL_STAT_CODE CHARACTER VARYING(10) 10
109 PH_2_THRD_CALL_STAT_ID NUMERIC(22,0) 19
110 PH_2_FRTH_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
111 PH_2_FRTH_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
112 PH_2_FRTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
113 PH_2_FRTH_CALL_STAT_ID NUMERIC(22,0) 19
114 PH_2_FFTH_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
115 PH_2_FFTH_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
116 PH_2_FFTH_CALL_STAT_CODE CHARACTER VARYING(10) 10
117 PH_2_FFTH_CALL_STAT_ID NUMERIC(22,0) 19
118 PH_2_LST_CALL_ATTEMPT_DATE CHARACTER VARYING(20) 20
119 PH_2_LST_CALL_ATTEMPT_TME CHARACTER VARYING(20) 20
120 PH_2_LST_CALL_STAT_CODE CHARACTER VARYING(10) 10
121 PH_2_LST_CALL_STAT_ID NUMERIC(22,0) 19
122 DATA_LOAD_DATE TIMESTAMP 8
123 SRC_SYS_ID CHARACTER VARYING(5) 5
124 LOAD_ID NUMERIC(22,0) 19
125 VALID_RECORD_GEN_DATE TIMESTAMP 8
126 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
127 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
128 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
129 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8