PSIcapture Scripting: Batch Manager Reporting Database Overview

Table Overview

The Batch Manager database contains the following tables. Generate reports using the tables highlighted in bold:


BatchManager Internal configuration information – do not modify
Counters The current value of each user-defined counter – do not modify
DatabaseProperties Version information – do not modify
ManagedBatches This table drives the Batch Manager screen within PSIcapture. Deleting a batch removes its entry from this table.
Stats_Batches 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.
Stats_BatchHistory 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:


Table Column Type Description
Stats_Batches Status Integer Open = 0, Completed = 1, AutoClosed = 2, ManuallyClosed = 3, ManuallyDeleted = 4, AutoDeleted = 5, Archived = 6, Exported = 7, Imported = 8
Stats_Batches IsLocal Boolean Indicates whether the batch was generated from a Local document type or a Shared document type (setting on Step 1 of Document Type Configuration)
Stats_BatchHistory ModuleCloseType Integer Suspended = 0, Closed = 1, ClosedOpenedInNextModule = 2, Rejected = 3
Stats_BatchHistory ModuleStatType Integer CaptureStats = 0, QualityAssuranceStats = 1, IndexStats = 2, OCRStats = 3, MigrationStats = 4, ClassificationStats = 5


Entity Relationship Diagram

The following page contains the ERD for the Batch Manager database as generated by Sql Server Management Studio. A larger PNG version of this diagram can be downloaded by clicking here.




Keywords: Batch Manager Reporting



Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.