...
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 |
| fact_customer_fees_and_charges |
|
|
| dw_fund |
|
|
|
|
| stg_loan_type1_columns | |||||
dim_customer |
| fact_savings_transactions |
|
|
| dw_mfi_configuration |
|
|
|
|
|
| |||||
dim_loan |
| fact_client_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 |
|
|
|
|
|
| |||||
|
|
| dw_loan_schedules |
|
|
|
|
|
| dw_arrears_band_monthly |
|
|
|
|
|
| |
|
| dw_loan_fee_schedules |
|
|
|
| dw_arrears_band_weekly |
|
|
|
|
|
| ||||
|
| dw_customer_schedules |
|
|
|
|
|
|
|
|
|
| |||||
|
| dw_customer_fee_schedules |
|
|
|
|
|
|
|
|
|
|
WIP: Items below to be updated to match the table listing above
...