int_qrm_cm_master_mr_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 account_number numeric 28
2 account_status character varying 150
3 accredited_broker_code character varying 21
4 amortisation_type_code character varying 60
5 anzsic_level_1 character varying 300
6 available_cashback numeric 15
7 average_monthly_balance numeric 15
8 balance_sheet_indicator character varying 3
9 bank_guarantee_indicator character varying 3
10 broker_code character varying 15
11 broker_originated_flag character varying 3
12 cea_off_bal numeric 15
13 collateral_primary_state character varying 30
14 composite_cdr character varying 6
15 composite_next_review_date timestamp without time zone
16 composite_ratings_model_desc character varying 30
17 counterparty_gcis_customer_no numeric 16
18 cur_net_rate numeric 10
19 exposure numeric 15
20 face_amt numeric 15
21 id_number character varying 150
22 impaired_flag_drs character varying 3
23 interest_rate_margin numeric 15
24 interest_only_start_date timestamp without time zone
25 interest_only_end_date timestamp without time zone
26 lvr_erm numeric 14
27 lvr_origination numeric 9
28 oracle_gl_cost_centre integer 32
29 original_loan_amount numeric 15
30 origination_date timestamp without time zone
31 past_due_category character varying 60
32 past_due_days integer 32
33 payment_pause_flag character varying 3
34 portfolio_date timestamp without time zone
35 product_description character varying 300
36 property_rights character varying 75
37 qrm_account character varying 225
38 secur_loans_capital_relief text
39 settlement_date timestamp without time zone
40 source_system character varying 12
41 tp_addon_rate numeric 8
42 tp_base_rate numeric 8
43 tp_basis_cost numeric 8