fct_hog_crai_account_eod_cs_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 bigint 64
8 account_opening_date timestamp without time zone
9 account_status_code character varying 6
10 account_title character varying 75
11 arrangement_id character varying 120
12 bank_code character varying 30
13 branch_code character varying 12
14 company_code character varying 15
15 cost_centre_code character varying 450
16 created_by character varying 21
17 currency_code character varying 9
18 facility_id character varying 129
19 product_class character varying 9
20 product_group_code character varying 9
21 product_id character varying 6
22 product_sub_code character varying 6
23 loan_purpose character varying 180
24 loan_sub_purpose character varying 180
25 owner_occupied character varying 3
26 service_branch_code character varying 12
27 source_product_code character varying 6
28 offset_assoc_acct character varying 60
29 offset_flag character varying 3
30 balance_sheet_indicator character varying 27
31 source_system_code character varying 36
32 of_cost_centre_code character varying 450
33 of_entity_code character varying 300
34 of_principal_account_code character varying 300
35 of_principal_product_code character varying 300
36 of_principal_category_code character varying 300
37 of_int_accrued_account_code character varying 300
38 of_int_accrued_product_code character varying 300
39 of_int_accrued_category_code character varying 300
40 of_int_income_account_code character varying 300
41 of_int_income_category_code character varying 300
42 of_int_income_product_code character varying 300
43 of_int_expense_accrued_account_code character varying 300
44 of_int_expense_accrued_product_code character varying 300
45 of_int_expense_accrued_category_code character varying 300
46 of_int_expense_account_code character varying 300
47 of_int_expense_category_code character varying 300
48 of_int_expense_product_code character varying 300
49 revolving_credit_flag character varying 3
50 od_limit numeric 16
51 od_insured_ind character varying 3
52 od_secured_flag character varying 3
53 source_system_group character varying 9
54 account_id_number character varying 81
55 source_product_dim_id bigint 64
56 of_cost_centre_dim_id character varying 450
57 of_entity_dim_id character varying 300
58 of_int_accrued_category_dim_id character varying 300
59 of_int_accrued_account_dim_id character varying 300
60 of_int_accrued_product_dim_id character varying 300
61 of_int_expense_category_dim_id character varying 300
62 of_int_expense_account_dim_id character varying 300
63 of_int_expense_product_dim_id character varying 300
64 of_int_expense_accrued_account_dim_id character varying 300
65 of_int_expense_accrued_category_dim_id character varying 300
66 of_int_expense_accrued_product_dim_id character varying 300
67 of_principal_account_dim_id character varying 300
68 of_principal_category_dim_id character varying 300
69 of_principal_product_dim_id character varying 300
70 effective_start_date timestamp without time zone
71 product_debit_interest_rate double precision 53
72 debit_interest_code character varying 6
73 effective_end_date timestamp without time zone
74 is_current character varying 3