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
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	NUMERIC	No
	The unique ID of the medication that is associated with this message from the pump.
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	NUMERIC	No
	The unique ID of the patient's department that is associated with this message from the pump.
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