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_LOCATOR_NAME | VARCHAR | No |
The name of the Locator record.
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
15 | HM_TOPIC_ID | NUMERIC | No |
This column contains the ID of the Health Maintenance topic correlated with this alert record.
16 | HM_TOPIC_ID_NAME | VARCHAR | No |
The name of the health maintenance topic.
17 | SVV_LEAF_LPP_ID | NUMERIC | No |
Stores the Extension ID of the record that generated the Sign Visit Validation message, if the message came from an extension.
18 | SVV_LEAF_LPP_ID_LPP_NAME | VARCHAR | No |
The name of the extension.
19 | SVV_PROFILE_LPP_ID | NUMERIC | No |
Stores the Extension ID listed in the user's profile that resulted in this Sign Visit Validation message. This is only saved if it is different than the value in item 41000.
20 | SVV_PROFILE_LPP_ID_LPP_NAME | VARCHAR | No |
The name of the extension.
21 | SVV_RULE_ID | VARCHAR | No |
Stores the Rule (CER) ID if this Sign Visit Validation is based on a rule record.
22 | SVV_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.