ext_bnk_crai_hogan_ilp_account_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 account_id_number character varying 81
2 source_system_code character varying 36
3 product_group_code character varying 9
4 product_sub_code character varying 9
5 source_product_description character varying 300
6 original_loan_amount numeric 16
7 outstanding_balance numeric 19
8 past_due_days bigint 64
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 9
13 loan_repayment_type_description character varying 768
14 lvr_origination numeric 9
15 lvr_current numeric 18
16 first_home_buyer_flag character varying 3
17 property_purpose character varying 3
18 loan_purpose_code character varying 9
19 loan_purpose_description character varying 300
20 loan_sub_purpose_code character varying 6
21 loan_sub_purpose_description character varying 300
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 text
27 interest_rate double precision 53
28 base_rate double precision 53
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 21
33 service_branch_code character varying 30
34 linked_offset_account_flag character varying 3
35 schedule_amount numeric 15
36 schedule_date timestamp without time zone
37 schedule_frequency integer 32
38 schedule_period character varying 3
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