1. Advanced Real Estate Forecasting Implementation Guide
  2. Understanding the Process to Purge Budget Results

Understanding the Process to Purge Budget Results

Because you can create multiple revisions of the same budget for numerous buildings, you can manage the size of the AREF Budget Results table (F15L109) by purging some records. The system purges the records by revision number; therefore, if you do not want to purge all of the records for a specific revision number, use data selection to specify a property or building. When you run the AREF Purge Budget Results program (R15L109P), the system removes records from these tables only:

  • AREF Budget Results table (F15L109).

  • AREF Prior Gross Billings table (F15L302).

  • EP Billing Register table (F15L38).

The system does not remove any of the setup records that exist for the revision specified.

Note: You do not have to run the purge program to rerun the AREF Budget Calculation program (R15L1091) for the same revision. The system automatically removes the budget results records prior to generating new records.

Although you cannot retrieve the records that you purge, you can re-create them by rerunning the R15L1091 program, as long as the parameters in the setup information have not been altered.