Prior to OnBase 18, the ARCHIVEDQUEUE table stores a record for every scanned batch. As of OnBase 18, the ARCHIVEDQUEUE table stores a record for every scanned batch that has not been committed. The ARCHIVEDQUEUE table is located in DBSpace10.
| Field | Data Type | Description |
|---|---|---|
| queuenum | bigint | Unique identifier of the scan queue that processed the batch. |
| queuename | char(25) | Name of scan queue that processed the batch. |
| batchname | char(200) | Name of the batch. |
| status | bigint | See Processing Table Status in Appendix A. |
| 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). |
| numberdocuments | bigint |
Number of documents originally belonging to the batch. |
| archiveflags | bigint | |
| bitmapnum | bigint | |
| iconnum | bigint | |
| lastusedplatter | bigint | |
| totalpages | bigint | |
| printeddate | datetime | |
| totaldocuments | bigint | |
| batchflags | bigint | |
| registernum | bigint |
The indexes for the ARCHIVEDQUEUE table are located in DBSpace10.
| Index Name | Included Columns |
|---|---|
| archivedqueue1 |
status, batchnum |
| archivedqueue2 |
batchnum, status |
| archivedqueue3 |
usernum |
| archivedqueue4 |
queuenum, status |
| archivedqueue5 |
queuenum, registernum |