OR_EMMIE_TASK_STATUS

Description: |
This table stores the statuses of tasks performed by perioperative Emmie outreach workflows.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with this contact.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this contact.
4 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
5 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
6 | CM_CT_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
7 | TASK_COMP_STATUS_C_NAME | NUMERIC | No |
This item stores the completion status of a given task agent.
May contain organization-specific values: No
Category Entries:
Not Started
In Progress
Completed