WKQUEUE_REVIEW

Description: |
This is the clarity table for Infection Control Workqueue functionality. It contains the review information for a result.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | WKQUEUE_TYPE_C_NAME | VARCHAR | No |
This stores user group of a workqueue. This is meant to be used in conjunction with the Workqueue Type parameter from Reporting Workbench reports from the Infection Control Find Results template.
May contain organization-specific values: Yes
Category Entries:
Infection Preventionist
Pharmacist
NHSN C. diff Reviewer
NHSN MRSA Reviewer
NHSN CephR-Klebsiella Reviewer
NHSN MSSA Reviewer
NHSN VRE Reviewer
NHSN CRE-E. coli Reviewer
NHSN CRE-Klebsiella Reviewer
NHSN MDR-Acinetobacter Reviewer
NHSN CRE-Enterobacter Reviewer
NHSN UTI Reviewer
NHSN CLABSI Reviewer
4 | WKQUEUE_REVIEW_TIME_DTTM | DATETIME (UTC) | No |
This stores the review instant for a result. This is the time at which a user clicked the "Reviewed" button from a Reporting Workbench Workqueue. Each instant is specific to the Workqueue Type and User ID.
5 | WKQUEUE_REV_USER_ID | VARCHAR | No |
The reviewer for a result. This is related to the review instant and the workqueue type.
6 | WKQUEUE_REV_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | WKQUEUE_REVIEW_C_NAME | VARCHAR | No |
This stores the review action for a result. This is the action a user took from a Reporting Workbench Workqueue.
May contain organization-specific values: Yes
Category Entries:
Review
Unreview
Permanent Review
8 | WKQUEUE_REASON_C_NAME | VARCHAR | No |
This stores a result review reason. This is the discrete reason a user documented while reviewing the result. Each reason is specific to a workqueue and user ID.
May contain organization-specific values: Yes
Category Entries:
Present on admission
Present on insertion
Does not meet NHSN criteria
Contaminant
Sent to Department of Health
Infection case created
9 | WKQUEUE_COMMENT | VARCHAR | No |
This column stores the free text result review comment. This is the comment a user documented while reviewing the result. Each comment is specific to a workqueue and user ID.