ext_bnk_crai_facility_collateral_linkage_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 facility_id character varying 256
2 collateral_id character varying 256
3 collateral_type character varying 256
4 collateral_category character varying 256
5 collateral_sub_category character varying 256
6 collateral_state character varying 256
7 collateral_suburb character varying
8 collateral_postcode character varying 256
9 owner_estimated_value numeric 38
10 bank_value numeric 38
11 market_value numeric 38
12 basel_use_type character varying 256
13 is_subordinated_collateral character varying 256
14 suncorp_collateral_value numeric 38
15 deleted_or_discharged_date date
16 monthend_date date