LOG TABLE ACTIONS - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 23.1
License

Prior to OnBase version 5.0, all activity was logged to the TRANSACTIONXLOG table. In OnBase version 5.0 and later, transactions are logged to multiple log tables. Document-related transactions are all stored in the OnBase TRANSACTIONXLOG table. The txlog.action column in the tables below lists the action from the TRANSACTIONXLOG for versions prior to 5.0 for historical reporting purposes.

ADMINLOG Table
Log Message txlog.action actionnum subactionnum

Exception Report Created

16386

1 1

Configuration Report Created

16387

1 2

Keyset Usage Report Created

16388

1 3

Document History Report Created

16389

1 4

Transaction Log Report Created

16390

1 5

Email Audit Log Report Created

  1 6

Folder History Report Created

  1 7

Records Mgmt Report Created

  1 8

Create Keyword List Report

  1 9

Purged Transaction Log

4194304 2 1

Transaction Log Viewed

4194305 2 2

Purged Workflow Log

4194308 2 3

Removed Process Lock

69 2 4

Performed a Full Text Index Search

32774 3 1

Started an Export

32772 3 2

Started an Import

32773 3 3

Terminal Emulation

32768 3 4

Removed Lock

  3 5

Verity Search

  3 6

Delete Folders

  3 7

Delete Orphan Folders

  3 8

Purged Document

  3 9

Performed a Full-Text Search

  3 11

Create Full-Text Catalog

  3 12

Add Document Types for Full-Text Processing

  3 14

Successfully created Test System

  4 1

Successfully create Stand Alone Test System

  4 2

Successfully Migrated Test System Back to Production

  4 3

Unlinked Test System from Production

  4 4

Test Migration to Production

  4 5

Copied System Docs to Test

  4 6

Unable to Migrate or Unlink – Mismatched GUIDs

  4 7

Unable to Migrate – Mismatched Database Version

  4 8

Unable to Migrate – Mismatched IDs

  4 9

Error when Migrating System Docs

  4 10

Unable to Migrate back to Prod

  4 11

Unable to Migrate – Mismatched DB

  4 12

Error Creating Test System

  4 13

Force database upgrade on login

  4 14
CBLOG Table
Log Message actionnum subactionnum

Viewed Threads

1 1

Viewed Post

1 2

Created Post

1 3

Subscribed to Notifications

1 4

Unsubscribed from Notifications

1 5

Created Workspace

2 1

Created Workspace from Template

2 2

Activated Workspace

2 3

Deactivated Workspace

2 4

Viewed Workspace

2 5

Added Document

3 1

Removed Document

3 2

Added Object

3 3

Removed Object

3 4

Posted to Workspace

3 5

Added User to Workspace

4 1

Removed User from Workspace

4 2

Added User to Thread

4 3

Removed User from Thread

4 4

Added User to Template

4 5

Removed User from Template

4 6

Added User Group to Thread

4 7

Removed User Group from Thread

4 8

Created Template

5 1

Changed Template Settings

5 2

Changed Template Defaults

5 3

Viewed Attributes

6 1

Added Attribute

6 2

Deleted Attribute

6 3

Searched Workspaces

7 1

Viewed Meeting

8 1

Joined Meeting

8 2

Closed Meeting

8 3

Started Meeting

8 4

Created Meeting

8 5

Added External User to Meeting

8 6

Added OnBase User to Meeting

8 7

Meeting Organizer Assigned

8 8
CONFIGLOG Table
Log Message actionnum subactionnum

Scan Format Modified

1 1

Created new entry

1 2

Updated entry

1 3

Deleted entry

1 4

Accessed Dialog

1 5

Added entry

1 6

Removed entry

1 7

Cancelled creation of new entry

1 8

Entered dialog

1 9

User Group Created

1 10

User Settings Updated

1 11

Changed Configuration Item (Unity Scripts)

2 1

Changed Connection String (Unity Scripts)

2 2

Changed Imported Assembly (Unity Scripts)

2 3

Changed Unity Project (Unity Scripts)

2 4

Changed Unity Project Settings (Unity Scripts)

2 5

Changed Unity Integration

3 1

Changed Unity Integration Settings

3 2

User added to Role

4 1

User removed from Role

4 2

Retention Type Changed

6 1

Retention Date Option Changed

6 2

Rention Period Changed

6 3

Retention Type Changed by External System

6 4

Retention Date Option Changed by External System

6 5

Retention Period Changed by External System

6 6

User Group removed from Combined View

8 1

User Group removed from Combined View Tab

8 2

