| 1 |
facility_id |
character varying |
120 |
| 2 |
collateral_id |
character varying |
54 |
| 3 |
collateral_type |
character varying |
150 |
| 4 |
collateral_category |
character varying |
150 |
| 5 |
collateral_sub_category |
character varying |
150 |
| 6 |
collateral_state |
character varying |
90 |
| 7 |
collateral_suburb |
character varying |
150 |
| 8 |
collateral_postcode |
character varying |
90 |
| 9 |
owner_estimated_value |
character varying |
75 |
| 10 |
bank_value |
character varying |
75 |
| 11 |
market_value |
character varying |
75 |
| 12 |
basel_use_type |
character varying |
150 |
| 13 |
is_subordinated_collateral |
character varying |
3 |
| 14 |
suncorp_collateral_value |
double precision |
53 |
| 15 |
deleted_or_discharged_date |
timestamp without time zone |
|
| 16 |
effective_start_date |
date |
|
| 17 |
effective_end_date |
timestamp without time zone |
|
| 18 |
effective_start_date_coll_link |
date |
|
| 19 |
effective_end_date_coll_link |
date |
|
| 20 |
monthend_date |
date |
|