dim_bnk_crai_account_customer_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_efs_dim_id bigint 64
2 account_id_number character varying 150
3 account_number character varying 120
4 account_role_code character varying 150
5 effective_end_date timestamp without time zone
6 effective_start_date timestamp without time zone
7 gcis_party_id character varying 1200
8 gcis_party_type character varying 3
9 gcis_relationship_type_descr character varying 240
10 is_current character varying 3
11 is_primary_party_id character varying 3
12 efs_party_dim_id character varying 180
13 party_type character varying 9
14 product_system_company_code character varying 9
15 product_system_customer_number character varying 150
16 relationship_type character varying 9
17 source_system_code character varying 36
18 source_system_group character varying 9