Purging Assets and Asset Information

Advanced Operations (G1231), Asset Master and Balances Purge.

If you are only purging specific records, make data selections to specify the records to purge.

Use the Asset Master and Balances Purge program (R12912) to purge old fixed assets records from the system. You can purge:

• A selected asset that you disposed of in a prior year.

• Data tables for a prior year.

Every record that the system purges during this procedure is transferred to a separate purge table. The purge table name is the same as the original table name with a P at the end. For example, the purge table for F1201 is F1201P.

This purge procedure automatically creates the appropriate purge tables when the purge program is run for the first time. These purge tables are stored in the same library where the corresponding tables are stored.

In general, you back up any of these tables that you plan to purge:

• Asset Master File table (F1201).

• Asset Account Balances File table (F1202).

• Location Tracking Table (F1204).

• Equipment Messages table (F1205).

• Equipment License Master table (F1206).

• Maintenance Schedule File table (F1207).

• Parent History table (F1212).

• Equipment Rates table (F1301).

• Status History File table (F1307).

  Important: Ensure that no one accesses the general accounting or fixed assets tables while you run this procedure. The program is unable to purge records that are locked by other system applications. Any records that a user accesses elsewhere in the system are not purged.

After the purge is complete, the program prints a report that includes the asset number, description, responsible business unit, and disposal date (if applicable) of the purged assets. The report also shows which tables had records that were purged and a summary showing how many records were purged from each table.