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