Page Comparison

dw_mfi_configuration

currently contains:
loan_lateness_days - no. of days before a loan is considered in bad standing (is used in arrears reporting)
savings_dormancy_days - no. of days before a savings active is dormant before it is considered inactive (not currently used in mifos or DW)

Loaded from prd_type mifos table

dw_loan_schedules

loan schedule details (was a 'fact' table but decided against that as found it very hard to keep schedule entries tracked to the dim_loan entries.

Transactions simply extracted from mifos equivalent.  Only links to the loan_account_id not a specific entry in dim_loan. Need to be updated if the schedule dates change (if disbursed on a date different to the expected date).

dw_account_charge_type

Indicates the type of fee...charge/fee/penalty - use on the fee transaction tables
Values are
1 Periodic and Upfront Fees (get fee frequency info from dim_fee)
2. Misc. Fees/Charges
3. Misc. Penalties

preloaded with DW.