ext_bnk_crai_obp_loan_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 source_product_code character varying 65
4 product_group_code character varying 40
5 product_sub_code character varying 40
6 product_type character varying 120
7 source_product_description character varying 358
8 original_loan_amount numeric 37
9 outstanding_balance numeric 15
10 migration_status character varying 8
11 account_opening_date timestamp without time zone
12 account_maturity_date timestamp without time zone
13 account_closure_date timestamp without time zone
14 account_closure_reason character varying 401
15 loan_repayment_type character varying 128
16 loan_interest_rate_type character varying 30
17 interest_rate numeric 37
18 base_rate numeric 8
19 instalment_amount numeric 37
20 instalment_date timestamp without time zone
21 schedule_frequency integer 32
22 schedule_period character varying 30
23 schedule_start_date timestamp without time zone
24 schedule_end_date timestamp without time zone
25 lvr_current numeric 15
26 past_due_days integer 32
27 first_home_buyer_flag character varying 1
28 property_purpose character varying 14
29 loan_purpose_code character varying 40
30 loan_purpose_description character varying 100
31 loan_sub_purpose_code character varying 50
32 loan_sub_purpose_description character varying 100
33 available_redraw_balance numeric 15
34 fixed_term_months integer 32
35 fixed_period_end_date timestamp without time zone
36 accredited_broker_code character varying 512
37 lender_id character varying 512
38 application_channel_source character varying 8
39 service_branch_code character varying 10
40 facility_id character varying 512
41 payment_pause_flag character varying 1
42 monthend_date date