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