The Batch Manager database contains the following tables. Generate reports using the tables highlighted in bold:
Internal configuration information – do not modify
The current value of each user-defined counter – do not modify
Version information – do not modify
This table drives the Batch Manager screen within PSIcapture. Deleting a batch removes its entry from this table.
This is the parent table for batch reporting. It contains all batches, deleted or otherwise. Use this table to determine the batch name, the document type name, the path where the batch was stored, the current batch status, etc.
Each time a batch is opened in a workflow module (Indexing, QA, etc.), a batch history record is added to this table. It records the start and end time for the module, the user ID of the person working with the batch, how the module was closed, and “before and after” counts for the batch’s folders, documents, records and pages.
These tables record details for each Stats_BatchHistory row. The table linked to the row depends upon the value in the Module column. For example, a row for a batch’s Index step has a corresponding row in the Stats_IndexStats, which records Index module statistics.
Column Values / Explanations
Most of the columns and their values are self-explanatory. However, a few require further explanation: