Versions Compared

Key

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

...

The following 'hist' tables are daily summary.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

 

hist_loan_arrears

 

hist_savings_balances

 

DW Tables

PPI Tables

STG Tables

...