The ROIREQUESTLOG table is the main logging table used for Release of Information.
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.
Index Name | Indexed Columns |
---|---|
roirequestlog1 | logdate, roirequestnum, actionnum |
roirequestlog2 | usernum, logdate, actionnum |