| Table of Contents |
|---|
Listing of Data Warehouse Tables
DIM |
| FACT |
| HIST |
| DW |
|
| PPI |
|
| STG |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dimension modelling reference tables |
| Dimension modelling fact tables |
| Daily balance tables derived from Data Warehouse fact tables. |
| Lookup tables copied from mifos OLTP data. |
|
|
|
|
| Staging tables. Not used for reporting. |
dim_date |
| fact_loan_disbursals |
| hist_loan_balances |
| dw_account_action |
|
| dw_ppi_survey |
|
| stg_personnel_names_and_name_changes |
dim_product |
| fact_loan_repayments |
| hist_loan_arrears |
| dw_currency |
|
| ppi_category_likelihood_bands |
|
| stg_customer_and_account_updates |
dim_office |
| fact_loan_fees_and_charges |
| hist_savings_balances |
| dw_fee |
|
| fact_ppi_survey_results |
|
| stg_customer_type1_columns |
dim_personnel |
| dw_loan_schedules |
|
|
| dw_fund |
|
|
|
|
| stg_loan_type1_columns |
dim_customer |
|
|
|
|
| dw_mfi_configuration |
|
|
|
|
|
|
dim_loan |
| fact_savings_transactions |
|
|
| Lookup tables for Data Warehouse convenience |
|
|
|
|
| stg_etl_run_history |
dim_savings |
|
|
|
|
| dw_account_charge_type |
|
|
|
|
|
|
|
| fact_customer_fees_and_charges |
|
|
| dw_arrears_band_monthly |
|
|
|
|
|
|
|
| fact_client_attendances |
|
|
| dw_arrears_band_weekly |
|
|
|
|
|
|
...
The following 'hist' tables hold daily balances for 'active' accounts (good and bad standing loan accounts / active and inactive savings accounts). The data is derived from other data warehouse tables. These tables do increase the size of the data warehouse database substantially but offer improved performance and simpler querying.
These table are typica
The b
hist_loan_balances | Contains daily balances for 'active' loan accounts (good and bad standing loan accounts). Doesn't included reversed transactions as they affect the 'as of' situation. |
hist_loan_arrears |
|
hist_savings_balances |
|
...