int_qrm_cm_master_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 50
3 accredited_broker_code character varying 27
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 27
11 broker_originated_flag character varying 3
12 cea_off_bal numeric 19
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 19
21 id_number character varying 84
22 impaired_flag_drs character varying 3
23 interest_rate_margin numeric 15
24 lvr_erm numeric 14
25 lvr_origination numeric 9
26 oracle_gl_cost_centre bigint 64
27 original_loan_amount numeric 15
28 origination_date timestamp without time zone
29 past_due_category character varying 60
30 past_due_days bigint 64
31 portfolio_date timestamp without time zone
32 product_description character varying 300
33 property_rights character varying 75
34 qrm_account character varying 225
35 secur_loans_capital_relief character varying 3
36 settlement_date timestamp without time zone
37 source_system character varying 12
38 tp_addon_rate numeric 8
39 tp_base_rate numeric 8
40 tp_basis_cost numeric 8