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

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

The ROIREQUESTLOG table is the main logging table used for Release of Information.

ROIREQUESTLOG Table Values
Column Name Data Type Data Length Description
roirequestlognum bigint 8 Unique id of the log record.
messagetext char 200 Text description of action taken by user.
actionnum bigint 8

Action taken by the user. Current values are:

1 - General actions

2 - Modify actions

3 - Delivery actions

subactionnum bigint 8 Secondary action number.
logdate datetime 8 Date/time of action.
usernum bigint 8 User performing action.
roirequestnum bigint 8 Request action was taken upon.
severityflag bigint 8 Severity of the action taken.
tracelvl bigint 8 Applied level of tracing.
extrainfo1 bigint 8 Available for extra info.
extrainfo2 bigint 8 Available for extra info.

The indexes for ROIREQUESTLOG table are located in DBSpace1.

ROIREQUESTLOG Table Indexes
Index Name Indexed Columns
roirequestlog1 logdate, roirequestnum, actionnum
roirequestlog2 usernum, logdate, actionnum