ROIREQUESTTXLOG - 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

The ROIREQUESTTXLOG table is used to track the request's path through the Release of Information workflow.

ROIREQUESTTXLOG Table Values
Column Name Data Type Data Length  
roireqtxlognum bigint 8  
roirequestnum bigint 8  
priorstatus bigint 8  
newstatus bigint 8  
logdate datetype 8  
usernum bigint 8  
extrainfo1 bigint 8  
extrainfo2 bigint 8  

The indexes for ROIREQUESTTXLOG table are located in DBSpace1.

ROIREQUESTTXLOG Table Indexes
Index Name Indexed Columns
roirequesttxlog1 roirequestnum, logdate
roirequesttxlog2 usernum, logdate, priorstatus