PUMP_PROGRAMMING

Description: |
This table contains compliance information about infusion pumps. The records included in this table are Alerts (ALT) records that track information about pump programming attempts.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ALERT_ID | NUMERIC | No |
The unique identifier (.1 item) for the med alert 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 | INF_ACTION_TAKEN_C_NAME | VARCHAR | No |
The category ID of the action taken by the user after getting the message from the pump.
May contain organization-specific values: No
Category Entries:
Apply HM Modifiers
Run Extension
Apply Care Plan Template
Task Template
Open SmartSet
Open Order Set
Send In Basket Message
Acknowledge/Override Warning
Discontinue Order
Cancel Warning
Remove Order
Barcode Scan
No Action Taken
Schedule Asynchronous
Single Order
Apply Contraindication
Cancel Fill
Place On-The-Fly Order
Open Pathway
Health Maintenance Override
Health Maintenance Postpone
Mark Result Critical
Cancel Dispense Preparation
Remove HM Modifiers
Patient FYI Flag
SmartData Element
Flag Result Message as Important
Accept Advisory (No Action Taken)
Cancel Advisory
Resend Message to Pump
Add Problem
Research Study
Questionnaire Series
Remove ERX single order
Remove EAP single order
Remove Study Medication Container
Link Study Medication Container
Activity Link
Inline Alert Warning
Care Path
Questionnaire
Use Partial Package
Add Diagnosis
Resolve Problem
Auto Launched Active Guidelines
Remove Order Set
Alert Becomes Not Applicable (Addressed Outside of Alert)
Replaced By New Version of Alert (Addressed Outside of Alert)
Alert Disappears (Addressed Outside of Alert)
Documentation Changed (Alert No Longer Applies)
Flowsheets
Outpatient Care Plan
Push Notification
Deferred
Deferred Advisory No Longer Applies
Instant Order
Discontinue Active Order
Pregnancy Status
Advance Beneficiary Notice
Local Coverage Determination
Generic Link
Best Care for My Patient
CDS Hooks System Action
Adjust Other Association
End Other Association
Delete Other Association
Update Association Time to Now
End Association
Add Community Resource Recommendation
Refill Protocol Evaluated
Give Feedback
Open Panel
Open Quick List
Open Express Lane
Viewing Treatment Plan
Viewing Therapy Plan
Viewing Treatment Protocol
Viewing Therapy Protocol
4 | INF_ERROR_TITLE | VARCHAR | No |
The title of the message from the pump that is displayed to the user.
5 | INF_ERROR_TEXT | VARCHAR | No |
The message text from the pump that is displayed to the user.
6 | INF_INT_STAT_C_NAME | VARCHAR | No |
The category ID of the status of the message from the pump.
May contain organization-specific values: No
Category Entries:
Waiting
Complete
7 | INF_SEND_INST_DTTM | DATETIME (UTC) | No |
The instant when the pump program was sent to the infusion pump.
8 | INF_RESPONSE_I_DTTM | DATETIME (UTC) | No |
The instant when the response was received from the infusion pump.
9 | INF_MED_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
10 | INF_ORDER_ID | NUMERIC | No |
The unique ID of the order that is associated with this message from the pump.
11 | INF_USER_ID | VARCHAR | No |
The unique ID of the user that is associated with this message from the pump. This column is frequently used to link to the CLARITY_EMP table.
12 | INF_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
13 | INF_DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
14 | INF_DEVICE_ID | VARCHAR | No |
The unique ID of the device that is associated with this message from the pump.
15 | INF_DEVICE_ID_DEVICE_NAME | VARCHAR | No |
The name for this device.
16 | INF_LINE_NUMBER | INTEGER | No |
The line number for the most recent prior message sent to the pump for the same order for the same patient encounter.
17 | VOLUME_TO_INFUSE_IN_ML | NUMERIC | No |
The volume to infuse in mL that was sent to the pump.
18 | INF_ATTEMPT_UTC_DTTM | DATETIME (UTC) | No |
Tracks the instant the user attempted to program the pump