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