CFD_TCFDD_SALMAT_DIALLER_REJECT

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INCIDENT_ID CHARACTER VARYING(20) 20
2 LEAD_CAT_CODE CHARACTER VARYING(10) 10
3 CMPGN_NAM CHARACTER VARYING(100) 100
4 CMPGN_DESC CHARACTER VARYING(500) 500
5 FOLLOW_UP_DATE TIMESTAMP 8
6 CUST_CONSNT_FLG CHARACTER VARYING(3) 3
7 CUST_NUM_1 CHARACTER VARYING(20) 20
8 CUST_1_FULL_NAM CHARACTER VARYING(100) 100
9 CUST_1_TITLE CHARACTER VARYING(50) 50
10 CUST_1_FRST_NAM CHARACTER VARYING(50) 50
11 CUST_1_LST_NAM CHARACTER VARYING(50) 50
12 CUST_1_BRTH_DATE TIMESTAMP 8
13 CUST_1_GNDR_IND CHARACTER VARYING(3) 3
14 CUST_NUM_2 CHARACTER VARYING(20) 20
15 CUST_2_FULL_NAM CHARACTER VARYING(100) 100
16 CUST_2_TITLE CHARACTER VARYING(50) 50
17 CUST_2_FRST_NAM CHARACTER VARYING(50) 50
18 CUST_2_LST_NAM CHARACTER VARYING(50) 50
19 CUST_2_BRTH_DATE TIMESTAMP 8
20 CUST_2_GNDR_IND CHARACTER VARYING(3) 3
21 FULL_ADDR_TEXT CHARACTER VARYING(100) 100
22 ADDR_LNE_1 CHARACTER VARYING(50) 50
23 ADDR_LNE_2 CHARACTER VARYING(50) 50
24 ADDR_LNE_3 CHARACTER VARYING(50) 50
25 SBRB_CODE CHARACTER VARYING(50) 50
26 STATE_CODE CHARACTER VARYING(10) 10
27 POST_CODE CHARACTER VARYING(10) 10
28 PH_NUM_1 CHARACTER VARYING(20) 20
29 PH_NUM_2 CHARACTER VARYING(20) 20
30 PH_NUM_3 CHARACTER VARYING(20) 20
31 BRND_CODE CHARACTER VARYING(20) 20
32 PRDT_VAL_AMT NUMERIC(18,6) 19
33 PRDT_DUE_DATE TIMESTAMP 8
34 PRDT_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(20) 20
40 PRDT_TYP_DESC CHARACTER VARYING(30) 30
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 TRTMNT_CODE CHARACTER VARYING(10) 10
46 OFFER_CODE CHARACTER VARYING(10) 10
47 CMPGN_CHNL_DESC CHARACTER VARYING(20) 20
48 GENERIC_1_NUM CHARACTER VARYING(10) 10
49 GENERIC_2_NUM CHARACTER VARYING(10) 10
50 GENERIC_3_NUM CHARACTER VARYING(10) 10
51 CNTCT_STRT_DATE TIMESTAMP 8
52 GENERIC_1_DATE TIMESTAMP 8
53 GENERIC_2_DATE TIMESTAMP 8
54 GENERIC_3_DATE TIMESTAMP 8
55 GENERIC_4_DATE TIMESTAMP 8
56 GENERIC_5_DATE TIMESTAMP 8
57 GENERIC_6_DATE TIMESTAMP 8
58 GENERIC_7_DATE TIMESTAMP 8
59 GENERIC_8_DATE TIMESTAMP 8
60 CALL_EXPIRY_DATE TIMESTAMP 8
61 GENERIC_1_TEXT CHARACTER VARYING(50) 50
62 CMPY_CUST_NUM CHARACTER VARYING(30) 30
63 GENERIC_2_TEXT CHARACTER VARYING(50) 50
64 GENERIC_3_TEXT CHARACTER VARYING(50) 50
65 GENERIC_4_TEXT CHARACTER VARYING(100) 100
66 GENERIC_5_TEXT CHARACTER VARYING(50) 50
67 GENERIC_6_TEXT CHARACTER VARYING(50) 50
68 CUST_CNT_TEXT CHARACTER VARYING(50) 50
69 GENERIC_7_TEXT CHARACTER VARYING(50) 50
70 GENERIC_8_TEXT CHARACTER VARYING(50) 50
71 GENERIC_9_TEXT CHARACTER VARYING(50) 50
72 GENERIC_10_TEXT CHARACTER VARYING(50) 50
73 GENERIC_11_TEXT CHARACTER VARYING(50) 50
74 GENERIC_12_TEXT CHARACTER VARYING(50) 50
75 GENERIC_13_TEXT CHARACTER VARYING(50) 50
76 GENERIC_14_TEXT CHARACTER VARYING(50) 50
77 GENERIC_16_TEXT CHARACTER VARYING(50) 50
78 GENERIC_17_TEXT CHARACTER VARYING(50) 50
79 GENERIC_18_TEXT CHARACTER VARYING(50) 50
80 GENERIC_19_TEXT CHARACTER VARYING(50) 50
81 GENERIC_20_TEXT CHARACTER VARYING(50) 50
82 GENERIC_21_TEXT CHARACTER VARYING(50) 50
83 GENERIC_22_TEXT CHARACTER VARYING(50) 50
84 GENERIC_23_TEXT CHARACTER VARYING(50) 50
85 GENERIC_24_TEXT CHARACTER VARYING(50) 50
86 CMNT_TEXT CHARACTER VARYING(250) 250
87 CMPGN_PRTY_CODE CHARACTER VARYING(10) 10
88 UNIQUE_ID CHARACTER VARYING(30) 30
89 DATA_LOAD_DATE TIMESTAMP 8
90 SNPSHT_DATE TIMESTAMP 8
91 SRC_SYS_ID CHARACTER VARYING(50) 50
92 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
93 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
94 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
95 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8