The CHARTQUEUETXLOG table is a logging table that stores log entries for each queue or “context” to which the chart has been routed within Medical Records. The CHARTQUEUETXLOG table is located in DBSpace10.
| Column Name | Data Type | Description |
|---|---|---|
| chtqueuetxnum | bigint |
The internal unique identifier of the log entry. |
| chtnum | bigint | The internal unique identifier of a chart object; a foreign key to the CHART table. |
| chtqueuetype | bigint | Indicates the type of queue associated with the log entry. 1 = Coding, 2 = Analysis, 3 = Completion, 4 = Reanalysis, 101 = QA Coding, 102 = QA Analysis, 104 = QA Reanalysis. |
| availabletime | datetime |
The date and time the chart associated with the log became available for the associated queue. |
| entrytime | datetime | The date and time the chart associated with the log was assigned to a user with access to the queue. |
| exittime | datetime |
The date and time the assigned user transitioned/completed the chart associated with the log out of the queue. |
| usernum | bigint |
The internal unique identifier of the user assigned to the chart in the queue associated with the log entry. |
| flags | bigint | Not implemented. |
The indexes for the CHARTQUEUETXLOG table are located in DBSpace10.
| Index Name | Included Columns |
|---|---|
| chartqueuetxlog1 | chtqueuetxnum |
| chartqueuetxlog2 | chtnum |
| chartqueuetxlog3 | chtqueuetype, chtnum |