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 |