qrm_cm_master_mr

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 account_bdm character varying 18
2 account_bdm_description character varying 300
3 account_cdr character varying 6
4 account_cr character varying 3
5 account_crgs_date timestamp without time zone
6 account_dimension character varying 150
7 account_number numeric 28
8 account_status character varying 150
9 accredited_broker_code character varying 21
10 accrued_interest numeric 15
11 allocated_cash_collateral_value numeric 15
12 amortisation_type_code character varying 60
13 anzsic_apra_categories character varying 150
14 anzsic_code character varying 12
15 anzsic_level_1 character varying 300
16 anzsic_level_2 character varying 300
17 anzsic_level_3 character varying 390
18 anzsic_level_4 character varying 300
19 anzsic_rba_categories character varying 300
20 anzsic_sml_finance_cat character varying 300
21 applcusttype character varying 90
22 application_number integer 32
23 apra_asset_class character varying 300
24 apra_asset_class_irb character varying 300
25 apra_category integer 32
26 apra_class integer 32
27 apra_counterparty_type character varying 300
28 apra_off_bal_trans_type character varying 300
29 apra_sub_category integer 32
30 aps113_rwa_percentage numeric 6
31 aps330_sector character varying 150
32 arf117_category character varying 120
33 assetstoliabilitiesratioall numeric 9
34 available_cashback numeric 15
35 average_monthly_balance numeric 15
36 balance_sheet_indicator character varying 3
37 bank_guarantee_indicator character varying 3
38 basis character varying 24
39 behavioural_duration integer 32
40 break_date timestamp without time zone
41 broker_code character varying 15
42 broker_originated_flag character varying 3
43 calc_advance_amt numeric 15
44 calc_avail_bal numeric 15
45 cancellable character varying 33
46 capital_adjustment_amount numeric 15
47 capital_adjustment_rate numeric 8
48 capital_firb numeric 15
49 ccf numeric 5
50 ccf_firb numeric 5
51 cea_off_bal numeric 15
52 cea_off_bal_firb numeric 15
53 certain_drawdown character varying 60
54 clms_group_name character varying 300
55 clms_group_number integer 32
56 clms_product_division integer 32
57 clms_product_division_desc character varying 300
58 coll_group_id_all_assets numeric 28
59 coll_group_id_efc numeric 28
60 coll_group_id_erm numeric 28
61 coll_group_id_property numeric 28
62 coll_mrkt_val_indexed_erm numeric 15
63 collateral_primary_abs_region character varying 765
64 collateral_primary_category character varying 150
65 collateral_primary_id numeric 16
66 collateral_primary_pcode character varying 30
67 collateral_primary_state character varying 30
68 collateral_primary_suburb character varying 150
69 collateral_primary_use_type character varying 150
70 composite_cdr character varying 6
71 composite_clms_source_customer numeric 16
72 composite_counterparty_bdm character varying 18
73 composite_counterparty_bdm_name character varying 150
74 composite_cr character varying 6
75 composite_crgs_date timestamp without time zone
76 composite_next_review_date timestamp without time zone
77 composite_override_flag integer 32
78 composite_ratings_model integer 32
79 composite_ratings_model_desc character varying 30
80 composite_totalscore numeric 27
81 compounding_frequency character varying 60
82 correlation_firb numeric 15
83 counterparty_abs_region character varying 150
84 counterparty_bdm integer 32
85 counterparty_cdr character varying 6
86 counterparty_country_code character varying 18
87 counterparty_country_description character varying 150
88 counterparty_cr character varying 3
89 counterparty_crgs_date timestamp without time zone
90 counterparty_gcis_customer_no numeric 16
91 counterparty_mnemonic character varying 30
92 counterparty_name character varying 765
93 counterparty_postcode character varying 30
94 counterparty_resident_flag character varying 9
95 counterparty_source_customer_no numeric 16
96 counterparty_state character varying 105
97 counterparty_type character varying 150
98 credit_product_group character varying 75
99 credit_risk_flag character varying 3
100 cur_net_rate numeric 10
101 current_payment numeric 15
102 deposit_offset_account numeric 25
103 deposit_offset_average_balance numeric 15
104 deposit_offset_balance numeric 15
105 deposit_offset_rate numeric 9
106 dr_cr_flag character varying 6
107 drawn_status character varying 60
108 drs_group_id integer 32
109 drs_group_name character varying 900
110 ead_off_bal_firb numeric 15
111 ead_on_bal numeric 15
112 ead_on_bal_firb numeric 15
113 ead_total_firb numeric 15
114 ecap_agg_capital numeric 15
115 ecap_agg_rwa_total numeric 15
116 ecap_br_capital numeric 15
117 ecap_br_rwa_ama numeric 15
118 ecap_br_rwa_total numeric 15
119 ecap_capital_adjustment_amount numeric 15
120 ecap_cr_capital numeric 15
121 ecap_cr_ead numeric 15
122 ecap_cr_el numeric 15
123 ecap_cr_rwa_total numeric 15
124 ecap_irr_capital numeric 15
125 ecap_irr_rwa_ama numeric 15
126 ecap_irr_rwa_total numeric 15
127 ecap_mr_capital numeric 15
128 ecap_mr_rwa_ama numeric 15
129 ecap_mr_rwa_std numeric 15
130 ecap_mr_rwa_total numeric 15
131 ecap_or_capital numeric 15
132 ecap_or_rwa_ama numeric 15
133 ecap_or_rwa_std numeric 15
134 ecap_or_rwa_total numeric 15
135 effectivematurity_firb numeric 16
136 eligible_security_flag character varying 75
137 erm_flag character varying 3
138 existingcustomerflag1 character varying 6
139 expected_loss numeric 15
140 expected_loss_firb numeric 15
141 expected_loss_raroc numeric 15
142 exposure numeric 15
143 ext_rating character varying 6
144 ext_rating_long_term integer 32
145 ext_rating_short_term integer 32
146 external_rating_fitch character varying 30
147 external_rating_moodys character varying 30
148 external_rating_sp character varying 30
149 face_amt numeric 15
150 face_value numeric 15
151 firmsize_firb numeric 16
152 fixed_rate numeric 8
153 floating_rate numeric 8
154 forward_starting character varying 21
155 gtee_drawn numeric 15
156 gtee_limit numeric 15
157 guaranteed_rate_fee numeric 8
158 hardship_status_flag character varying 3
159 held_to_maturity_flag character varying 3
160 id_number character varying 150
161 ifrs_cash_flow_amt numeric 15
162 ifrs_cash_flow_int character varying 30
163 ifrs_est_rec_term character varying 30
164 ifrs_orig_int_rate integer 32
165 impaired_end_date timestamp without time zone
166 impaired_flag_drs character varying 3
167 impaired_start_date timestamp without time zone
168 impdpastdue_flag character varying 3
169 inba numeric 15
170 interest_rate_base numeric 15
171 interest_rate_classification character varying 9
172 interest_rate_margin numeric 15
173 internal_dt_lgd numeric 10
174 internal_lgd_model character varying 75
175 internal_pd_model character varying 75
176 internal_pit_lgd numeric 10
177 internal_pit_pd numeric 12
178 internal_term_pd numeric 12
179 internal_ttc_pd numeric 10
180 last_reprice_date timestamp without time zone
181 lcr_reporting_dimension character varying 360
182 lgd_category_prescribed character varying 240
183 lgd_dtlgc numeric 10
184 lgd_dtlgw numeric 10
185 lgd_dtpowo numeric 10
186 lgd_firb numeric 14
187 lgd_powo_total_score numeric 8
188 lgd_prescribed numeric 10
189 lgd_ttc numeric 10
190 lgd_v16_score numeric 8
191 lgd_v16_value character varying 75
192 lgd_v2_value numeric 11
193 limit_calculated numeric 15
194 limit_raw numeric 15
195 liquidity_customer_type character varying 150
196 liquidity_dimension character varying 150
197 liquidity_established integer 32
198 liquidity_fcs_coverage numeric 8
199 liquidity_fcs_runoff character varying 150
200 liquidity_runoff character varying 150
201 liquidity_runoff_category character varying 150
202 liquidity_runoff_percentage numeric 8
203 loan_purpose_code character varying 18
204 loan_sub_purp_origination character varying 60
205 loan_sub_purpose_code character varying 45
206 loan_term integer 32
207 loan_term_multiple character varying 3
208 loanrepaytonetmthlyinc numeric 15
209 locc_citizenship character varying 30
210 locc_of_org character varying 30
211 locc_of_risk character varying 30
212 low_doc_flag character varying 3
213 low_doc_flag_origination character varying 3
214 lvr_erm numeric 14
215 lvr_erm_band character varying 60
216 lvr_est_group numeric 15
217 lvr_origination numeric 9
218 margin numeric 14
219 mark_to_market numeric 20
220 mark_to_market_price numeric 8
221 mark_to_market_spread numeric 9
222 market_off_bal_flag character varying 3
223 maturity_date timestamp without time zone
224 max_dpd_l11m integer 32
225 max_dpd_l11m_date timestamp without time zone
226 min_credit_rating numeric 8
227 mortgage_insurance_company character varying 150
228 mortgage_insurance_indicator character varying 3
229 mortgage_offset_account integer 32
230 mthlypaytstomthlyincomepct integer 32
231 net_credit_exposure numeric 15
232 net_sales numeric 15
233 next_payment_date timestamp without time zone
234 next_payment_date_floating timestamp without time zone
235 next_reprice_date timestamp without time zone
236 next_reprice_date_floating timestamp without time zone
237 non_core_flag character varying 3
238 number_of_borrowers integer 32
239 occupation1 character varying 15
240 od_secured_flag character varying 3
241 off_bal_likely_to_draw_factor numeric 10
242 off_bal_principal_amt numeric 15
243 opics_fi_agg_indicator character varying 3
244 oracle_gl_account integer 32
245 oracle_gl_account_accrued_int integer 32
246 oracle_gl_account_inba integer 32
247 oracle_gl_business_unit integer 32
248 oracle_gl_cost_centre integer 32
249 oracle_gl_cost_centre_channel character varying 120
250 oracle_gl_cost_centre_egm character varying 150
251 oracle_gl_cost_centre_name character varying 300
252 oracle_gl_cost_centre_region character varying 150
253 oracle_gl_cost_centre_state character varying 120
254 oracle_gl_product character varying 30
255 original_days_to_maturity integer 32
256 original_loan_amount numeric 15
257 original_maturity integer 32
258 original_table character varying 90
259 origination_date timestamp without time zone
260 overdue_review_flag character varying 3
261 past_due_amount numeric 15
262 past_due_category character varying 60
263 past_due_days integer 32
264 pay_margin numeric 8
265 payment_frequency character varying 45
266 payment_frequency_floating character varying 45
267 pd_firb numeric 14
268 pd_score_firb numeric 8
269 pd_ttc numeric 14
270 pd_ttc_firb numeric 14
271 peoplesoft_gl_account integer 32
272 peoplesoft_gl_account_acc_int integer 32
273 peoplesoft_gl_account_inba integer 32
274 peoplesoft_gl_business_unit character varying 30
275 peoplesoft_gl_cost_centre integer 32
276 peoplesoft_gl_product character varying 45
277 pitpd_total_score numeric 8
278 pitpd_v2_value numeric 28
279 pitpd_v3_value numeric 20
280 pitpd_v4_value numeric 20
281 portfolio_date timestamp without time zone
282 portfolio_firb character varying 300
283 position_status character varying 150
284 principal_amount numeric 19
285 product_code_1 character varying 48
286 product_code_2 character varying 45
287 product_code_3 character varying 18
288 product_code_4 character varying 18
289 product_code_5 character varying 75
290 product_description character varying 300
291 property_rights character varying 75
292 prov_bookbal_ratio numeric 6
293 provision_amount numeric 15
294 provision_amount_collective numeric 15
295 provision_amount_ifrs numeric 15
296 provision_ercl numeric 15
297 qrm_account character varying 225
298 qrm_account_cm character varying 150
299 qrm_account_liquidity character varying 150
300 qrm_product_cm character varying 150
301 rate_index character varying 90
302 rec_margin numeric 8
303 redraw_available character varying 3
304 regulated_flag character varying 3
305 repossession_date timestamp without time zone
306 repossession_flag character varying 3
307 reprice_frequency integer 32
308 reprice_frequency_mult character varying 3
309 residentialstatus1 character varying 6
310 residual_amount numeric 15
311 restructured_flag character varying 3
312 risk_weight numeric 6
313 risk_weight_firb numeric 6
314 rwa_off_bal numeric 15
315 rwa_off_bal_firb numeric 15
316 rwa_on_bal numeric 15
317 rwa_on_bal_firb numeric 15
318 rwa_total_firb numeric 15
319 secid character varying 150
320 secondary_officer_code character varying 30
321 securedorunsecuredflag character varying 6
322 securitisation_pool_id character varying 24
323 securitisation_reportable character varying 9
324 securitisation_risk_sub_category character varying 300
325 securitisation_status character varying 3
326 settlement_date timestamp without time zone
327 slotting_rating integer 32
328 source_currency character varying 9
329 source_system character varying 12
330 source_table character varying 105
331 swap_pay_intenddte timestamp without time zone
332 swap_rec_intenddte timestamp without time zone
333 target_capital_adequacy numeric 8
334 target_lvr numeric 7
335 tbe numeric 15
336 tce numeric 15
337 tce_group_id integer 32
338 tce_group_name character varying 765
339 tenor character varying 30
340 timeatcurrentaddressmmm1 integer 32
341 timeincurrentempmtmmm1 integer 32
342 total_write_off_amt_mtd numeric 15
343 totnumofdependants1 integer 32
344 tottimeinempmtmmm1 integer 32
345 tp_addon_calculation numeric 15
346 tp_addon_rate numeric 8
347 tp_base_rate numeric 8
348 tp_basis_calculation numeric 15
349 tp_basis_cost numeric 8
350 tp_curve character varying 150
351 tp_days_on_old_rate integer 32
352 tp_funding_allocation numeric 15
353 tp_funding_allocation_rate numeric 8
354 tp_funding_index character varying 90
355 tp_irr_calculation numeric 15
356 tp_liquidity_calculation numeric 15
357 tp_liquidity_rate numeric 8
358 tp_model character varying 60
359 tp_old_addon_rate numeric 8
360 tp_old_base_rate numeric 8
361 tp_old_basis_cost numeric 8
362 tp_old_transfer_spread numeric 8
363 tp_start_point character varying 90
364 tp_status character varying 60
365 tp_status_code integer 32
366 tp_transfer_spread_calculation numeric 15
367 tp_weighted_average_addon_rate numeric 8
368 tp_weighted_average_base_rate numeric 8
369 tp_weighted_average_basis_cost numeric 8
370 trading_book_flag character varying 3
371 transfer_rate numeric 12
372 transfer_spread numeric 8
373 ttcpd_model_score numeric 15
374 ttcpd_risk_grade character varying 6
375 ttcpd_total_score numeric 8
376 ttcpd_v1_score numeric 8
377 ttcpd_v1_value numeric 9
378 ttcpd_v16_score numeric 8
379 ttcpd_v16_value character varying 75
380 ttcpd_v17_score numeric 8
381 ttcpd_v17_value character varying 75
382 ttcpd_v18_score numeric 8
383 ttcpd_v18_value character varying 75
384 ttcpd_v19_score numeric 8
385 ttcpd_v19_value character varying 75
386 ttcpd_v2_score numeric 8
387 ttcpd_v2_value numeric 11
388 ttcpd_v20_score numeric 8
389 ttcpd_v20_value character varying 75
390 ttcpd_v21_score numeric 8
391 ttcpd_v21_value character varying 75
392 ttcpd_v22_score numeric 8
393 ttcpd_v22_value character varying 75
394 ttcpd_v3_score numeric 8
395 ttcpd_v3_value numeric 12
396 ttcpd_v4_score numeric 8
397 ttcpd_v4_value numeric 11
398 ttcpd_v5_score numeric 8
399 ttcpd_v5_value numeric 9
400 ttcpd_v6_score numeric 8
401 ttcpd_v6_value numeric 12
402 unexpected_loss_firb numeric 15
403 unrecovered_costs numeric 15
404 watchlist_creditrec_indicator character varying 6
405 write_off_amount numeric 15
406 write_off_code character varying 15
407 write_off_date timestamp without time zone
408 yield_curve character varying 90
409 interest_code character varying 6
410 ecl_stage integer 32
411 interest_only_end_date timestamp without time zone
412 interest_only_start_date timestamp without time zone
413 interest_only_term integer 32
414 max_dpd_l5m integer 32
415 max_dpd_l5m_date timestamp without time zone
416 composite_bb_pitq_builder character varying 150
417 composite_bb_pitq_enviro character varying 150
418 composite_bb_pitq_income character varying 150
419 composite_bb_pitq_industry character varying 150
420 composite_bb_pitq_mgmt character varying 150
421 date_added_to_wl timestamp without time zone
422 date_exit_from_wl timestamp without time zone
423 next_wl_review_date timestamp without time zone
424 provision_type character varying 45
425 clms_account_number numeric 28
426 small_business_security_code character varying 9
427 payment_pause_flag character varying 3
428 dynamic_lvr numeric 15
429 ccy_spotrate numeric 18
430 composite_ca_cdr_origination character varying 30
431 composite_ca_desc_origination character varying 300
432 composite_ca_origination character varying 5
433 ctrccy_spotrate numeric 18
434 first_home_buyer_flag character varying 5
435 hrdd integer 32
436 online_channel_flag character varying 5
437 payment_assistance_flag character varying 4
438 stage_1_ecl numeric 15
439 stage_2_ecl numeric 15
440 stage_3_ecl numeric 15
441 swap_pay_intrate_8 numeric 18
442 swap_pay_intstrtdte timestamp without time zone
443 swap_rec_intrate_8 numeric 18
444 swap_rec_intstrtdte timestamp without time zone
445 data_date timestamp without time zone
446 load_id integer 32