fct_obp_crai_account_balance_pit_td_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 period_dim_id bigint 64
2 account_dim_id bigint 64
3 cqr_dim_id integer 32
4 sr_dim_id integer 32
5 crc_dim_id integer 32
6 source_product_dim_id bigint 64
7 clms_division_dim_id integer 32
8 bdm_dim_id integer 32
9 gl_business_unit_dim_id integer 32
10 gl_product_dim_id bigint 64
11 gl_account_dim_id bigint 64
12 cost_centre_dim_id bigint 64
13 branch_dim_id bigint 64
14 clms_group_dim_id integer 32
15 borrower_dim_id bigint 64
16 account_status_dim_id bigint 64
17 deposit_status_dim_id bigint 64
18 of_cost_centre_sid bigint 64
19 of_entity_sid bigint 64
20 of_product_sid bigint 64
21 of_account_sid bigint 64
22 of_category_sid bigint 64
23 of_intercompany_sid bigint 64
24 pers_inv_usage_type_dim_id bigint 64
25 insert_run_audit_id integer 32
26 update_run_audit_id integer 32
27 source_system_code character varying 9
28 account_number character varying 120
29 deposit_number double precision 53
30 value_date timestamp without time zone
31 product_holding_number character varying 120
32 source_product_code character varying 183
33 business_development_manager character varying 762
34 gl_business_unit integer 32
35 gl_product character varying 72
36 gl_account character varying 18
37 cost_centre_code character varying 450
38 service_branch_code character varying 30
39 account_status_code character varying 120
40 deposit_status_code character varying 120
41 of_cost_centre_code character varying 720
42 of_entity_code character varying 450
43 of_product_code character varying 720
44 of_account_code character varying 720
45 of_category_code character varying 720
46 of_intercompany_code character varying 720
47 credit_int_rate double precision 53
48 maturity_date timestamp without time zone
49 next_int_payout_date timestamp without time zone
50 term_months double precision 53
51 broker_id character varying 3
52 current_balance double precision 53
53 captial_balance numeric 1
54 balance double precision 53
55 balance_sheet_indicator character varying 27
56 interest_rate_type character varying 15
57 inba_amount double precision 53
58 int_expense_accrued_ctd double precision 53
59 int_expense_movement_mtd double precision 53
60 int_expense_total_mtd double precision 53
61 term_dep_act_int_exp_acr_ctd double precision 53
62 renewal_counter double precision 53
63 principal_amt double precision 53
64 maturity_amt double precision 53
65 closeout_amt double precision 53
66 uncollected_principal_amt double precision 53
67 uncollected_int_amt double precision 53
68 unclaimed_principal_amt double precision 53
69 unclaimed_int_amt double precision 53
70 int_withheld_amt double precision 53
71 total_int_withheld_amt double precision 53
72 principal_due_amt double precision 53
73 int_due_amt double precision 53
74 lien_principal_amt double precision 53
75 lien_interest_amt double precision 53
76 oldest_arrears_grading_code integer 32
77 undzstdn_amount integer 32
78 int_income_accrued_ctd double precision 53
79 int_income_movement_mtd numeric 1
80 int_income_total_mtd numeric 1
81 debit_int_rate double precision 53
82 available_redzstd_balance integer 32
83 offset_facility_balance double precision 53
84 unearned_int_mtd double precision 53
85 dzstdn_amount_ltd double precision 53
86 unapplied_fund_amount double precision 53
87 cdc_source_system_code character varying 12
88 cdc_record_type character varying 48
89 cdc_commit_timestamp date
90 cdc_extract_timestamp timestamp without time zone
91 product_code character varying 90
92 offer_id character varying 90
93 base_rate double precision 53
94 acct_udm_rate double precision 53
95 cr_int_exp_accr_ctd double precision 53
96 accr_stat_amt_accr_mtd double precision 53
97 total_guarantee_value numeric 1
98 average_monthly_balance numeric 1
99 total_unrecovered_costs numeric 1
100 arrears_0_1_month_amount numeric 1
101 arrears_1_2_month_amount numeric 1
102 arrears_2_3_month_amount numeric 1
103 arrears_3_4_month_amount numeric 1
104 arrears_4_5_month_amount numeric 1
105 arrears_5_6_month_amount numeric 1
106 arrears_6_plus_month_amount numeric 1
107 total_arrears_amount double precision 53
108 principle_limit double precision 53