Process
These processing options enable you to specify the mode in which to run the Asset Master and Balances Purge program and which tables to purge.
- 1. Process Mode
Use this processing option to specify the mode in which to run this program. Values are:
Blank: Run the program in preliminary mode.
You should run the program in preliminary mode before running it in final mode. The program will produce a report, which will help you ensure that the correct assets and tables are being purged. Running the program in preliminary mode will not purge rows from any of the tables. When you run this program in preliminary mode, the program will print a report that shows how many rows will be purged from each table for each asset.
1: Run the program in final mode.
When you run the program in final mode, the program will produce a report that shows how many rows were purged from every table for each asset. Running the program in final mode will purge rows from the tables you have selected. When you run this program in final mode, the program will print a report showing how many rows were purged from each table for each asset and purge the tables that you have selected.
- 2. Purge All Tables
Specify whether the Asset Master table (F1201) and all related tables are to be purged or just the tables you select in the Specify Tables processing option located on this tab. The rows that are purged will be deleted from the original tables and placed into their corresponding purge tables. For example, records purged from the F1201 table will be placed in the F1201P table. Values are:
Blank: Rows will be purged from only the tables you specify in the Specify Tables processing option located on this tab.
1: Rows in the Asset Master table (F1201) will be purged along with rows in all related tables that contain the purged asset.
Rows will only be purge for an asset that has a disposal date that is in a prior year and does not have any children attached to it.
- 3. Specify Tables
Specify which tables to purge. This processing option only applies if the Purge All Tables processing option on this tab is blank. The tables that you can purge are:
F1202 - Asset Account Balances
F1301 - Equipment Rates
F1204 - Location Tracking
F1205 - Equipment Message
F1206 - Equipment License Master
F1207 - Maintenance Schedule
F1212 - Parent History
F1306 - Meter Reading Estimates
F1307 - Status History
F1308 - Equipment Routes
F13907 - Associated Service Types
Values are:
Blank: Do not purge the table.
1: Purge the table.
- 4. Start Year (4 Digits)
Specify the first year that Asset Account Balances table (F1202) rows are to be purged. All years prior to the year entered, including the year entered, will be purged. This processing option only applies if the Specify Tables processing option located on this tab contains a value of 1 for the Asset Account Balances table. If this option is left blank, only the current fiscal year's records will be retained, as all prior years' records will be purged.