crm_customer

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 customer_id character varying 27
4 party_type character varying 3
5 customer_status character varying 3
6 customer_type character varying 36
7 scrub_name_ind character varying 3
8 personal_title character varying 90
9 first_name character varying 90
10 middle_name character varying 180
11 last_name character varying 120
12 name_suffix character varying 90
13 pref_name character varying 90
14 organisation_name character varying 360
15 unscrub_name character varying 3042
16 date_of_birth character varying 30
17 gender character varying 3
18 drivers_licence character varying 30
19 deceased_ind character varying 3
20 abn character varying 33
21 acn character varying 27
22 arbn character varying 27
23 company_type character varying 150
24 website character varying 765
25 occupation_code character varying 6
26 customer_package character varying 150
27 staff_user_id character varying 300
28 staff_package character varying 300
29 anzsic_code character varying 12
30 timestampentered character varying 78
31 userentered character varying 30
32 timestampwritten character varying 78
33 userwritten character varying 30
34 delta_type character varying 3
35 effective_strt_dt timestamp without time zone
36 effective_end_dt timestamp without time zone