User Group added to Combined View

8 3

User Group added to Combined View tab

8 4
DOCDISTLOG Table
Log Message txlog.action actionnum subactionnum

Statement Generation

4096 1 9

Statement Mailed

4097 1 2

Statement Faxed

4098 1 3

Statement Published

4099 1 4

Statement Rendered

4100 1 5

Created Document Distribution Recipient

25 3 1

Deleted Document Distribution Recipient

67 3 2

Modified Document Distribution Recipient

130 3 3
LBDECISIONINGLOG Table
Log Message actionnum

Lockbox Keyword Change

0

Lockbox Transaction Status

1

Lockbox Batch Submitted

2

Lockbox Initial Email

3

Lockbox Escalation Email

4

Lockbox Cutoff Email

5

Lockbox End of Day Email

6
Log Message actionnum subactionnum

IMS Lockbox User Logged In

1 1

IMS Lockbox User Logged Out

1 2

IMS Lockbox Document Search

1 3

IMS Lockbox Document Viewed

1 4

IMS Lockbox Batch Search

1 5

IMS Lockbox Deposit Search

1 6

IMS Lockbox Pocket Search

1 7

IMS Lockbox Report Search

1 8

IMS Lockbox Report Document Viewed

1 9

IMS Lockbox User Group Created

2 1

IMS Lockbox User Group Privileges Modified

2 2

IMS Lockbox User Group Name Modified

2 3

IMS Lockbox User Group Deleted

2 4

IMS Lockbox Assigned to User Group

2 5

IMS Lockbox Notification Created

2 6

IMS Lockbox Notification Modified

2 7

IMS Lockbox Notification Deleted

2 8

IMS Lockbox User Created

3 1

IMS Lockbox User Deleted

3 2

IMS Lockbox Password Modified

3 3

IMS Lockbox Admin Password Modified

3 4

IMS Lockbox User Name Modified

3 5

IMS Lockbox Display Name Modified

3 6

IMS Lockbox User Email Modified

3 7

IMS Lockbox User to Group

3 8

IMS Lockbox Group to User

3 9

IMS Lockbox Unlock Disabled User

3 10
PLTRMGMTLOG Table
Log Message txlog.action actionnum subactionnum

Critical Platter Management Error

8193 1 1

Platter Management Failure

8194 1 2

Platter Management Failure with Confirm

8195 1 3

Platter Management Warning

8196 1 4

Platter Management Warning with Confirm

8197 1 5

Platter Management Confirm

8198 1 6

Platter Management Commit Failure

  1 7

Platter Management

8192 2 1

Platter Deleted

  2 2

Platter Analyzed

  2 3

Platter Copied

  2 4

Platter Moved

  2 5

Platter Backed Up

  2 6

Platter Exported

  2 7

Platter Automatically Backed Up

  2 8

Platter Automatically Exported

  2 9

Platter Automatically Deleted

  2 10

Platter Automatically Analyzed

  2 11

Prompt for Platter Mount

  2 12

Force Promote Disk Group

  2 14

Check File Access Verification

  2 18
PROCESSINGLOG Table
Log Message txlog.action actionnum subactionnum

Committed Batch

65536 1 1

Purged Data

65537 1 2

Archived Data

65538 1 3

Batch OCR’ed

65539 1 4

Indices Extracted from a Batch

65540 1 5

Batch Re-dated

65541 1 6

Batch Full Text Indexed

65542 1 7

Daily Report Cleared

65543 1 8

Batch Renamed

65545 1 9

Processed Format

2097152 1 10

Created Batch

20 1 11

Auto Folder Documents

  1 12

Batch Zonal OCR

  1 13

Ran an All Items Process

2097153 2 1

Ran a Repass Process

2097154 2 2

Purged the Daily and All Items Table

2097155 2 3

Executed Autofill Keyset Importer

32770 3 1

Unable to Create Batch or Verification Report

  3 2

Failed to Create Lockbox DCN File

  4 1
RIMLOG Table
Log Message actionnum subactionnum

Open Event Posted

1 1

Close Event Posted

1 2

Cutoff Event Posted

1 3

Managed Folder Created

2 1

Folder Opened

2 2

Folder Closed

2 3

Folder Cut Off

2 4

Folder Transitioned to Awaiting Approval

2 5

Folder Destroyed

2 6

Folder Purged

2 7

Folder Retained

2 8

Folder Deleted

2 9

Hold Placed

3 1

Hold Removed

3 2

Approved for Final Disposition

4 1

Retention Plan Changed

4 2

