PROCESSINGLOG - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

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.

PROCESSINGLOG Table Values
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.

PROCESSINGLOG Indexes
Index Name Included Columns
processinglog1 logdate
processinglog2 batchnum
procesisnglog3 parsefilenum, logdate
processinglog4 severityflag, logdate