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.