fct_hog_crai_account_eod_ln_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

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