...
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 fact_customer_fees_and_charges |
|
|
| dw_fund |
|
|
|
|
| stg_loan_type1_columns | ||||
dim_customer |
| fact_savings_transactions |
|
|
| dw_mfi_configuration |
|
|
|
|
|
| ||||
dim_loan |
| fact_savingsclient_transactions attendances |
|
|
| Lookup tables for Data Warehouse convenience |
|
|
|
|
| stg_etl_run_history | ||||
dim_savings |
| Schedule tables cut down and copied to Data Warehouse to allow some processing of Due Vs Collected type functionality |
|
|
| dw_account_charge_type |
|
|
|
|
|
| ||||
|
| fact | dw_ | customer_fees_and_charges loan_schedules |
|
|
|
| dw_arrears_band_monthly |
|
|
|
|
|
| |
|
| fact | dw_loan_ | clientfee_ | attendances schedules |
|
|
|
| dw_arrears_band_weekly |
|
|
|
|
|
|
|
| dw_customer_schedules |
|
|
|
|
|
|
|
|
|
| ||||
|
| dw_customer_fee_schedules |
|
|
|
|
|
|
|
|
|
|
WIP: Items below to be updated to match the table listing above
...