obp24_hst_cz_sc_or_expr_resp_applicant

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 master_key character varying 150
2 submission_id character varying 60
3 application_id character varying 60
4 applicant_id character varying 60
5 decision character varying 30
6 ext_cal_rcd_i1 character varying 6
7 ext_cal_rcd_i2 character varying 6
8 ext_cal_rcd_i3 character varying 6
9 ext_cal_rdes_i1 character varying 90
10 ext_cal_rdes_i2 character varying 90
11 ext_cal_rdes_i3 character varying 90
12 cs_rc1_sys_ret_code character varying 30
13 cs_rc1_sys_ret_code_desc character varying 1500
14 cs_rc2_sys_ret_code character varying 30
15 cs_rc2_sys_ret_code_desc character varying 1500
16 cs_rc3_sys_ret_code character varying 30
17 cs_rc3_sys_ret_code_desc character varying 1500
18 ba_baycorp_time_curr_addr numeric 20
19 ba_baycorp_time_curr_emp numeric 20
20 ba_rel_risk_factor numeric 20
21 ba_rel_risk_index numeric 20
22 ba_risk_odds numeric 20
23 ba_scorecard_name character varying 300
24 ba_scorecard_name_ind character varying 300
25 ba_spare_101 numeric 20
26 ba_vc_addr_ind character varying 3
27 ba_vc_drv_lic_ind character varying 3
28 ba_vc_er_ind_curr character varying 3
29 ba_vc_er_ind_prev character varying 3
30 ba_vc_res_ind character varying 6
31 ba_num_non_util_enq_l6m numeric 20
32 ba_num_of_defs numeric 20
33 ba_bureau_drv_lic character varying 30
34 ba_bureau_ref character varying 60
35 ba_bureau_family_name character varying 300
36 ba_bureau_given_name character varying 300
37 ba_bureau_oth_given_name character varying 300
38 ba_bureau_dob character varying 30
39 ba_bureau_gender character varying 3
40 ba_bureau_addr_unit_no character varying 15
41 ba_bureau_addr_st_no character varying 24
42 ba_bureau_addr_st_name character varying 300
43 ba_bureau_addr_st_type character varying 12
44 ba_bureau_addr_suburb character varying 150
45 ba_bureau_addr_state character varying 9
46 ba_bureau_addr_post_code character varying 12
47 ba_bureau_employer character varying 300
48 ba_age_of_credit_file numeric 20
49 ba_cons_enq_last_1_mon numeric 20
50 ba_cons_enq_last_3_mon numeric 20
51 ba_cons_enq_last_6_mon numeric 20
52 ba_com_enq_last_1_mon numeric 20
53 ba_comm_enq_last_3_mon numeric 20
54 ba_com_enq_last_6_mon numeric 20
55 ba_cons_credit_enq_name_1 character varying 300
56 ba_cons_credit_enq_date_1 timestamp without time zone
57 ba_cons_credit_enq_name_2 character varying 300
58 ba_cons_credit_enq_date_2 timestamp without time zone
59 ba_cons_credit_enq_name_3 character varying 300
60 ba_cons_credit_enq_date_3 timestamp without time zone
61 ba_prim_match_type character varying 30
62 ba_spare_s1 character varying 90
63 ba_spare_s2 character varying 90
64 ba_spare_s3 character varying 90
65 ba_spare_s4 character varying 90
66 ba_spare_s5 character varying 90
67 ba_spare_s6 character varying 90
68 ba_spare_s7 character varying 90
69 ba_spare_s8 character varying 90
70 ba_spare_s9 character varying 90
71 ba_spare_s10 character varying 90
72 ba_spare_f1 numeric 20
73 ba_spare_f2 numeric 20
74 ba_spare_f3 numeric 20
75 ba_spare_f4 numeric 20
76 ba_spare_f5 numeric 20
77 ba_spare_f6 numeric 20
78 ba_spare_f7 numeric 20
79 ba_spare_f8 numeric 20
80 ba_spare_f9 numeric 20
81 ba_spare_f10 numeric 20
82 ads_dec_text character varying 60
83 ads_dec_reason_code character varying 30
84 ads_dec_category character varying 60
85 ads_sort_res_cod_tab_i1 character varying 30
86 ads_sort_res_cod_tab_i2 character varying 30
87 ads_sort_res_cod_tab_i3 character varying 30
88 ads_sort_res_cod_tab_i4 character varying 30
89 ads_sort_res_cod_tab_i5 character varying 30
90 ads_sort_res_cod_tab_i6 character varying 30
91 ads_sort_res_cod_tab_i7 character varying 30
92 ads_sort_res_cod_tab_i8 character varying 30
93 ads_sort_res_cod_tab_i9 character varying 30
94 ads_sort_res_cod_tab_i10 character varying 30
95 ads_sort_res_cod_tab_i11 character varying 30
96 ads_sort_res_cod_tab_i12 character varying 30
97 ads_sort_res_cod_tab_i13 character varying 30
98 ads_sort_res_cod_tab_i14 character varying 30
99 ads_sort_res_cod_tab_i15 character varying 30
100 ads_sort_res_cod_tab_i16 character varying 30
101 ads_sort_res_cod_tab_i17 character varying 30
102 ads_sort_res_cod_tab_i18 character varying 30
103 ads_sort_res_cod_tab_i19 character varying 30
104 ads_sort_res_cod_tab_i20 character varying 30
105 ads_sort_res_cod_tab_i21 character varying 30
106 ads_sort_res_cod_tab_i22 character varying 30
107 ads_sort_res_cod_tab_i23 character varying 30
108 ads_sort_res_cod_tab_i24 character varying 30
109 ads_sort_res_cod_tab_i25 character varying 30
110 ads_sort_dec_tab_i1 character varying 150
111 ads_sort_dec_tab_i2 character varying 150
112 ads_sort_dec_tab_i3 character varying 150
113 ads_sort_dec_tab_i4 character varying 150
114 ads_sort_dec_tab_i5 character varying 150
115 ads_sort_dec_tab_i6 character varying 150
116 ads_sort_dec_tab_i7 character varying 150
117 ads_sort_dec_tab_i8 character varying 150
118 ads_sort_dec_tab_i9 character varying 150
119 ads_sort_dec_tab_i10 character varying 150
120 ads_sort_dec_tab_i11 character varying 150
121 ads_sort_dec_tab_i12 character varying 150
122 ads_sort_dec_tab_i13 character varying 150
123 ads_sort_dec_tab_i14 character varying 150
124 ads_sort_dec_tab_i15 character varying 150
125 ads_sort_dec_tab_i16 character varying 150
126 ads_sort_dec_tab_i17 character varying 150
127 ads_sort_dec_tab_i18 character varying 150
128 ads_sort_dec_tab_i19 character varying 150
129 ads_sort_dec_tab_i20 character varying 150
130 ads_sort_dec_tab_i21 character varying 150
131 ads_sort_dec_tab_i22 character varying 150
132 ads_sort_dec_tab_i23 character varying 150
133 ads_sort_dec_tab_i24 character varying 150
134 ads_sort_dec_tab_i25 character varying 150
135 ars_score numeric 20
136 ars_score_index numeric 20
137 arg_risk_grade numeric 20
138 bsfct_fraud_bur_ser character varying 150
139 bscet_first_bur character varying 24
140 bscet_first_bur_ser character varying 150
141 bscet_second_bur character varying 24
142 bscet_second_bur_ser character varying 150
143 bscet_call_type character varying 3
144 bscet_pce_cache_days numeric 20
145 fadc_dec_text character varying 60
146 fadc_dec_reason_code character varying 30
147 fadc_dec_category character varying 60
148 fadc_sort_res_cod_tab_i1 character varying 30
149 fadc_sort_res_cod_tab_i2 character varying 30
150 fadc_sort_res_cod_tab_i3 character varying 30
151 fadc_sort_res_cod_tab_i4 character varying 30
152 fadc_sort_res_cod_tab_i5 character varying 30
153 fadc_sort_res_cod_tab_i6 character varying 30
154 fadc_sort_res_cod_tab_i7 character varying 30
155 fadc_sort_res_cod_tab_i8 character varying 30
156 fadc_sort_res_cod_tab_i9 character varying 30
157 fadc_sort_res_cod_tab_i10 character varying 30
158 fadc_sort_res_cod_tab_i11 character varying 30
159 fadc_sort_res_cod_tab_i12 character varying 30
160 fadc_sort_res_cod_tab_i13 character varying 30
161 fadc_sort_res_cod_tab_i14 character varying 30
162 fadc_sort_res_cod_tab_i15 character varying 30
163 fadc_sort_res_cod_tab_i16 character varying 30
164 fadc_sort_res_cod_tab_i17 character varying 30
165 fadc_sort_res_cod_tab_i18 character varying 30
166 fadc_sort_res_cod_tab_i19 character varying 30
167 fadc_sort_res_cod_tab_i20 character varying 30
168 fadc_sort_res_cod_tab_i21 character varying 30
169 fadc_sort_res_cod_tab_i22 character varying 30
170 fadc_sort_res_cod_tab_i23 character varying 30
171 fadc_sort_res_cod_tab_i24 character varying 30
172 fadc_sort_res_cod_tab_i25 character varying 30
173 fadc_sort_dec_tab_i1 character varying 150
174 fadc_sort_dec_tab_i2 character varying 150
175 fadc_sort_dec_tab_i3 character varying 150
176 fadc_sort_dec_tab_i4 character varying 150
177 fadc_sort_dec_tab_i5 character varying 150
178 fadc_sort_dec_tab_i6 character varying 150
179 fadc_sort_dec_tab_i7 character varying 150
180 fadc_sort_dec_tab_i8 character varying 150
181 fadc_sort_dec_tab_i9 character varying 150
182 fadc_sort_dec_tab_i10 character varying 150
183 fadc_sort_dec_tab_i11 character varying 150
184 fadc_sort_dec_tab_i12 character varying 150
185 fadc_sort_dec_tab_i13 character varying 150
186 fadc_sort_dec_tab_i14 character varying 150
187 fadc_sort_dec_tab_i15 character varying 150
188 fadc_sort_dec_tab_i16 character varying 150
189 fadc_sort_dec_tab_i17 character varying 150
190 fadc_sort_dec_tab_i18 character varying 150
191 fadc_sort_dec_tab_i19 character varying 150
192 fadc_sort_dec_tab_i20 character varying 150
193 fadc_sort_dec_tab_i21 character varying 150
194 fadc_sort_dec_tab_i22 character varying 150
195 fadc_sort_dec_tab_i23 character varying 150
196 fadc_sort_dec_tab_i24 character varying 150
197 fadc_sort_dec_tab_i25 character varying 150
198 fars_score numeric 20
199 fars_score_index numeric 20
200 farg_risk_grade numeric 20
201 fin_emp_ver_flag character varying 3
202 crdt_repay_hist_ver_flag character varying 3
203 bor_cont_pur_ver_flg character varying 3
204 gen_sav_ver_flg character varying 3
205 asst_re_ver_flg character varying 3
206 asst_oth_ver_flg character varying 3
207 rent_exp_ver_flg character varying 3
208 cr_ver_flg character varying 3
209 res_addr_ver_flg character varying 3
210 oth1_ver_flg character varying 3
211 oth2_ver_flg character varying 3
212 oth3_ver_flg character varying 3
213 ctr_cap_to_repay character varying 9
214 ctr_tot_avl_inc numeric 20
215 ctr_tot_exp_incl_pl_exp numeric 20
216 ctr_tot_exp_excl_pl_exp numeric 20
217 ctr_disc_inc numeric 20
218 ctr_gross_salary numeric 20
219 ctr_oth_net_inc numeric 20
220 ctr_inv_inc numeric 20
221 ctr_business_inc numeric 20
222 ctr_business_salary numeric 20
223 ctr_tax_with_held numeric 20
224 ctr_neg_gearing_ben numeric 20
225 ctr_credit_card_exp numeric 20
226 ctr_margin_lending_exp numeric 20
227 ctr_regular_exp numeric 20
228 ctr_tot_dec_living_exp numeric 20
229 ctr_tot_hem_living_exp numeric 20
230 ctr_living_exp numeric 20
231 ctr_exst_ln_com_aggr numeric 20
232 ctr_pro_ln_com_aggr numeric 20
233 ctr_repay_amount numeric 20
234 ctr_sen_repay_amount numeric 20
235 cvss_tot_core_inc numeric 20
236 cvss_tot_sec_inc numeric 20
237 cvss_tot_sec_inc_pct_aggr_inc numeric 20
238 pl_cost_goods_sold numeric 20
239 pl_gross_prof_trading numeric 20
240 pl_net_prof_before_tax numeric 20
241 pl_abn_itm_adjustment numeric 20
242 pl_bus_cash_operations numeric 20
243 pl_comp_taxation_exp numeric 20
244 dist_avl_inc_sal_to_own_bybus numeric 20
245 dist_avl_inc_rb_cashflow_dist numeric 20
246 bs_tot_curr_assets numeric 20
247 bs_tot_non_curr_assets numeric 20
248 bs_tot_curr_liab numeric 20
249 bs_tot_non_curr_liab numeric 20
250 bs_tot_prop_sh_funds numeric 20
251 bs_net_worth_deficiency numeric 20
252 bs_gross_prof_margin_pcnt numeric 20
253 bs_net_prof_sales_pcnt numeric 20
254 bs_work_capital_pcnt numeric 20
255 bs_curr_ratio_xto1 numeric 20
256 bs_quick_asst_ratio_at_xto1 numeric 20
257 bs_cap_adeq_ratio_pcnt numeric 20
258 bs_int_coverage_times numeric 20
259 bs_stock_turnover_days numeric 20
260 bs_debt_or_coll_period_days numeric 20
261 bs_crdt_or_pay_period_days numeric 20
262 bs_cash_after_operations numeric 20
263 bs_csh_aft_op_co_sur_var_pcnt numeric 20
264 br_profits_taxed numeric 20
265 br_business_salary numeric 20
266 br_franking_credits numeric 20
267 br_add_backs numeric 20
268 spare_s1 character varying 90
269 spare_s2 character varying 90
270 spare_s3 character varying 90
271 spare_s4 character varying 90
272 spare_s5 character varying 90
273 spare_s6 character varying 90
274 spare_s7 character varying 90
275 spare_s8 character varying 90
276 spare_s9 character varying 90
277 spare_s10 character varying 90
278 spare_s11 character varying 90
279 spare_s12 character varying 90
280 spare_s13 character varying 90
281 spare_s14 character varying 90
282 spare_s15 character varying 90
283 spare_s16 character varying 90
284 spare_s17 character varying 90
285 spare_s18 character varying 90
286 spare_s19 character varying 90
287 spare_s20 character varying 90
288 spare_f1 numeric 20
289 spare_f2 numeric 20
290 spare_f3 numeric 20
291 spare_f4 numeric 20
292 spare_f5 numeric 20
293 spare_f6 numeric 20
294 spare_f7 numeric 20
295 spare_f8 numeric 20
296 spare_f9 numeric 20
297 spare_f10 numeric 20
298 spare_f11 numeric 20
299 spare_f12 numeric 20
300 spare_f13 numeric 20
301 spare_f14 numeric 20
302 spare_f15 numeric 20
303 spare_f16 numeric 20
304 spare_f17 numeric 20
305 spare_f18 numeric 20
306 spare_f19 numeric 20
307 spare_f20 numeric 20
308 cdc_source_system_code character varying 12
309 cdc_record_type character varying 48
310 cdc_commit_timestamp timestamp without time zone
311 cdc_extract_timestamp timestamp without time zone
312 ba_new_to_bur character varying 60
313 ba_age_of_file numeric 20
314 ba_age_of_app_bur numeric 20
315 ba_adv_flg character varying 60
316 ba_nmbr_crt_wrts numeric 20
317 ba_nmbr_disql_dir numeric 20
318 ba_nmbr_cons_unpd numeric 20
319 ba_nmbr_comm_unpd numeric 20
320 ba_nmbr_cons_util numeric 20
321 ba_nmbr_comm_util numeric 20
322 ba_nmbr_inslv numeric 20
323 ba_nmbr_cons_tel_util numeric 20
324 ba_nmbr_comm_tel_util numeric 20
325 ba_mth_lst_cons numeric 20
326 ba_mth_lst_comm numeric 20
327 ba_rel_risk_index_cr numeric 20