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.