fct_sln_crai_application_facility_eod_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 129
2 source_system_group character varying 9
3 application_id character varying 60
4 facility_number character varying 60
5 account_number character varying 60
6 application_efs_dim_id character varying 69
7 facility_type character varying 24
8 facility_status_code character varying 180
9 facility_creation_date timestamp without time zone
10 product_class character varying 6
11 product_group_code character varying 279
12 product_code character varying 18
13 product_sub_code character varying 18
14 purpose_code character varying 180
15 sub_purpose_code character varying 180
16 loan_term_mths integer 32
17 fixed_or_variable character varying 3
18 fixed_rate_term_months integer 32
19 repayment_type character varying 72
20 int_only_term_months integer 32
21 interest_rate numeric 6
22 margin_rate numeric 29
23 loan_use character varying 180
24 owner_occupied character varying 3
25 first_home_buyer character varying 3
26 latest_submission_date timestamp without time zone
27 application_status character varying 180
28 application_lodgement_date timestamp without time zone
29 application_conditional_approval_date timestamp without time zone
30 application_unconditional_approval_date timestamp without time zone
31 settlement_date timestamp without time zone
32 application_withdrawn_date timestamp without time zone
33 add_loan_flag character varying 3
34 revolving_facility_flag character varying 3
35 requested_amount numeric 13
36 credit_limit numeric 13
37 credit_limit_without_fees numeric 29
38 credit_establishment_fees numeric 29
39 facility_add_loan_amount numeric 13
40 currency character varying 9
41 facility_lvr numeric 8
42 borrower_contribution_amount numeric 13
43 facility_maturity_date timestamp without time zone
44 app_base_loan_amt numeric 13
45 app_total_loan_amt numeric 13
46 app_total_funding_amt numeric 13
47 app_tce numeric 13
48 app_broker_code character varying 60
49 app_accredited_broker_code character varying 21
50 fac_product_interest_rate numeric 6
51 fac_loan_amt numeric 13
52 fac_total_funding_amt numeric 13
53 fac_banking_type character varying 180
54 fac_loan_type character varying 180
55 load_date timestamp without time zone
56 effective_start_date timestamp without time zone
57 effective_end_date timestamp without time zone
58 is_current character varying 3
59 preapproval_flag character varying 3
60 preapproval_conversion_date timestamp without time zone