RX_INTERVENTION

Description: |
The interventions table contains one record for each intervention recorded in your system. Items included are: status, significance, time spent, value, response, associated patient and CSN, associated order, creating user, associated pharmacy, instant created, and instant closed.
Not all of these items will be associated with every intervention. The primary key for the interventions table is INTERVENTION_ID.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INTERVENTION_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INTERVENTION_ID | NUMERIC | No |
A unique ID for the intervention.
2 | STATUS_C_NAME | VARCHAR | No |
The open/closed status of the intervention. Status values =2 or >=2000 are closed, other status values are open.
May contain organization-specific values: Yes
Category Entries:
Open
Closed
3 | SIGNIFICANCE_C_NAME | VARCHAR | No |
The documented significance of the intervention.
May contain organization-specific values: Yes
4 | RESPONSE_C_NAME | VARCHAR | No |
Response documented by the user in the intervention.
May contain organization-specific values: Yes
5 | PATIENT_ID | VARCHAR | No |
The patient (if any) associated with this intervention. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
6 | PATIENT_CSN_ID | NUMERIC | No |
A unique serial number for this encounter, if this intervention is associated with a patient. This number is unique across all patients and encounters in the system.
7 | CREATED_BY_USER_ID | VARCHAR | No |
The user (EMP) ID of the user who created this intervention.
8 | CREATED_BY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | PHARMACY_ID | NUMERIC | No |
The ID of the pharmacy (if any) associated with this intervention. This will be the log-in pharmacy of the department the user who created the intervention was logged into.
10 | PHARMACY_ID_PHARMACY_NAME | VARCHAR | No |
The name of the pharmacy.
11 | INSTANT_CREATED | DATETIME (Local) | No |
The date and time that this intervention was created in calendar format.
12 | INSTANT_CLOSED | DATETIME (Local) | No |
The date and time (if any) that this intervention was closed in calendar format.
13 | NAME | VARCHAR | No |
The record name for this intervention record. An intervention is a specific task scheduled to be completed by a clinician to relieve a patient's health problem.
14 | DEFERRAL_YN | VARCHAR | No |
Indicates whether this intervention is a scoring system deferral. 'Y' indicates that it is a scoring system deferral. 'N' indicates that is not a scoring system deferral. An intervention is a specific task scheduled to be completed by a clinician to relieve a patient's health problem. A scoring system is used in conjunction with rules to assign a value to a particular patient or event. For example, they can be used to assign an acuity score to patient or calculate future charges. Clinicians can defer them, indicating they will fill out the scoring system at a later time.
May contain organization-specific values: No
Category Entries:
No
Yes
15 | MED_RULE_ID | NUMERIC | No |
The unique ID for the medication rule associated with the deferral.
16 | MED_RULE_ID_MED_RULE_NAME | VARCHAR | No |
The name of the alert rule which contains the name of the drug with which the alert is associated with.