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
Discharge Message only
Discharge Full prompt
Discharge Message and Don't Prescribe button
Discharge Message and Reconcile After Signing button
IFT Message only
IFT Full prompt
IFT Message and Don't Continue button
IFT 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
Multiple alerts
Patient is Review Not Required
Order 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 For Discharge
Don't Continue on Readmit
Reconcile After Signing For IFT