sln_facility

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 sln_facility_hiid bigint 64
2 action_code character varying 3
3 appln_id character varying 60
4 facility_id character varying 60
5 banking_type character varying 180
6 loan_type character varying 180
7 loan_use character varying 180
8 loan_amt numeric 13
9 loan_acct character varying 60
10 loan_term_mths numeric 22
11 int_only_term_mths numeric 22
12 product_code character varying 18
13 add_loan_fl character varying 3
14 loan_purpose_code character varying 180
15 loan_sub_purpose_code character varying 180
16 lvr numeric 8
17 total_funding_amt numeric 13
18 borr_contribution numeric 13
19 actual_int_rate numeric 6
20 product_int_rate numeric 6
21 settlement_date timestamp without time zone
22 finance_date timestamp without time zone
23 suncorp_staff_fl character varying 3
24 owned_equity_type character varying 72
25 borrowed_equity_type character varying 72
26 payment_type character varying 72
27 int_capitalised_fl character varying 3
28 progressive_draw_fl character varying 3
29 upfront_rebate_auth_user_id character varying 36
30 ongoing_rebate_auth_user_id character varying 36
31 creation_date timestamp without time zone
32 broker_target_business character varying 3
33 appn_src_id character varying 30
34 create_appn_type character varying 90
35 crd_appn_id character varying 51
36 rwd_lvl character varying 120
37 bt_amt1 numeric 13
38 bt_amt2 numeric 13
39 bt_amt3 numeric 13
40 cci_lvl character varying 60
41 sco_offer_desc character varying 150
42 sec_sent_lvl character varying 60
43 pkg_code character varying 12
44 curr_crd_appn_stat character varying 120
45 curr_stat_resp_dte timestamp without time zone
46 appn_dec_rsn character varying 12
47 campn_code character varying 48
48 is_split character varying 3
49 related_splits character varying 300
50 first_home_owner_grant_fl character varying 3
51 full_reas_code1 character varying 12
52 full_reas_code2 character varying 12
53 full_reas_code3 character varying 12
54 full_reas_code4 character varying 12
55 full_reas_code5 character varying 12
56 full_reas_code6 character varying 12
57 full_reas_code7 character varying 12
58 full_reas_code8 character varying 12
59 full_reas_code9 character varying 12
60 full_reas_code10 character varying 12
61 full_reas_code11 character varying 12
62 full_reas_code12 character varying 12
63 full_reas_code13 character varying 12
64 full_reas_code14 character varying 12
65 full_reas_code15 character varying 12
66 full_reas_code16 character varying 12
67 full_reas_code17 character varying 12
68 full_reas_code18 character varying 12
69 full_reas_code19 character varying 12
70 full_reas_code20 character varying 12
71 finl_reas_code1 character varying 12
72 finl_reas_code2 character varying 12
73 finl_reas_code3 character varying 12
74 finl_reas_code4 character varying 12
75 finl_reas_code5 character varying 12
76 finl_reas_code6 character varying 12
77 finl_reas_code7 character varying 12
78 finl_reas_code8 character varying 12
79 finl_reas_code9 character varying 12
80 finl_reas_code10 character varying 12
81 finl_reas_code11 character varying 12
82 finl_reas_code12 character varying 12
83 finl_reas_code13 character varying 12
84 finl_reas_code14 character varying 12
85 finl_reas_code15 character varying 12
86 finl_reas_code16 character varying 12
87 finl_reas_code17 character varying 12
88 finl_reas_code18 character varying 12
89 finl_reas_code19 character varying 12
90 finl_reas_code20 character varying 12
91 delta_type character varying 3
92 effective_strt_dt timestamp without time zone
93 effective_end_dt timestamp without time zone