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