ALERT

Description:

The ALERT table contains one record for every alert that was created in Hyperspace. Each record is based on the alert ID and contains key information about the alert such as the patient, patient CSN, alert type, and whether it was seen by a user.

Primary Key

Column Name	Ordinal Position
ALT_ID	1

Column Information

	Name	Type	Discontinued?
1	ALT_ID	NUMERIC	No
	The unique identifier for the alert.
2	ALERT_DESC	VARCHAR	No
	A brief description of the alert.
3	PAT_ID	VARCHAR	No
	The unique patient ID of the patient for whom the alert fired. You could link it to PATIENT.PAT_ID to get patient specific information.
4	PAT_CSN	NUMERIC	No
	The contact serial number for the patient encounter in which the alert was fired. This number is unique across all patients and encounters in your system. If alerts are triggered in a patient-specific encounter, they are saved in a corresponding encounter. This can be used to join to PAT_ENC.PAT_ENC_CSN_ID to get the encounter information.
5	PUMP_ID	VARCHAR	No
	The unique external device ID of the pump selected in response to the warning after trying to program the pump.
6	PUMP_ID_DEVICE_NAME	VARCHAR	No
	The name for this device.
7	MAR_ACTION_C_NAME	VARCHAR	No
	The MAR action category ID selected in response to the warning after trying to program the pump. May contain organization-specific values: Yes Category Entries: Given Missed Refused Canceled Entry Held New Bag Restarted Stopped Rate Change MAR Hold MAR Unhold Bolus Push Rate Verify See Alternative Paused Prepared Pending Automatically Held Due
8	MED_ALERT_SUBTYPE_C_NAME	VARCHAR	No
	Subtype of medication alert type. This is currently used only for alerts of type 23 - Error while checking interactions May contain organization-specific values: No Category Entries: Too Many Warnings Too Many Orders API No Results No interaction data Mismatched Patient in Ordering Session Too Many Signed and Held Orders - Checking Limited Too Many Signed and Held Orders - Checking Suspended
9	NBA_LOCATOR_ID	NUMERIC	No
	The ID of the action record correlated with this next best action event.
10	NBA_GUARANTOR_ACCT_ID	NUMERIC	No
	The guarantor account correlated with this next best action event.
11	NBA_PROSPECT_RECORD_ID	NUMERIC	No
	The prospective patient correlated with this next best action event.
12	BLOOD_ALERT_BUCKET_C_NAME	VARCHAR	No
	The blood alert bucket category ID for the alert. May contain organization-specific values: No Category Entries: No Blood Bank Information No Blood Bank for this Patient Blood Bank Info for this Patient Multiple Patients for Same Unit Linked Already Wrong Patient Bad Status
13	RECORD_STATUS_C_NAME	VARCHAR	No
	This column contains a record status flag of soft deleted, hidden, or hidden and soft deleted. Use it in conjunction with the record archived flag (REC_ARCHIVED_YN) for encounter archiving. May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
14	EXPECTED_WKFL_ACTVTIES_C_NAME	VARCHAR	No
	The activity which triggered the warning. Only used when the warning type is Expected Workflow Step Not Complete. May contain organization-specific values: No Category Entries: Dispense Preparation Dispense Check Dispense Tracking MAR Home Infusion Shipment Manager Home Infusion Shipment Dashboard