CFD_TCFDD_RAPPORT_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 RAPPORT_ID DOUBLE PRECISION 8
3 INCIDENT_ID CHARACTER VARYING(20) 20
4 CATEGORY_CODE CHARACTER VARYING(10) 10
5 CMPGN_NAM CHARACTER VARYING(100) 100
6 CMPGN_DESC CHARACTER VARYING(500) 500
7 FOLLOW_UP_DATE TIMESTAMP 8
8 CUST_NUM_1 CHARACTER VARYING(20) 20
9 CUST_1_FULL_NAM CHARACTER VARYING(100) 100
10 CUST_1_TITLE CHARACTER VARYING(50) 50
11 CUST_1_FRST_NAM CHARACTER VARYING(50) 50
12 CUST_1_LST_NAM CHARACTER VARYING(50) 50
13 CUST_1_BRTH_DATE TIMESTAMP 8
14 CUST_1_GNDR_IND CHARACTER VARYING(3) 3
15 CUST_NUM_2 CHARACTER VARYING(20) 20
16 CUST_2_FULL_NAM CHARACTER VARYING(100) 100
17 CUST_2_TITLE CHARACTER VARYING(50) 50
18 CUST_2_FRST_NAM CHARACTER VARYING(50) 50
19 CUST_2_LST_NAM CHARACTER VARYING(50) 50
20 CUST_2_BRTH_DATE TIMESTAMP 8
21 CUST_2_GNDR_IND CHARACTER VARYING(3) 3
22 FULL_ADDR_TEXT CHARACTER VARYING(100) 100
23 ADDR_LNE_1 CHARACTER VARYING(50) 50
24 ADDR_LNE_2 CHARACTER VARYING(50) 50
25 ADDR_LNE_3 CHARACTER VARYING(50) 50
26 SBRB_CODE CHARACTER VARYING(50) 50
27 STATE_CODE CHARACTER VARYING(50) 50
28 POST_CODE CHARACTER VARYING(10) 10
29 PH_NUM_1 CHARACTER VARYING(20) 20
30 PH_NUM_2 CHARACTER VARYING(20) 20
31 BRND_CODE CHARACTER VARYING(10) 10
32 PREM_AMT CHARACTER VARYING(20) 20
33 PRDT_DUE_DATE TIMESTAMP 8
34 POL_NUM CHARACTER VARYING(20) 20
35 NOTE_TEXT CHARACTER VARYING(100) 100
36 CUST_1_AGE_YR CHARACTER VARYING(10) 10
37 CUST_2_AGE_YR CHARACTER VARYING(10) 10
38 RECORD_GNRTN_DATE TIMESTAMP 8
39 CMPGN_CODE CHARACTER VARYING(50) 50
40 INS_TYP_CODE CHARACTER VARYING(50) 50
41 CVRG_TYP_CODE CHARACTER VARYING(50) 50
42 CUST_1_SGMNT_DESC CHARACTER VARYING(20) 20
43 CUST_2_SGMNT_DESC CHARACTER VARYING(20) 20
44 EMAIL_ADDR CHARACTER VARYING(100) 100
45 GENERIC_1_NUM CHARACTER VARYING(10) 10
46 GENERIC_2_NUM CHARACTER VARYING(10) 10
47 GENERIC_3_NUM CHARACTER VARYING(10) 10
48 GENERIC_4_NUM CHARACTER VARYING(10) 10
49 GENERIC_5_NUM CHARACTER VARYING(10) 10
50 GENERIC_6_NUM CHARACTER VARYING(10) 10
51 GENERIC_1_DATE TIMESTAMP 8
52 GENERIC_2_DATE TIMESTAMP 8
53 GENERIC_3_DATE TIMESTAMP 8
54 GENERIC_4_DATE TIMESTAMP 8
55 GENERIC_5_DATE TIMESTAMP 8
56 GENERIC_6_DATE TIMESTAMP 8
57 GENERIC_1_TEXT CHARACTER VARYING(50) 50
58 GENERIC_2_TEXT CHARACTER VARYING(50) 50
59 GENERIC_3_TEXT CHARACTER VARYING(50) 50
60 GENERIC_4_TEXT CHARACTER VARYING(100) 100
61 GENERIC_5_TEXT CHARACTER VARYING(50) 50
62 GENERIC_6_TEXT CHARACTER VARYING(50) 50
63 GENERIC_7_TEXT CHARACTER VARYING(50) 50
64 GENERIC_8_TEXT CHARACTER VARYING(50) 50
65 GENERIC_9_TEXT CHARACTER VARYING(50) 50
66 GENERIC_10_TEXT CHARACTER VARYING(50) 50
67 GENERIC_11_TEXT CHARACTER VARYING(50) 50
68 CMNT_TEXT CHARACTER VARYING(250) 250
69 CMPGN_PRTY_CODE CHARACTER VARYING(10) 10
70 RAPPORT_UNIQUE_CODE CHARACTER VARYING(50) 50
71 RAPPORT_BRND_CODE CHARACTER VARYING(20) 20
72 RAPPORT_CMPGN_CODE CHARACTER VARYING(50) 50
73 RAPPORT_CMPGN_ID DOUBLE PRECISION 8
74 CMPGN_DATE TIMESTAMP 8
75 CMPGN_PRDT CHARACTER VARYING(50) 50
76 CLIENT_FRST_NAM CHARACTER VARYING(100) 100
77 CLIENT_LST_NAM CHARACTER VARYING(50) 50
78 CLIENT_ADDR_LNE_1 CHARACTER VARYING(50) 50
79 CLIENT_ADDR_LNE_2 CHARACTER VARYING(50) 50
80 CLIENT_ADDR_LNE_3 CHARACTER VARYING(50) 50
81 CLIENT_SBRB_CODE CHARACTER VARYING(50) 50
82 CLIENT_POST_CODE CHARACTER VARYING(20) 20
83 CLIENT_STATE_CODE CHARACTER VARYING(50) 50
84 CLIENT_CNTRY_DESC CHARACTER VARYING(50) 50
85 CLIENT_DOB TIMESTAMP 8
86 FINAL_CALL_DATE TIMESTAMP 8
87 FINAL_CALL_TIME CHARACTER VARYING(20) 20
88 CALL_STAT_ID DOUBLE PRECISION 8
89 CALL_STAT_CODE CHARACTER VARYING(100) 100
90 CALL_ATTEMPT_CNT DOUBLE PRECISION 8
91 OFFER_PREF CHARACTER VARYING(50) 50
92 DIALLED_NUM CHARACTER VARYING(20) 20
93 PHONE_TYPE CHARACTER VARYING(4) 4
94 EFF_STRT_DATE TIMESTAMP 8
95 EFF_END_DATE TIMESTAMP 8
96 DATA_LOAD_DATE TIMESTAMP 8
97 SNPSHT_DATE TIMESTAMP 8
98 SRC_SYS_ID CHARACTER VARYING(5) 5
99 LOAD_ID DOUBLE PRECISION 8
100 CUST_NUM CHARACTER VARYING(20) 20
101 CMPY_CUST_NUM CHARACTER VARYING(20) 20
102 INBND_OUTBND_CODE CHARACTER VARYING(10) 10
103 DIALLER_ATTEMPT_CNT DOUBLE PRECISION 8
104 AGNT_ATTEMPT_CNT DOUBLE PRECISION 8
105 CMPLT_FLG CHARACTER(1) 1
106 EXPIRY_FLG CHARACTER(1) 1
107 ACCT_FLG CHARACTER(1) 1
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