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
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.