Versions Compared

Old Version 21

changes.mady.by.user johnwoodlock (Unlicensed)

Saved on

compared with

New Version 22

changes.mady.by.user johnwoodlock (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

hist_loan_balances and hist_loan_arrears provides the simplest and quickest way of identifying PAR values at MFI, branch, loan officer, center and groups levels at any point in time.

hist_loan_balances

Contains daily balances for 'active' loan accounts (good and bad standing loan accountsstatus's).  Doesn't included reversed transactions as they affect the 'as of' situation.  
For example, a loan might be active on Jan 1 (so should appear on a report that looks at the situation on run for Jan 1).  On Jan 2, the loan is may be reversed which creates backdated transactions to contra all repayment and disbursal transactions created.

hist_loan_arrears

Contains daily balances for over due loans (hist_loans_overdue is a more correct table name).

Overdue: loan is not fully up to date with repayment schedule
In Arrears: loan is overdue by more than 'lateness' days (where lateness is defined within mifos Admin functionality and copied to DW table dw_mfi_configuration).  


hist_savings_balances  

Contains daily balances for 'active' savings accounts (active and inactive status's).

DW Tables

PPI Tables

STG Tables

...