ext_bnk_crai_hogan_ilp_account_hash_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 account_id_number character varying 512
2 source_system_code character varying 12
3 product_group_code character varying 30
4 product_sub_code character varying 30
5 source_product_description character varying 65
6 original_loan_amount numeric 15
7 outstanding_balance numeric 15
8 past_due_days integer 32
9 account_opening_date timestamp without time zone
10 account_maturity_date timestamp without time zone
11 account_closure_date timestamp without time zone
12 loan_repayment_type_code character varying 10
13 loan_repayment_type_description character varying 50
14 lvr_origination numeric 15
15 lvr_current numeric 15
16 first_home_buyer_flag character varying 1
17 property_purpose character varying 20
18 loan_purpose_code character varying 30
19 loan_purpose_description character varying 50
20 loan_sub_purpose_code character varying 30
21 loan_sub_purpose_description character varying 50
22 available_redraw_balance numeric 15
23 fixed_term_months integer 32
24 fixed_period_end_date timestamp without time zone
25 interest_only_end_date timestamp without time zone
26 loan_interest_rate_type character varying 30
27 interest_rate numeric 10
28 base_rate numeric 10
29 base_rate_index character varying 6
30 base_rate_index_description character varying 120
31 margin_rate numeric 11
32 accredited_broker_code character varying 512
33 service_branch_code character varying 30
34 linked_offset_account_flag character varying 1
35 schedule_amount numeric 15
36 schedule_date timestamp without time zone
37 schedule_frequency integer 32
38 schedule_period character varying 1
39 schedule_start_date timestamp without time zone
40 schedule_end_date timestamp without time zone
41 payment_pause_flag character varying 1
42 monthend_date date