Cannot acquire Time Stamp Digital Signature License

5 1

Keyword Added to Document

6 1

Keyword Removed from Document

6 2

Keyword Added to Folder

6 3

Keyword Removed from Folder

6 4

Document Added

7 1

Document Removed

7 2

Document Removed/Folder Deleted

7 3
ROIREQUESTLOG Table
Log Message actionnum subactionnum

ROI Request Created

1 1

ROI Request Deleted

1 2

ROI Request Viewed

1 3

ROI Document Added

2 1

ROI Document Removed

2 2

ROI Print Bill

3 1

ROI Print Request

3 2

ROI Export Request

3 3

ROI Export Request - Condre

3 4

ROI Export Request - Rimage

3 5

ROI Fax Request

3 6

ROI Forward Request

3 7

ROI Mail Request

3 8

ROI Mail Request - Express

3 9

ROI Mail Request - Office

3 10
SECURITYLOG Table
Log Message txlog.action actionnum subactionnum

Logged into Client Module

131072

1 1

Logged into Configuration Module

131073 1 2

Logged into Print Server

131076

1 3

Logged into Search Server

131077

1 4

Logged into Enterprise Server Communication

131081 1 5

Logged into OBAPI

131082

1 6

Login Failure

131083

1 7

License Overage

131086

1 8

Logged into Core Services

  1 9
Logged into Disconnected Scanning   1 10

Logged into Front Office Scanning

  1 11
Logged into HTML Web Client   1 12

Logged into ActiveX Web Client

  1 13

Logged into Studio

  1 14

Logged into Unity Client

  1 15

Logged into Unity Management Console

  1 16

Logged into Unity API

  1 17
Logged into Unity Scheduler   1 18

Logged into Web Server Pop Integration

  1 20

Logged into Workflow Pop Integration

  1 21

Logged into Web Server Shared Form

  1 24
Logged into Reporting Viewer   1 28

The maximum number of API queries exceeded

32775

2 1

API cannot acquire concurrent license

131084

2 2
API cannot acquire named license 131085 2 3

Out of Email Archiver Licenses

  2 4
Out of Workstation Licenses   2 5
Assigned Named User Client License   2 7

Unassigned Named User Client License

  2 8

Registered License to Workstation

  2 9

Deregistered License from Workstation

  2 10

License Sync

  2 15

Logged out of Client Module

262144 3 1

Logged out of Configuration Module

262145

3 2
Logged out of Print Server

262148

3 3

Logged out of Search Server

262149 3 4
Logged out of Enterprise Server Communication 262153 3 5

Logged out of OBAPI

262154 3 6

Logged out of Core Services

  3 7
Logged out of HTML Web Client   3 12

Logged out of ActiveX Web Client

  3 13

Logged out of Studio

  3 14

Logged out of Unity Client

  3 15

Logged out of Unity Management Console

  3 16

Logged out of Unity API

  3 17

Logged out of Unity Scheduler

  3 18
Logged out of Web Server Pop Integration   3 20
Logged out of Workflow Pop Integration   3 21
Logged out of Web Server Shared Form   3 24

Logged out of Reporting Viewer

  3 28

Invalid Active Session

  3 29

Changed User Privileges

524289

4 1
Changed User Password 524290 4 2

Changed User Products

524291

4 3

Updated Product Licenses

524292 4 4
Validated Product Licenses 524293 4 5

Created New User

524294

4 6
Deleted User 524295 4 7

Global License Agreement Accepted

524296

4 8

Envelope Shared

  4 9
Protected Life Cycle   4 10
Add user to User Group   4 12
Remove user from User Group   4 13
Account Manually Locked   4 14
Account Manually Unlocked   4 15
Create/Delete Unity Script Connection   4 22

Workflow access violation, no rights to queue

  5 1
SYSTEMLOG Table
Log Message txlog.action actionnum subactionnum

Automated CD Server Connection Attempt

32769

1 1
Updated Database Version

524288

2 1
Database Backup

33554432

2 2

Enterprise Server Communication Message

1048576

2 3
Assigned System ID   2 5

Email Archiver Start up

  3 1
Email Archiver Shut Down   3 2
API Core Session Script   4 1
API Core Document Script   4 2
Copy to Secondary Disk Group(s) Failed   4 3
Archived Document Not Added to SAP – No Document Type Mapping   5 1
Autofill Process Updated Document   6 1

Keyword Merge

  6 2

Application Server Cache Reset

  7 1
TRANSACTIONXLOG Table
Log Message txlog.action actionnum subactionnum

Created Document

