Table Updates/Inserts/Deletes

Table inserts and updates into application tables occur when the you do the following:

  • Perform an asset selection via the Update List with Results button on the Asset Selection tab.
  • Add assets directly to the Non-Contiguous Asset List.
  • Edit selected records in the Asset Master and Disposal Data Records subtask via the Modify/View Data for Export button and click on the Apply Changes button.
  • Click the Save Batch button or the Preview Default Report, Print Default Report, or Default Action buttons.

The records will be inserted into the application tables with the Batch ID as part of each record for all of these after pushing the Save Batch button except for the export process, so that all data will be identifiable and retrievable for processing into an export file or deleted from consideration. The records for a particular batch are deleted from the application tables when you execute the export process. The following actions result in records associated with a Batch ID being deleted from the application table:

  • File/Delete with a Batch ID on the screen that has records in the application tables
  • Process
  • Retrieve Batch, then Remove all records from the Non-Contiguous Asset List, and click Save Batch with the Batch ID still on the screen