ext_bnk_crai_origination_application_facility_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 submission_id character varying 150
2 facility_id character varying 120
3 source_system_code character varying 9
4 facility_status_type character varying 24
5 amend_type character varying 27
6 submission_credit_score numeric 20
7 requested_amount double precision 53
8 approved_amount double precision 53
9 facility_add_loan_amount numeric 25
10 accredited_broker_code character varying 60
11 submission_status character varying 150
12 application_decision_type character varying 150
13 application_decision_reason text
14 application_withdrawn_date timestamp without time zone
15 submission_cancelled_by character varying 30
16 source_product_code character varying 315
17 purpose_code character varying 120
18 purpose_description character varying 300
19 sub_purpose_code character varying 765
20 sub_purpose_description character varying 300
21 interest_rate_type character varying 3
22 repayment_type character varying 102
23 owner_occupied character varying 3
24 first_home_buyer character varying 3
25 facility_lvr_origination numeric 25
26 first_application_lodgement_date timestamp without time zone
27 last_application_lodgement_date timestamp without time zone
28 first_conditional_approval_date timestamp without time zone
29 last_conditional_approval_date timestamp without time zone
30 first_application_unconditional_approval_date timestamp without time zone
31 last_application_unconditional_approval_date timestamp without time zone
32 first_offer_letter_dispatch_date timestamp without time zone
33 last_offer_letter_dispatch_date timestamp without time zone
34 first_offer_letter_acceptance_date timestamp without time zone
35 last_offer_letter_acceptance_date timestamp without time zone
36 settlement_date timestamp without time zone
37 monthend_date date