fct_obp_crai_party_eod_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 efs_party_dim_id character varying 129
2 source_system_customer_id character varying 120
3 source_system_code character varying 9
4 party_type character varying 3
5 party_status_code character varying 3
6 party_name character varying 1065
7 date_of_birth timestamp without time zone
8 deceased_date timestamp without time zone
9 primary_gcis_id character varying 1200
10 abn character varying 90
11 acn character varying 90
12 anzsic_code character varying 12
13 gender_code character varying 3
14 residency_code character varying 36
15 residency_country_code character varying 6
16 phone_number character varying 60
17 work_phone_number character varying 135
18 mobile_number character varying 135
19 broker_phone_number character varying 135
20 email_address character varying 360
21 email_addr_type character varying 6
22 effective_start_date timestamp without time zone
23 effective_end_date timestamp without time zone
24 is_current character varying 3