fct_qrm_cm_master_mr

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_number numeric 28
2 account_status character varying 50
3 accredited_broker_code character varying 9
4 amortisation_type_code character varying 20
5 anzsic_level_1 character varying 100
6 available_cashback numeric 15
7 average_monthly_balance numeric 15
8 balance_sheet_indicator character varying 1
9 bank_guarantee_indicator character varying 1
10 broker_code character varying 9
11 broker_originated_flag character varying 1
12 cea_off_bal numeric 19
13 collateral_primary_state character varying 10
14 composite_cdr character varying 2
15 composite_next_review_date timestamp without time zone
16 composite_ratings_model_desc character varying 10
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 50
22 impaired_flag_drs character varying 1
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 bigint 64
29 original_loan_amount numeric 15
30 origination_date timestamp without time zone
31 past_due_category character varying 20
32 past_due_days bigint 64
33 payment_pause_flag character varying 1
34 portfolio_date timestamp without time zone
35 product_description character varying 100
36 property_rights character varying 25
37 qrm_account character varying 75
38 secur_loans_capital_relief character varying 1
39 settlement_date timestamp without time zone
40 source_system character varying 4
41 tp_addon_rate numeric 8
42 tp_base_rate numeric 8
43 tp_basis_cost numeric 8