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.