Starting with OnBase 18, the ARCHIVEDCOMMITQ table stores a record for every committed batch. The ARCHIVEDCOMMITQ table is located in DBSpace10.
Note: If you are upgrading from a version of OnBase prior to 18 and
you use the ARCHIVEDQUEUE table for reporting purposes, you may
need to update your reporting to use the ARCHIVEDCOMMITQ table.
ARCHIVEDQUEUE will continue to store records for batches that
have not been committed, while ARCHIVEDCOMMITQ stores records for
batches that have been committed.
| Field | Data Type | Description |
|---|---|---|
| batchnum | bigint |
Unique batch number. |
| queuenum | bigint |
Unique identifier of the scan queue that processed the batch. |
| gueuename | char(25) | Name of scan queue that processed the batch. |
| batchname | char(200) |
Name of the batch. |
| tmpdiskgroupnum | bigint | |
| tmplogicalplttrnum | bigint | |
| diskgroupnum | bigint |
Unique Disk Group ID in which the batch is stored. |
| logicalplatternum | bigint |
Volume number of the Disk Group in which the batch is stored. |
| usernum | bigint | User who scanned the batch. |
| datestarted | datetime | Date and time the batch was created. |
| dateended | datetime |
Date and time the batch completed processing (batch transitions from queue to queue). |
| numberofdocuments | bigint |
Number of documents originally belonging to the batch. |
| archiveflags | bigint | |
| bitmapnum | bigint | |
| iconnum | bigint | |
| lastusedplatter | bigint | |
| totalpages | bigint | |
| printeddate | datetime | |
| totaldocuments | bigint | |
| commitdate | datetime |
The indexes for the ARCHIVEDCOMMITQ table are located in DBSpace10.
| Index Name | Included Columns |
|---|---|
| archivedcommitq1 |
commitdate |
| archivedcommitq2 | batchnum |
| archivedcommitq3 | batchnum |
| archivedcommitq4 | queuenum, batchnum |
| archivedcommitq5 |
queuenum, commitdate |
| archivedcommitq6 |
Commitdate, queuenum |