sln_application_master

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 appln_id character varying 60
4 banking_type character varying 180
5 appln_urgency numeric 6
6 base_loan_amt numeric 13
7 total_loan_amt numeric 13
8 pre_apprvd_fl character varying 3
9 total_funding_amt numeric 13
10 creation_date timestamp without time zone
11 received_date timestamp without time zone
12 cond_approved_date timestamp without time zone
13 cond_approved_officer character varying 36
14 uncond_approved_date timestamp without time zone
15 uncond_approved_officer character varying 36
16 est_settlement_date timestamp without time zone
17 est_finance_date timestamp without time zone
18 est_mdr_date timestamp without time zone
19 broker_code character varying 60
20 sales_branch_code character varying 15
21 initiator_is_lender_fl character varying 3
22 lender_id character varying 36
23 supp_officer_id character varying 36
24 first_home_buyer_fl character varying 3
25 campaign_benefit_fl character varying 3
26 workflow_stage character varying 180
27 workflow_status character varying 180
28 workflow_action character varying 180
29 curr_workbasket character varying 180
30 curr_operator_id character varying 36
31 trf_insert_date timestamp without time zone
32 accredited_broker_code character varying 30
33 bus_date timestamp without time zone
34 electronic_lodgement_no character varying 90
35 quality_standard_flag character varying 3
36 quality_reasons character varying 300
37 quality_measures_user_id character varying 150
38 sett_brch_code character varying 15
39 has_split character varying 3
40 tcey numeric 13
41 exception_reason_1 character varying 30
42 exception_reason_2 character varying 30
43 exception_reason_3 character varying 30
44 gross_occupation_income numeric 13
45 asset_income numeric 13
46 proposed_income numeric 13
47 non_taxable_income numeric 13
48 hh1_no_of_adult integer 32
49 hh1_no_of_dependents integer 32
50 hh2_no_of_adult integer 32
51 hh2_no_of_dependents integer 32
52 no_of_household integer 32
53 hh1_cust_entered_expense numeric 13
54 hh1_ctr_calculated_expense numeric 13
55 hh2_cust_entered_expense numeric 13
56 hh2_ctr_calculated_expense numeric 13
57 hh1_net_income numeric 13
58 hh2_net_income numeric 13
59 existing_repayments numeric 13
60 sensitised_existing_repayment numeric 13
61 new_repayment numeric 13
62 new_repayment_sensitised numeric 13
63 actual_proposed_income numeric 13
64 hh1_application_type character varying 300
65 hh2_application_type character varying 300
66 arrangement_lvr numeric 13
67 is_el_application character varying 60
68 data_date timestamp without time zone
69 load_id integer 32