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