hog_cis_hst_master

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 key_coid integer 32
4 customer_no bigint 64
5 customer_name character varying 240
6 customer_type_code character varying 6
7 business_customer_type character varying 3
8 birth_date character varying 30
9 deceased_date character varying 30
10 occupation_code character varying 12
11 anzsic_code character varying 12
12 marital_status_code character varying 3
13 gender_code character varying 3
14 bankrupt_date character varying 30
15 dt_opened character varying 30
16 customer_100point_ind character varying 3
17 last_maint_date character varying 30
18 branch_no integer 32
19 pers_phone_nbr character varying 48
20 bus_phone_nbr character varying 48
21 pers_mobile_nbr character varying 48
22 abn_number character varying 33
23 acn_arbn_no character varying 30
24 cust_id character varying 27
25 cust_tie_brkr integer 32
26 status_cd character varying 9
27 cust_type_ind character varying 3
28 close_date character varying 30
29 bus_estab_date character varying 30
30 nationality_cd character varying 6
31 res_status character varying 3
32 lst_contact_date character varying 30
33 delta_type character varying 3
34 effective_strt_dt timestamp without time zone
35 effective_end_dt timestamp without time zone