fct_obp_crai_application_facility_collateral_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 application_facility_efs_dim_id character varying 120
2 source_system_group character varying 120
3 application_id character varying 120
4 facility_number character varying 120
5 collateral_id character varying 60
6 collateral_type character varying 150
7 collateral_category character varying 150
8 collateral_sub_category character varying 150
9 collateral_state character varying 120
10 suncorp_collateral_value double precision 53
11 sum_non_suncorp_charges numeric 31
12 sum_suncorp_charges numeric 31
13 calc_market_value double precision 53
14 is_subordinated_collateral character varying 3
15 effective_start_date timestamp without time zone
16 effective_end_date timestamp without time zone
17 is_current character varying 3