IP_POST_MED_REC_ORDERS

Description:

This table stores inpatient medication orders that were signed and/or released after discharge medication reconciliation was already complete for that admission, along with information about whether and why the signing user was shown the Reconciliation on the Fly prompt and how they responded to it.

Primary Key

Column Name	Ordinal Position
EVENT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EVENT_ID	VARCHAR	No
	The unique identifier (.1 item) for the event 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	POST_REC_ORDER_ID	NUMERIC	No
	The unique ID of the order that was signed after discharge order reconciliation had been completed.
4	OTF_EVENT_LINE_NUM	INTEGER	No
	The line number of the event that was filed when this order was signed. Together with EVENT_ID, this forms the foreign key to the ED_IEV_EVENT_INFO table.
5	PROMPT_SHOWN_C_NAME	VARCHAR	No
	The category ID indicating whether the user was prompted to reconcile the order for discharge prior to signing it, and what options, if any, were present in that prompt. May contain organization-specific values: No Category Entries: Prompt not shown Message only Full prompt Message and Don't Prescribe button Message and Reconcile After Signing button
6	PROMPT_REASON_C_NAME	VARCHAR	No
	The category ID for the reason why the user wasn't shown the full prompt to reconcile this order for discharge. This is NULL if the user saw the full prompt. May contain organization-specific values: No Category Entries: Disabled in profile Disabled for ED Unsupported activity Criteria not currently met Manually disabled Patient is Review Not Required Medication is Review Not Required Route is Review Not Required Phase of Care is Review Not Required Set to message-only in profile No target navigator Similar discharge med found No target navigator and similar discharge med
7	PROMPT_RESPONSE_C_NAME	VARCHAR	No
	The category ID for the action, if any, that the user took on the prompt to reconcile this order for discharge. May contain organization-specific values: No Category Entries: Don't Prescribe Reconcile After Signing