The ROIREQUESTTXLOG table is used to track the request's path through the Release of Information workflow.
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.
Index Name | Indexed Columns |
---|---|
roirequesttxlog1 | roirequestnum, logdate |
roirequesttxlog2 | usernum, logdate, priorstatus |