qrm_cm_master

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_no numeric 28
2 accrued_int numeric 19
3 acct_status character varying 15
4 allocated_cash_col_value numeric 19
5 amrt_type_cd character varying 60
6 anzsic_apra_category character varying 150
7 anzsic_code character varying 12
8 anzsic_level_1 character varying 300
9 anzsic_level_2 character varying 765
10 anzsic_level_3 character varying 765
11 anzsic_level_4 character varying 765
12 anzsic_rba_category character varying 300
13 anzsic_sml_finance_category character varying 150
14 apra_category_code_112 numeric 1
15 apra_class_code_112 numeric 1
16 apra_class_descr_112 character varying 300
17 apra_class_descr_113 character varying 300
18 apra_counterparty_type character varying 300
19 apra_off_bal_trans_type character varying 300
20 apra_off_bal_trans_type_sort character varying 18
21 apra_sector_330 character varying 150
22 apra_sub_category_code_112 numeric 1
23 avg_par_bal numeric 16
24 avl_cashback numeric 19
25 balance_sheet_ind character varying 3
26 bank_guarantee_ind character varying 3
27 basis character varying 48
28 basis_floating character varying 48
29 basis_swap_pay_margin numeric 8
30 basis_swap_rec_margin numeric 8
31 broker_originated character varying 3
32 calc_advance_amt numeric 9
33 calc_avail_bal numeric 19
34 cancellable character varying 33
35 ccf numeric 5
36 cea_off_bal numeric 19
37 certain_drawdown character varying 60
38 clms_group_name character varying 300
39 clms_group_no character varying 123
40 clms_next_review_date timestamp without time zone
41 clms_prod_div numeric 2
42 clms_prod_div_desc character varying 300
43 coll_group_id_all_assets numeric 28
44 coll_group_id_efc numeric 28
45 coll_group_id_erm numeric 28
46 coll_mrkt_val_indexed_erm numeric 19
47 company character varying 30
48 compounding_frequency character varying 90
49 counterparty_abn numeric 16
50 counterparty_abs_region character varying 765
51 counterparty_acn numeric 16
52 counterparty_bch_code character varying 15
53 counterparty_bch_desc character varying 150
54 counterparty_bdm numeric 8
55 counterparty_bdm_desc character varying 150
56 counterparty_country_cd character varying 18
57 counterparty_country_desc character varying 765
58 counterparty_gcis_cust_no numeric 16
59 counterparty_locc_citizenship character varying 30
60 counterparty_locc_of_org character varying 30
61 counterparty_locc_of_risk character varying 30
62 counterparty_name character varying 765
63 counterparty_pcode character varying 18
64 counterparty_resident_flag character varying 15
65 counterparty_srce_cust_no numeric 16
66 counterparty_state character varying 18
67 counterparty_type character varying 765
68 counterparty_ultimate_risk_cmne character varying 90
69 counterparty_ultimate_risk_name character varying 180
70 cr_approach character varying 6
71 cr_ccf_airb numeric 16
72 cr_ccf_firb numeric 16
73 cr_correlation_airb numeric 16
74 cr_correlation_firb numeric 16
75 cr_ead_airb numeric 19
76 cr_ead_firb numeric 19
77 cr_ead_ecap numeric 19
78 cr_effectivematurity numeric 16
79 cr_el_airb numeric 19
80 cr_el_firb numeric 19
81 cr_el_ecap numeric 19
82 cr_firmsize numeric 16
83 cr_lgd_firb numeric 14
84 cr_lgd_pit numeric 14
85 cr_lgd_score character varying 15
86 cr_lgd_score_cp character varying 15
87 cr_lgd_ttc numeric 14
88 cr_pd_pit numeric 14
89 cr_pd_score character varying 15
90 cr_pd_score_cp character varying 15
91 cr_pd_ttc numeric 14
92 cr_portfolio character varying 300
93 cr_portfolio_cp character varying 150
94 cr_risk_weight_airb numeric 8
95 cr_risk_weight_firb numeric 8
96 cr_risk_weight_ecap numeric 8
97 cr_rwa_off_bal_firb numeric 19
98 cr_rwa_on_bal_firb numeric 19
99 cr_rwa_total_airb numeric 19
100 cr_rwa_total_firb numeric 19
101 cr_rwa_total_ecap numeric 19
102 cr_ul_airb numeric 19
103 cr_ul_firb numeric 19
104 cr_ul_ecap numeric 19
105 cur_net_rate numeric 15
106 cur_payment numeric 20
107 date_in_excess timestamp without time zone
108 deal_date timestamp without time zone
109 deal_no numeric 25
110 deposit_offset_account numeric 25
111 deposit_offset_balance numeric 19
112 deposit_offset_rate numeric 9
113 drawn_status character varying 60
114 drs_group_id numeric 20
115 drs_group_name character varying 600
116 dr_cr_flag character varying 6
117 ead_on_bal numeric 19
118 erm_flag character varying 3
119 exposure numeric 19
120 face_amt numeric 19
121 face_value numeric 19
122 fixcoupswp_pymt numeric 19
123 fixcoupswp_rate numeric 19
124 fixed_rate numeric 8
125 flt_rate numeric 8
126 forward_starting character varying 27
127 gtee_drawn numeric 19
128 gtee_limit numeric 19
129 held_to_maturity_flag character varying 3
130 id_number character varying 84
131 ifrs_cash_flow_amt numeric 19
132 ifrs_cash_flow_int character varying 30
133 ifrs_est_rec_term character varying 30
134 ifrs_orig_int_rate character varying 36
135 impaired_end_date timestamp without time zone
136 impaired_flag_drs character varying 3
137 impaired_start_date timestamp without time zone
138 impdpastdue_flag character varying 3
139 impdpastdue_flag_orig character varying 3
140 inba numeric 19
141 interest_rate_classification character varying 15
142 int_rate_add_on numeric 15
143 int_rate_base numeric 15
144 int_rate_cur numeric 15
145 int_rate_margin numeric 15
146 int_rate_penalty_margin numeric 8
147 int_rate_type character varying 120
148 issue_date timestamp without time zone
149 issue_term numeric 5
150 issue_term_mult character varying 3
151 last_reprice_date timestamp without time zone
152 limit_calculated numeric 19
153 limit_raw numeric 19
154 loan_bdm character varying 18
155 loan_bdm_desc character varying 300
156 loan_branch character varying 15
157 loan_branch_desc character varying 300
158 loan_purp character varying 18
159 loan_sub_purp character varying 30
160 low_doc_flag character varying 3
161 lvr_erm numeric 14
162 lvr_erm_band character varying 60
163 lvr_est_group numeric 14
164 lvr_original numeric 9
165 lvr_target numeric 7
166 margin numeric 14
167 market_off_bal_flag character varying 3
168 master_limit_agreement character varying 300
169 master_limit_no numeric 16
170 mat_date timestamp without time zone
171 mat_date_adjusted numeric 3
172 mortg_ins_cmpy character varying 150
173 mortg_ins_indicator character varying 3
174 mtm numeric 19
175 net_credit_exposure numeric 19
176 next_payment_date timestamp without time zone
177 next_payment_date_floating timestamp without time zone
178 next_reprice_date timestamp without time zone
179 next_reprice_date_floating timestamp without time zone
180 non_core_exclusion character varying 3
181 non_core_flag character varying 3
182 od_doc_type character varying 15
183 od_secured_flag character varying 3
184 off_bal_llkely_to_draw_factor numeric 15
185 off_bal_principal_amt numeric 19
186 opics_ctype character varying 6
187 oracle_gl_acct_accrued_int numeric 10
188 oracle_gl_acct_inba numeric 10
189 oracle_gl_acct_principal numeric 10
190 oracle_gl_bus_unit character varying 30
191 oracle_gl_cost_centre numeric 10
192 oracle_gl_cost_centre_channel character varying 450
193 oracle_gl_cost_centre_egm character varying 765
194 oracle_gl_cost_centre_name character varying 765
195 oracle_gl_cost_centre_region character varying 765
196 oracle_gl_cost_centre_state character varying 765
197 oracle_gl_product character varying 30
198 org_term numeric 5
199 org_term_mult character varying 3
200 org_unit_id character varying 180
201 original_loan_amount numeric 19
202 original_maturity numeric 5
203 original_table character varying 60
204 origination_date timestamp without time zone
205 orig_days_to_maturity numeric 22
206 overdue_review_flag character varying 3
207 past_due_amt numeric 19
208 past_due_category character varying 60
209 past_due_category_sort integer 32
210 past_due_days numeric 28
211 past_due_days_orig numeric 28
212 payment_frequency numeric 5
213 payment_frequency_descr character varying 90
214 payment_frequency_floating character varying 36
215 payment_frequency_floating_descr character varying 90
216 pay_spread numeric 8
217 portfolio_date timestamp without time zone
218 product_code character varying 48
219 product_code_1 character varying 48
220 product_code_2 character varying 18
221 product_code_3 character varying 15
222 product_code_4 character varying 15
223 product_code_5 character varying 15
224 product_descr character varying 300
225 product_reporting_group character varying 75
226 property_rights character varying 75
227 provision_amt numeric 19
228 provision_amt_adj numeric 19
229 prov_bookbal_ratio numeric 5
230 psoft_gl_account_id numeric 14
231 psoft_gl_account_id_acc_int numeric 14
232 psoft_gl_account_inba numeric 14
233 psoft_gl_bank_code character varying 30
234 psoft_gl_dept_id character varying 30
235 psoft_gl_prod_code character varying 45
236 purpose_class_code character varying 18
237 qrm_account character varying 225
238 qrm_account_cm character varying 225
239 qrm_product_cm character varying 225
240 rate_index character varying 150
241 rating_cqr_composite character varying 6
242 rating_cqr_counterparty character varying 6
243 rating_cqr_loan character varying 6
244 rating_date_composite timestamp without time zone
245 rating_date_counterparty timestamp without time zone
246 rating_date_loan timestamp without time zone
247 rating_external character varying 6
248 rating_external_fitch character varying 30
249 rating_external_lt character varying 6
250 rating_external_moodys character varying 30
251 rating_external_sp character varying 30
252 rating_external_st character varying 6
253 rating_model numeric 2
254 rating_model_descr character varying 150
255 rating_sr_composite character varying 6
256 rating_sr_counterparty character varying 6
257 rating_sr_loan character varying 6
258 rec_intenddate timestamp without time zone
259 rec_spread numeric 8
260 redraw_available character varying 3
261 reprice_freq numeric 5
262 reprice_freq_mult character varying 3
263 residual_amount numeric 19
264 restructured_flag character varying 3
265 risk_weight_112 numeric 5
266 rv_cmne character varying 30
267 rwa_off_bal_112 numeric 19
268 rwa_on_bal_112 numeric 19
269 secondary_officer character varying 60
270 securitise_id character varying 150
271 secur_loans_capital_relief character varying 3
272 secur_pool character varying 18
273 secur_reportable character varying 15
274 secur_status character varying 6
275 settledate timestamp without time zone
276 short_name character varying 765
277 source_currency character varying 15
278 source_system character varying 12
279 tbe numeric 19
280 tce numeric 19
281 tce_group_id integer 32
282 tenor character varying 30
283 tp_addon_calculation numeric 19
284 tp_addon_rate numeric 8
285 tp_base_rate numeric 8
286 tp_basis_calculation numeric 19
287 tp_basis_cost numeric 8
288 tp_curve character varying 150
289 tp_funding_index character varying 150
290 tp_irr_calculation numeric 19
291 tp_model character varying 150
292 tp_start_point character varying 150
293 tp_status character varying 150
294 tp_trf_sprd_calc numeric 19
295 tp_wgtdavg_base_rate numeric 8
296 trading_book_flag character varying 3
297 transfer_rate numeric 22
298 transfer_spread numeric 8
299 watchlist_creditrec_ind character varying 15
300 yield_curve character varying 150
301 composite_counterparty_bdm numeric 8
302 composite_counterparty_bdm_desc character varying 150
303 low_doc_flag_origination character varying 3
304 composite_next_review_date timestamp without time zone
305 provision_amt_collective numeric 19
306 provision_amt_ifrs numeric 19
307 hardship_date_outcome_advised timestamp without time zone
308 hardship_date_request_received timestamp without time zone
309 hardship_duration_of_assistance character varying 150
310 hardship_outcome character varying 150
311 hardship_reason_code character varying 150
312 hardship_regulated_flag character varying 150
313 hardship_state character varying 150
314 expected_loss numeric 19
315 accredited_broker_code character varying 27
316 broker_code character varying 27
317 next_rate_review_date timestamp without time zone
318 net_sales numeric 15
319 sunloans_app_no numeric 9
320 write_off_code character varying 6
321 write_off_date timestamp without time zone
322 write_off_amt numeric 19
323 repossession_date timestamp without time zone
324 charge_off_amt numeric 19
325 charge_off_date timestamp without time zone
326 lgd_weight numeric 10
327 internal_dt_lgd numeric 10
328 internal_lgd_model character varying 75
329 internal_pd_model character varying 75
330 internal_ttc_pd numeric 10
331 lgd_mult1_value character varying 75
332 ttcpd_risk_grade numeric 2
333 ttcpd_total_score numeric 8
334 ttcpd_v1_score numeric 8
335 ttcpd_v1_value numeric 9
336 ttcpd_v10_score numeric 8
337 ttcpd_v10_value numeric 9
338 ttcpd_v11_score numeric 8
339 ttcpd_v11_value numeric 9
340 ttcpd_v12_score numeric 8
341 ttcpd_v12_value numeric 9
342 ttcpd_v13_score numeric 8
343 ttcpd_v13_value numeric 9
344 ttcpd_v14_score numeric 8
345 ttcpd_v14_value numeric 9
346 ttcpd_v15_score numeric 8
347 ttcpd_v15_value numeric 9
348 ttcpd_v16_score numeric 8
349 ttcpd_v16_value character varying 75
350 ttcpd_v17_score numeric 8
351 ttcpd_v17_value character varying 75
352 ttcpd_v18_score numeric 8
353 ttcpd_v18_value character varying 75
354 ttcpd_v19_score numeric 8
355 ttcpd_v19_value character varying 75
356 ttcpd_v2_score numeric 8
357 ttcpd_v2_value numeric 8
358 ttcpd_v20_score numeric 8
359 ttcpd_v20_value character varying 75
360 ttcpd_v21_score numeric 8
361 ttcpd_v21_value character varying 75
362 ttcpd_v22_score numeric 8
363 ttcpd_v22_value character varying 75
364 ttcpd_v23_score numeric 8
365 ttcpd_v23_value character varying 75
366 ttcpd_v24_score numeric 8
367 ttcpd_v24_value character varying 75
368 ttcpd_v25_score numeric 8
369 ttcpd_v25_value character varying 75
370 ttcpd_v26_score numeric 8
371 ttcpd_v26_value character varying 75
372 ttcpd_v27_score numeric 8
373 ttcpd_v27_value character varying 75
374 ttcpd_v28_score numeric 8
375 ttcpd_v28_value character varying 75
376 ttcpd_v29_score numeric 8
377 ttcpd_v29_value character varying 75
378 ttcpd_v3_score numeric 8
379 ttcpd_v3_value numeric 9
380 ttcpd_v30_score numeric 8
381 ttcpd_v30_value numeric 9
382 ttcpd_v4_score numeric 8
383 ttcpd_v4_value numeric 11
384 ttcpd_v5_score numeric 8
385 ttcpd_v5_value numeric 9
386 ttcpd_v6_score numeric 8
387 ttcpd_v6_value numeric 10
388 ttcpd_v7_score numeric 8
389 ttcpd_v7_value numeric 9
390 ttcpd_v8_score numeric 8
391 ttcpd_v8_value numeric 9
392 ttcpd_v9_score numeric 8
393 ttcpd_v9_value numeric 9
394 lgd_powo_total_score numeric 8
395 lgd_powo_grade numeric 2
396 lgd_dtpowo numeric 10
397 lgd_dtlgw numeric 10
398 lgd_dtlgc numeric 10
399 lgd_v1_score numeric 8
400 lgd_v1_value numeric 9
401 lgd_v10_score numeric 8
402 lgd_v10_value numeric 9
403 lgd_v11_score numeric 8
404 lgd_v11_value numeric 9
405 lgd_v12_score numeric 8
406 lgd_v12_value numeric 9
407 lgd_v13_score numeric 8
408 lgd_v13_value numeric 9
409 lgd_v14_score numeric 8
410 lgd_v14_value numeric 9
411 lgd_v15_score numeric 8
412 lgd_v15_value numeric 9
413 lgd_v16_score numeric 8
414 lgd_v16_value character varying 75
415 lgd_v17_score numeric 8
416 lgd_v17_value character varying 75
417 lgd_v18_score numeric 8
418 lgd_v18_value character varying 75
419 lgd_v19_score numeric 8
420 lgd_v19_value character varying 75
421 lgd_v2_score numeric 8
422 lgd_v2_value numeric 8
423 lgd_v20_score numeric 8
424 lgd_v20_value character varying 75
425 lgd_v21_score numeric 8
426 lgd_v21_value character varying 75
427 lgd_v22_score numeric 8
428 lgd_v22_value character varying 75
429 lgd_v23_score numeric 8
430 lgd_v23_value character varying 75
431 lgd_v24_score numeric 8
432 lgd_v24_value character varying 75
433 lgd_v25_score numeric 8
434 lgd_v25_value character varying 75
435 lgd_v26_score numeric 8
436 lgd_v26_value character varying 75
437 lgd_v27_score numeric 8
438 lgd_v27_value character varying 75
439 lgd_v28_score numeric 8
440 lgd_v28_value character varying 75
441 lgd_v29_score numeric 8
442 lgd_v29_value character varying 75
443 lgd_v3_score numeric 8
444 lgd_v3_value numeric 9
445 lgd_v30_score numeric 8
446 lgd_v30_value numeric 9
447 lgd_v4_score numeric 8
448 lgd_v4_value numeric 9
449 lgd_v5_score numeric 8
450 lgd_v5_value numeric 9
451 lgd_v6_score numeric 8
452 lgd_v6_value numeric 9
453 lgd_v7_score numeric 8
454 lgd_v7_value numeric 9
455 lgd_v8_score numeric 8
456 lgd_v8_value numeric 9
457 lgd_v9_score numeric 8
458 lgd_v9_value numeric 9
459 mr_rwa_total_ecap numeric 19
460 irr_rwa_total_ecap numeric 19
461 or_rwa_total_ecap numeric 19
462 br_rwa_total_ecap numeric 19
463 div_rwa_total_ecap numeric 19
464 agg_rwa_total_ecap numeric 19
465 mr_capital_ecap numeric 19
466 irr_capital_ecap numeric 19
467 or_capital_ecap numeric 19
468 br_capital_ecap numeric 19
469 div_capital_ecap numeric 19
470 agg_capital_ecap numeric 19
471 trgt_cap_adequcy numeric 6
472 cap_adj_rate numeric 6
473 cap_adj_amt_ecap numeric 19
474 br_rwa_ama numeric 19
475 irr_rwa_ama numeric 19
476 mr_rwa_ama numeric 19
477 or_rwa_ama numeric 19
478 mr_rwa_std numeric 19
479 or_rwa_std numeric 19
480 cr_capital_airb numeric 19
481 cr_cea_off_bal_firb numeric 19
482 composite_ratings_model numeric 2
483 composite_ratings_model_desc character varying 30
484 loan_bal_to_orig_loan_amt numeric 20
485 month_on_book numeric 5
486 num_borr numeric 3
487 ttcpd_adj_score numeric 8
488 lgd_category character varying 240
489 securitisation_risk_sub_category character varying 300
490 cr_el_pm numeric 19
491 tp_liquidity_rate numeric 8
492 tp_liquidity_runoff_percent numeric 8
493 slotting_rating numeric 1
494 cr_ead_onbal_firb numeric 19
495 cr_ead_offbal_firb numeric 19
496 cap_adj_amount double precision 53
497 tp_liquidity_calculation numeric 19
498 tp_liquidity_runoff_category character varying 300
499 tp_funding_centrealloc_rate numeric 12
500 tp_funding_centrealloc_calc numeric 12
501 collateral_primary_abs_region character varying 765
502 collateral_primary_category character varying 150
503 collateral_primary_pcode character varying 30
504 collateral_primary_state character varying 30
505 collateral_primary_use_type character varying 150
506 credit_risk_flag character varying 6
507 record_timestamp character varying 75
508 data_date timestamp without time zone
509 load_id integer 32