ext_bnk_crai_obp_loan_account_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 account_id_number character varying 72
2 source_system_code character varying 9
3 source_product_code character varying 195
4 product_group_code character varying 90
5 product_sub_code character varying 90
6 product_type character varying 360
7 source_product_description character varying 1074
8 original_loan_amount numeric 29
9 outstanding_balance numeric 19
10 migration_status character varying 24
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 1203
15 loan_repayment_type character varying 20
16 loan_interest_rate_type character varying 90
17 interest_rate double precision 53
18 base_rate numeric 6
19 instalment_amount double precision 53
20 instalment_date timestamp without time zone
21 schedule_frequency integer 32
22 schedule_period character varying 90
23 schedule_start_date timestamp without time zone
24 schedule_end_date timestamp without time zone
25 lvr_current numeric 19
26 past_due_days bigint 64
27 first_home_buyer_flag character varying 3
28 property_purpose character varying 42
29 loan_purpose_code character varying 120
30 loan_purpose_description character varying 300
31 loan_sub_purpose_code character varying 30
32 loan_sub_purpose_description character varying 300
33 available_redraw_balance numeric 15
34 fixed_term_months integer 32
35 fixed_period_end_date date
36 accredited_broker_code character varying 20
37 lender_id character varying 762
38 application_channel_source character varying 24
39 service_branch_code character varying 30
40 facility_id character varying 120
41 payment_pause_flag character varying 1
42 monthend_date date