fct_obp_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 279
2 source_system_group character varying 9
3 application_id character varying 150
4 facility_number character varying 120
5 application_efs_dim_id character varying 159
6 facility_type character varying 24
7 facility_status_code character varying 150
8 facility_creation_date timestamp without time zone
9 application_creation_date timestamp without time zone
10 product_class character varying 6
11 product_group_code character varying 48
12 product_code character varying 150
13 product_sub_code character varying 120
14 source_product_code character varying 315
15 purpose_code character varying 120
16 sub_purpose_code character varying 765
17 loan_term_mths integer 32
18 fixed_or_variable character varying 3
19 fixed_rate_term_months integer 32
20 repayment_type character varying 102
21 int_only_term_months integer 32
22 interest_rate numeric 15
23 base_rate numeric 15
24 margin_rate numeric 15
25 loan_use character varying 42
26 owner_occupied character varying 3
27 first_home_buyer character varying 3
28 application_status character varying 150
29 first_application_lodgement_date timestamp without time zone
30 last_application_lodgement_date timestamp without time zone
31 first_structure_soln_confirmed_date timestamp without time zone
32 last_structure_soln_confirmed_date timestamp without time zone
33 first_conditional_approval_date timestamp without time zone
34 last_conditional_approval_date timestamp without time zone
35 first_application_unconditional_approval_date timestamp without time zone
36 last_application_unconditional_approval_date timestamp without time zone
37 first_offer_letter_dispatch_date timestamp without time zone
38 last_offer_letter_dispatch_date timestamp without time zone
39 first_offer_letter_acceptance_date timestamp without time zone
40 last_offer_letter_acceptance_date timestamp without time zone
41 settlement_date timestamp without time zone
42 application_withdrawn_date timestamp without time zone
43 add_loan_flag character varying 3
44 amend_type character varying 27
45 amend_date timestamp without time zone
46 revolving_facility_flag character varying 3
47 redraw_capable_product character varying 3
48 facility_reporting_amount numeric 25
49 credit_limit numeric 25
50 credit_limit_without_fees numeric 25
51 credit_establishment_fees numeric 25
52 facility_add_loan_amount numeric 25
53 currency character varying 9
54 facility_lvr numeric 25
55 borrower_contribution_amount numeric 25
56 facility_maturity_date timestamp without time zone
57 accredited_broker_id character varying 60
58 broker_code character varying 120
59 cost_centre character varying 720
60 preapproval_flag character varying 3
61 preapproval_conversion_date timestamp without time zone
62 load_date timestamp without time zone
63 effective_start_date timestamp without time zone
64 effective_end_date timestamp without time zone
65 is_current character varying 3