fct_obp_crai_account_eod_ln_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_closure_date timestamp without time zone
2 account_creation_date timestamp without time zone
3 account_efs_dim_id bigint 64
4 account_gl_closure_date timestamp without time zone
5 account_gl_opening_date timestamp without time zone
6 account_id_number character varying 72
7 application_facility_efs_dim_id character varying 330
8 account_number character varying 72
9 account_opening_date timestamp without time zone
10 account_status_code character varying 210
11 account_title character varying 900
12 accredited_broker_code character varying 150
13 approved_amount numeric 20
14 arrangement_id character varying 120
15 bank_code character varying 60
16 base_rate numeric 15
17 broker_id character varying 60
18 cost_centre_code character varying 450
19 company_code character varying 300
20 currency_code character varying 9
21 current_interest_rate numeric 15
22 facility_id character varying 150
23 first_disbursement_date timestamp without time zone
24 first_home_buyer_flag character varying 3
25 fixed_term_months integer 32
26 fixed_period_end_date timestamp without time zone
27 interest_rate_type character varying 150
28 fv_flag character varying 3
29 collateralisation character varying 150
30 linked_offset_account_flag character varying 3
31 interest_rate_term character varying 30
32 loan_purpose character varying 150
33 loan_sub_purpose character varying 60
34 loan_repayment_type character varying 384
35 loan_to_value_ratio numeric 17
36 lowdoc_flag character varying 3
37 margin_rate numeric 15
38 matured_loan_flag character varying 3
39 mortgage_insurance_flag character varying 3
40 mortgage_insurance_provider character varying 300
41 maturity_date timestamp without time zone
42 migration_status character varying 30
43 original_maturity_date timestamp without time zone
44 owner_occupied character varying 60
45 product_class character varying 6
46 product_group_code character varying 90
47 product_id character varying 90
48 product_sub_code character varying 90
49 redzstd_product_option_flag character varying 6
50 requested_amount numeric 20
51 service_branch_code character varying 30
52 source_product_code character varying 300
53 source_system_code character varying 9
54 source_system_group character varying 9
55 term_months bigint 64
56 of_cost_centre_code character varying 450
57 of_entity_code character varying 450
58 of_product_code character varying 450
59 of_int_accrued_account_code character varying 450
60 of_int_accrued_category_code character varying 450
61 of_int_expense_account_code character varying 450
62 of_int_expense_category_code character varying 450
63 of_int_expense_accrued_account_code character varying 450
64 of_int_expense_accrued_category_code character varying 450
65 of_int_income_account_code character varying 450
66 of_int_income_category_code character varying 450
67 of_principal_account_code character varying 450
68 of_principal_category_code character varying 450
69 of_inba_account_code character varying 450
70 of_inba_category_code character varying 450
71 source_product_dim_id bigint 64
72 pers_inv_usage_type_dim_id numeric 19
73 loan_purpose_dim_id bigint 64
74 bill_type_dim_id bigint 64
75 of_cost_centre_dim_id character varying 450
76 of_entity_dim_id character varying 450
77 of_int_accrued_category_dim_id character varying 450
78 of_int_accrued_account_dim_id character varying 450
79 of_int_expense_account_dim_id character varying 3
80 of_int_expense_accrued_account_dim_id character varying 3
81 of_int_expense_accrued_category_dim_id character varying 3
82 of_int_expense_category_dim_id character varying 30
83 of_int_income_account_dim_id character varying 450
84 of_int_income_category_dim_id character varying 450
85 of_principal_account_dim_id character varying 450
86 of_principal_category_dim_id character varying 450
87 of_product_dim_id character varying 450
88 of_inba_account_dim_id character varying 30
89 of_inba_category_dim_id character varying 30
90 effective_start_date timestamp without time zone
91 effective_end_date timestamp without time zone
92 is_current character varying 3