ext_bnk_crai_customer

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 gcis_party_id character varying 30
2 dob date
3 gender character varying 10
4 surname_change_flag character varying 1
5 deceased_ind character varying 1
6 prim_contact_ind character varying 1
7 res_address_suburb character varying 40
8 res_address_postcode character varying 10
9 res_address_state character varying 30
10 res_address_country_code character varying 2
11 res_country_name character varying 60
12 mailing_address_suburb character varying 40
13 mailing_address_postcode character varying 10
14 mailing_address_state character varying 30
15 mailing_address_country character varying 2
16 mailing_country_name character varying 60
17 mailing_po_box_flag character varying 1
18 global_consent_ind character varying 1
19 sms_consent_ind character varying 1
20 phone_consent_ind character varying 1
21 email_consent_ind character varying 1
22 online_consent_ind character varying 1
23 mail_consent_ind character varying 1
24 monthend_date date