The OnBase PROCESSINGLOG table stores information related to various import processes and batches (e.g., batch committed, batch purged). The PROCESSINGLOG table is located in DBSpace1.
| Column Name | Date Type | Description |
|---|---|---|
| processinglognum | bigint | |
| usernum | bigint |
The unique identifier of the OnBase user who performed the logged action (cross-referenced to USERACCOUNT). |
| registernum | bigint |
The unique identifier of the workstation from which the action was performed (cross-referenced to REGISTEREDUSERS). |
| logdate | datetime | The date the transaction was logged. |
| messagetext | char(200) | Text message describing the transaction. |
| actionnum | bigint | See Log Table Actions in Appendix A. |
| subactionnum | bigint | |
| severityflag | bigint | |
| batchnum | bigint |
The unique identifier of the batch (cross-referenced to ARCHIVEDQUEUE or PARSEDQUEUE). |
| parsefilenum | bigint | |
| verifyitemnum | bigint | The Document Handle of the Verification Report for the batch (document will not exist if the batch has been purged). |
| extrainfo1 | bigint | |
| tracelvl | bigint | |
| isacknowledged | bigint |
The indexes for the PROCESSINGLOG table are located in DBSpace1.
| Index Name | Included Columns |
|---|---|
| processinglog1 | logdate |
| processinglog2 | batchnum |
| procesisnglog3 | parsefilenum, logdate |
| processinglog4 | severityflag, logdate |