16 1 1
Created Document from Existing 24 1 2
Deleted Document 64 1 3

Deleted Un-indexed Document

70 1 4
Undeleted Document 2052 1 5
List Content Report Created 16384 1 6
Search Result Report Created 16385 1 7

Document Destroyed by Records Management

  1 8

Uploaded to CIC

  1 9

Returned from CIC

  1 10
Uploaded to DocuSign   1 11

Returned from DocuSign

  1 12

Document Separation

  1 13

Document Packet Created

  1 14

Created Folder

17 2 1

Viewed Folder

33 2 2

Viewed Folder Keywords

36 2 3

Deleted Folder

65 2 4
Added an item to a Folder 512 2 5
Removed an Item from a Folder 513 2 6
Added an Item to a Managed Folder 514 2 7

Modify Folder Keywords

  2 8
Viewed Folder and Children   2 9
Failed to Update Child Folder Keywords   2 10

Folder Purged

  2 11

Folder Moved

  2 12

Folder Copied

  2 13

Folder Keyword Deleted

  2 14

Folder Keyword Added

  2 15

Folder Modified Date

  2 16

Folder Undeleted

  2 17

Sealed Folder

  2 18

Unsealed Folder

  2 19
Added an Item to a Folder   2 20
Removed an Item from a Folder   2 21
Added an Item to a Managed Folder   2 22

Folder Keyword Auto-Update Failure

  2 23
Removed Orphan Folder   2 24

Modified Folder Contents Keyword

  2 25

Created Note

18 3 1
Viewed Note 34 3 2

Deleted Note

66 3 3
Modified Note 128 3 4

Unity Note Retrieved

  3 5
Viewed All Notes   3 6

Viewed Document

32 4 1
Printed a Document 1025 4 2
Mailed a Document 1026 4 3

Document Re-indexed

1036 4 4
Checked Out Document 2049 4 5
Checked In Document 2050 4 6
Cancelled Check Out 2051 4 7

Created Document Revision

21 4 8
Created Document Rendition 22 4 9

Deleted Revision

68 4 10

Burn Redaction Bitmaps

2055 4 11
Unique Barcode Match – Page appended 2056 4 12

Dropped Page into Document

1030 4 13
Dragged Page from Document 1031 4 14

Document Rotation Saved

1038 4 15

Added Page to Document

2062 4 16
Modify Document Date 1039 4 17
Modified Document FileType 2057 4 18
Document Password 1028 4 19

Document Version Overwritten

  4 22

Append Imported Image

  4 23

Document Field Modified

  4 24

Unity API Retrieved Document

  4 25

Viewed Document Thumbnail

  4 26

Keyword/Bar code match - entire document appended to existing document

  4 27
Mailed a Document as a Link   4 28

Scanned More Pages

  4 29

Reordered Pages

  4 30

Printed Document Thumbnail

  4 31

Volume Changed

  4 32
Burn Redaction Notes   4 33
Page Added to Document   4 34
Signature added to document   4 35

Reordered Pages

  4 36
Rescanned Page   4 37
Marked Page for Rescan   4 38
Marked Document for Rescan   4 39

Marked Document for Manager Resolution

  4 40

Marked Document for QA Re-Index

  4 41

Document Received Manager OK

  4 42

Document Received QA Review OK

  4 43

Marked for Additional Pages After Page

  4 44

Page Rotated

  4 45
Page Flipped   4 46

Modified Markup Layer

  4 47
Append Imported Image from File   4 48

Append Imported Image from Scan

  4 49

Undo

(undo indexing action)

  4 50
Marked Document for QA Review   4 51

Deleted Markup Layer

(not used)

  4 52

VNA Page Added (deprecated)

  4 53
Rendition Overwritten   4 54
Un-Marked Page Rescan   4 55

Un-Marked Scan Additional Pages (Before)

  4 56

Un-Marked Scan Additional Pages (After)

  4 57

Document Included In Document Packet

  4 58
Geolocation Added To Document   4 59
Text Encoding Saved   4 60

Rendition Deleted for File Type on Document

  4 61
Co-authored Document Changes   4 62
Indexed Document (document indexed in Index)   4 63

Re-Indexed Document (document re-indexed in Re-Index)

  4 64
Re-Indexed Document (document re-indexed in QA Re-Index)   4 65

Indexed Document (document indexed in Secondary Index)

  4 66

Accessed Content

  4 67

Viewed Document Keywords

35 5 1
Keyword Update – Doc Type 1032 5 3
Keyword Update – Global 1033 5 4

Deleted Keyword

