as516_hilp_master

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 key_coid integer 32
4 key_prod character varying 9
5 key_acct character varying 27
6 acct_status character varying 9
7 anzsic_code character varying 12
8 sub_prdct_cd character varying 9
9 sba_loan_ind character varying 3
10 orig_br integer 32
11 srvc_br integer 32
12 payout_reason_code character varying 9
13 dt_opened character varying 30
14 dt_closed character varying 30
15 settlement_date character varying 30
16 dt_curr_mat character varying 30
17 basis_pts_1 double precision 53
18 lndg_policy character varying 24
19 loan_pur character varying 9
20 loan_sub_pur character varying 6
21 coll_calc_ltv double precision 53
22 orig_trm integer 32
23 dc_loan_trm integer 32
24 int_repricing_ind integer 32
25 cap_rate_end_date character varying 30
26 nxt_rt_chg_dt character varying 30
27 off_ids_acct character varying 27
28 off_ids_product character varying 9
29 off_ids_rate double precision 53
30 off_status character varying 3
31 cashback_ident character varying 3
32 coll_cd character varying 9
33 secur_status character varying 3
34 secur_pool character varying 9
35 reln_code character varying 9
36 new_conv_ind character varying 3
37 short_name character varying 75
38 cost_center integer 32
39 dt_last_maint character varying 30
40 orig_fee_amt numeric 12
41 orig_ins_amt numeric 12
42 amt_orig_loan numeric 16
43 accred_brkr_cde character varying 21
44 broker_cd character varying 15
45 package_code character varying 12
46 package_date character varying 30
47 owning_account bigint 64
48 assoc_loan_num bigint 64
49 prim_officer character varying 15
50 prop_rht character varying 3
51 sale_off_cd character varying 21
52 secondary_officer character varying 15
53 sb_package_cd character varying 9
54 ln_appl_nbr character varying 36
55 gl_typ_cd character varying 9
56 cons_datein_repo character varying 30
57 cons_repo_status character varying 3
58 dt_stat_set character varying 30
59 convt_to_lend_pol character varying 33
60 convt_to_ln_type character varying 9
61 pyff_txn_cd integer 32
62 off_product character varying 9
63 dt_est_mat character varying 30
64 dt_fnl_mat character varying 30
65 dt_loan_added character varying 30
66 dt_loan_iss character varying 30
67 dt_lst_bill_restr character varying 30
68 dt_nxt_rvw character varying 30
69 dt_of_recst character varying 30
70 dt_orig_mat character varying 30
71 grce_day integer 32
72 lndg_policy_dt character varying 30
73 loan_class character varying 9
74 mshp_cd character varying 3
75 nbr_tm_renew integer 32
76 nbr_tm_to_renew integer 32
77 orig_ltv integer 32
78 pymt_due_dt_1st character varying 30
79 dt_1st_adv character varying 30
80 dt_lst_ext character varying 30
81 dt_prin_pd_to_zr character varying 30
82 loan_prcd_1st_adv numeric 15
83 pyff_typ integer 32
84 second_borrowing_amt numeric 16
85 additional_loan character varying 9
86 charge_typ character varying 3
87 def_charge numeric 12
88 fee_contrib numeric 12
89 fin_stat character varying 3
90 fin_stat_dt_set character varying 30
91 first_adv_amt numeric 16
92 fixed_fee_exempt character varying 3
93 fund_utilised character varying 9
94 gteed_rt_ind character varying 3
95 int_only_pd integer 32
96 internet_cshbk_ind character varying 3
97 loan_link character varying 9
98 loan_purp_state character varying 9
99 off_ids_accr_base integer 32
100 off_ltr_flag character varying 3
101 orig_lending_pol character varying 33
102 sml_bus_secur_cd character varying 9
103 stamp_duty_fincd numeric 12
104 state_of_jursdctn character varying 9
105 chg_off_prin numeric 15
106 chg_off_int numeric 13
107 clms_borr_id character varying 150
108 clms_grp_id character varying 150
109 acct_cqr_cd character varying 6
110 acct_sr_cd character varying 3
111 borr_cqr_cd character varying 6
112 borr_sr_cd character varying 3
113 grp_cqr_cd character varying 6
114 grp_sr_cd character varying 3
115 risk_model_cd character varying 6
116 dt_of_chg character varying 30
117 anzsic_cd character varying 12
118 review_dt character varying 30
119 net_sales numeric 18
120 q_19 character varying 3
121 q_20 character varying 3
122 q_21 character varying 3
123 q_22 character varying 3
124 crit_tot_score numeric 24
125 crit_tot_overall character varying 30
126 override_flag character varying 6
127 override_rsn character varying 300
128 override_srce character varying 300
129 calc_score character varying 6
130 actual_score numeric 24
131 sicr character varying 9
132 sys_code character varying 12
133 prev_cr_act_desc character varying 120
134 prev_cr_act_cdr_ldr character varying 30
135 q_24 character varying 30
136 q_25 character varying 30
137 q_26 character varying 6
138 q_27 character varying 6
139 q_28 character varying 6
140 trail_commission_ovrd_rate numeric 8
141 trail_commission_ovrd_date date
142 clms_acct_num integer 32
143 rpm_quote_num integer 32
144 promotion_code character varying 18
145 division_code character varying 15
146 balloon_amount numeric 15
147 bill_profile character varying 3
148 var_io_start_dt date
149 var_io_exp_dt date
150 var_io_exp_notc_dt date
151 grntee_notnl_expiry_flag character varying 3
152 grntee_limit numeric 15
153 payment_pause_flag character varying 3
154 watch_list_flag character varying 3
155 delta_type character varying 3
156 effective_strt_dt timestamp without time zone
157 effective_end_dt timestamp without time zone