ORDER_MYC_RELEASE

Description: |
When a clinician (or interface) releases/unreleases a lab result to/from a web based chart system patient, tracking data for that action is stored in this table.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_PROC_ID | NUMERIC | No |
The unique ID of the procedure order record that is released/unreleased.
2 | LINE | INTEGER | No |
Since an order can be released/unreleased multiple times, the line number identifies a particular release instance.
3 | RELEASE_USER_ID | VARCHAR | No |
The ID of the Hyperspace user who released/unreleased the lab result to the web based chart system patient.
4 | RELEASE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | RELEASE_ACTION_C_NAME | VARCHAR | No |
This item indicates the action taken on the lab result. The data stored is a category value. 1 corresponds to Released. 2 corresponds to Unreleased. A null value also corresponds to Unreleased.
May contain organization-specific values: No
Category Entries:
Release
Unrelease
Prevent autorelease
6 | MYC_REL_UTC_DTTM | DATETIME (UTC) | No |
Contains the instant when a result was released to MyChart in UTC.