ext_bnk_crai_origination_application_facility_sunloans_hash_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 submission_id character varying 512
2 facility_id character varying 512
3 source_system_code character varying 3
4 facility_status_type character varying 8
5 amend_type character varying 9
6 submission_credit_score numeric 20
7 requested_amount numeric 15
8 approved_amount numeric 15
9 facility_add_loan_amount numeric 25
10 accredited_broker_code character varying 512
11 submission_status character varying 50
12 application_decision_type character varying 20
13 application_decision_reason character varying 200
14 submission_cancelled_by character varying 10
15 application_withdrawn_date timestamp without time zone
16 source_product_code character varying 105
17 purpose_code character varying 40
18 purpose_description character varying 65
19 sub_purpose_code character varying 255
20 sub_purpose_description character varying 65
21 interest_rate_type character varying 1
22 repayment_type character varying 34
23 owner_occupied character varying 1
24 first_home_buyer character varying 1
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 timestamp without time zone