ua_contacthistory_v10

Database

prod_bank_wealth

Schema

sor_unic

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 audience_type character varying 6
2 customer_number character varying 60
3 brand character varying 30
4 cellid bigint 64
5 packageid bigint 64
6 contactstatusid bigint 64
7 contactdatetime timestamp without time zone
8 updatedatetime timestamp without time zone
9 dateid bigint 64
10 timeid bigint 64
11 customer_number_contact character varying 60
12 household_id integer 32
13 gcis_customer_number character varying 90
14 source_system_code character varying 30
15 source_system_customer_number character varying 90
16 policy_account_number character varying 90
17 product_holding_number character varying 60
18 treatment_code character varying 30
19 campaign_code character varying 60
20 cell_code character varying 30
21 cell_name character varying 300
22 control_flag smallint 16
23 channel character varying 90
24 offer_code character varying 192
25 mail_consent_indicator character varying 12
26 sms_consent_indicator character varying 12
27 email_consent_indicator character varying 12
28 phone_consent_indicator character varying 12
29 flex_char_01 character varying 300
30 flex_char_02 character varying 300
31 flex_char_03 character varying 300
32 flex_char_04 character varying 300
33 flex_char_05 character varying 300
34 flex_char_06 character varying 300
35 flex_char_07 character varying 300
36 flex_char_08 character varying 300
37 flex_char_09 character varying 300
38 flex_char_10 character varying 300
39 flex_num_01 bigint 64
40 flex_num_02 bigint 64
41 flex_num_03 bigint 64
42 flex_num_04 bigint 64
43 flex_num_05 bigint 64
44 flex_date_01 date
45 flex_date_02 date
46 flex_date_03 date
47 flex_date_04 date
48 flex_date_05 date
49 cdc_source_system_code character varying 12
50 cdc_record_type character varying 48
51 cdc_commit_timestamp timestamp without time zone
52 cdc_extract_timestamp timestamp without time zone
53 c_mail_address character varying 1500
54 c_email_address character varying 300
55 c_phone character varying 63