|
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. |
|
|
