IP_ORDER_REC
Description:
This table contains Inpatient order reconciliation information.

Primary Key
Column Name Ordinal Position
EVENT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 EVENT_ID VARCHAR No
The unique ID of 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 TAKING_BEF_ADM_C_NAME VARCHAR No
Indicates whether a medication was taken within 24 hours of admission.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
4 ORDREC_SORT_POC_C_NAME VARCHAR No
This is the Phase of Care that indicates when this action should take place.
May contain organization-specific values: Yes
5 IP_ORDREC_REV_HRS FLOAT No
The number of hours after a completed transfer event that the review not needed status for One Step Order Reconciliation orders is valid.
6 IP_ORDREC_REV_EXP_DTTM DATETIME (UTC) No
The time at which the review not needed status for One Step Order Reconciliation orders expires.
7 DISCONTINUE_NOTE VARCHAR No
If the reconciliation action (I IEV 1020) indicates a discontinue, this item indicates the note for discontinuation (if one was specified by the user).
8 ORDER_REC_HOLD_ACTION_C_NAME VARCHAR No
The provider hold action (hold or unhold) for this action line, if applicable.
May contain organization-specific values: No
Category Entries:
Hold
Unhold
9 HOLD_INFO_LINE_NUMBER INTEGER No
The line number in the order record that contains additional hold information for this order reconciliation action, if applicable. The values in this column can be linked to the LINE column in the ORDER_HOLD_INFO table.
10 ORD_REC_ACT_BUTTON_C_NAME VARCHAR No
The action button category ID for the button used to take this action. This is used to distinguish cases when multiple different buttons can produce the same action in REC_ACTION_C. Currently, this is only populated for actions taken in Transfer Medication Reconciliation.
May contain organization-specific values: No
Category Entries:
Order
Substitute
Don't Order
Discontinue
Continue
Modify Inpatient
Prescribe
Don't Prescribe
Resume
Stop Taking
Sign
Sign & Hold
No Change
Modify Outpatient
Modify as FAM
Prescribe as CAM
Reorder
Don't Continue
Continue in Recovery
New
Prescribe Expired Long Term
No Change Expired Long Term
Stop Taking Expired Long Term
Discontinue Sign & Hold
Review Not Required
Resume Expired Long Term
Let Expire
Continue Paused
Resume Paused Order
Renew
Hold
Continue Hold
Unhold
Order and Hold
Discontinue Inpatient
Continue and Modify
Continue Hold and Modify
Continue And Unhold CAM
Order and Hold Inpatient
Don't Order Inpatient