HH_MED_ORD_EVENTS

Description: |
This table will store Home Health medication order event details.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_MED_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 | MED_ORDER_EVENT_TYPE_C_NAME | VARCHAR | No |
This item stores the event that happens for a medication order that has been added to or removed from the Home Health Plan of Care.
May contain organization-specific values: No
Category Entries:
Included in POC
Not Included in POC
Sent POC Update (Included)
Sent POC Update (Not Included)
4 | MED_ORDER_EVENT_USER_ID | VARCHAR | No |
This item stores the user associated with the event that happens for a medication order that has been added to or removed from the Home Health Plan of Care.
5 | MED_ORDER_EVENT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | MED_ORDER_EVENT_UTC_DTTM | DATETIME (UTC) | No |
This item stores the instant when an event happens for a medication order that has been added to or removed from the Home Health Plan of Care.
7 | MED_ORDER_EVENT_CSN | NUMERIC | No |
This item stores the contact serial number (CSN) associated with the medication update encounter that results in an event for medication orders that have been added to or removed from the Home Health Plan of Care.
8 | MED_ORDER_COMMENT_NOTE_ID | VARCHAR | No |
This item stores the ID of the note that stores the comment associated with the event that happens for medication orders that have been added to or removed from the Home Health Plan of Care.