fct_obp_crai_loan_account_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_number character varying 72
2 account_id_number character varying 72
3 migration_status character varying 24
4 account_opening_date timestamp without time zone
5 account_closure_date timestamp without time zone
6 loan_repayment_type character varying 384
7 interest_rate_type character varying 90
8 current_interest_rate double precision 53
9 margin_rate numeric 8
10 first_home_buyer_flag character varying 3
11 owner_occupied character varying 42
12 maturity_date timestamp without time zone
13 term_months bigint 64
14 fixed_period_end_date timestamp without time zone
15 accredited_broker_code character varying 20
16 broker_id character varying 60
17 service_branch_code character varying 30
18 application_facility_efs_dim_id character varying 279
19 facility_id character varying 120
20 source_system_code character varying 9
21 source_product_code character varying 195
22 product_id character varying 90
23 product_group_code character varying 90
24 product_sub_code character varying 90
25 approved_amount numeric 29
26 requested_amount numeric 29
27 loan_to_value_ratio numeric 17
28 loan_purpose character varying 120
29 loan_sub_purpose character varying 30
30 loan_purpose_description character varying 600
31 loan_sub_purpose_description character varying 600
32 account_status_code character varying 150
33 product_description character varying 360
34 source_product_description character varying 1074
35 has_hardship_relief character varying 3
36 primary_reason_for_closure character varying 600
37 secondary_reason_for_closure character varying 600
38 payout_reason_code character varying 1203
39 sales_officer_id character varying 762
40 application_channel_source character varying 24
41 is_current character varying 24
42 effective_start_date timestamp without time zone
43 effective_end_date timestamp without time zone