1034 5 5

Deleted Document Keyword

1034 5 5
Add Keyword 1035 5 6

Add Document Keyword

1035 5 6
Unity API Retrieved Keyword   5 7
User has viewed unmasked secure Keywords   5 8

Created Document Redaction

23 6 1

Exported a Document

1027 6 2

Copied to Clipboard

2048 6 3
Added Electronic Signature 2053 6 4

Removed Electronic Signature

2054 6 5
Document Full Text Indexed 1037 6 6

Document added to Verity Full Text

2059 6 7
Document Removed for Verity Full Text 2060 6 8

Document OCR’ed

2061 6 9

Added Reference Document

8388608 6 10
Added to workspace 8388609 6 11
Removed from workspace 8388610 6 12

Added Post

8388611 6 13
Pages Copied to new Document 2058 6 14

Removed an item for Document Retention

67108865 6 15

Put item back into Document Retention

67108866 6 16

Digital Signatures Activity

  6 17
DKT Administrator Acknowledgement   6 18

Verify Digital Signature

  6 19

Add Time Stamp Digital Signature

  6 20
Verify Time Stamp Digital Signature   6 21

Export Document for External Verification

  6 22

Time Stamp Error

  6 23

Remove DKT User Reading Requirement

  6 24

Document Retention Re-index

  6 25

Document Retention Delete

  6 26

Cannot acquire Time Stamp Digital Signature License

  6 27

Cannot acquire Time Stamp Digital Signature License

  6 28
Viewed Document via Data Mining   6 29

Extracted Document via Data Mining

  6 30
Printed Document via Data Mining   6 31

Encryption

  6 33
Document added to case   6 34
Document Added to Envelope   6 35
Document Removed from Envelope   6 36

All Documents Removed from Envelope

  6 37
Sent Cavion Statement Notification   6 38

Sent Cavion Notice Notification

  6 39

Document Published to Message Broker

  6 40
Message Broker Processed the Response   6 41

Message Broker response Data Error

  6 42
Message Broker response System Error   6 43
Saved file locally   6 44

Destroyed by Doc Retention

  6 45

Purged by Doc Retention

  6 46
Declared Certified Record   6 47
Document removed from case   6 48

Document sent to CSV file

  6 49

Doc Retention Status Updated

  6 50

Marked for Purging

  6 51

Evaluated by Doc Retention

  6 52

Database records created

  6 53

File moved to Diskgroup

  6 54

S3 File Repaired

  6 55

Printed Substitute Check

2063 7 1

View IRD

  7 2
Marked for Return   7 3

View MICR

  7 4

Physical Record Changed Repository

  8 1

Physical Record Changed Location

  8 2
Physical Record Checked In   8 3

Physical Record Checked Out

  8 4

Physical Record Copied from Repository

  8 5
Changed Check Out Location of Physical Record   8 6

Requested Physical Record

  8 7
Volume Tracking Locator Modified   9 1

Volume Tracking Locator Home Modified

  9 2
Volume Tracking Locator Patient Modified   9 3
Volume Tracking Locator Chart Linked   9 4
Volume Tracking Locator Chart Unlinked   9 5

Document was taken offline

  10 1
Document was removed from offline   10 2
Document was updated.   10 3
A new document was created   10 4

Sync started

  10 5

Sync completed

  10 6

Sync failed

  10 7
A note was added to the document   10 8

A note was removed to the document

  10 9

A note was modified on the document

  10 10

Notes collection was changed

  10 11
Keywords were modified on the document   10 12

Field application was locked

  10 13

Keyword data set for field application was synced

  10 14

Custom Document Log Via Unity

  11 1
Custom Note Log Via Unity   11 2
Custom Folder Log Via Unity   11 3

Document synced up from Mobile device

  12 1

New note synced up from Mobile device

  12 2
Modified note synced up from Mobile device   12 3

Update note properties synced up from Mobile device

  12 4

Deleted note syncd up from Mobile device

  12 5

(ScanStep EIS Export)

  13 1

Document registered with XDS registry

  14 1
Document retrieved by XDS consumer   14 2

Document sent using XDR to an endpoint

  14 3
Document received from XDR Document Source   14 4

(Document Created via FHIR)

  15 1

(Document Updated via FHIR)

  15 2

(Document Retrieved via FHIR)

  15 3

(Document Deleted via FHIR)

  15 4
WFUSEREVENTS
Log Message txlog.action actionnum subactionnum
User Open Workflow Inbox 32771 2 1
System Task Executed by Classic Workflow Engine   4 2