INTERVENTION

Description:

This table contains data on intervention (LPI) records associated with a patient.

Primary Key

Column Name	Ordinal Position
INTERVENTION_ID	1

Column Information

	Name	Type	Discontinued?
1	INTERVENTION_ID	VARCHAR	No
	The unique ID for the intervention record.
2	DISPLAY_NAME	VARCHAR	No
	The display name for this intervention.
3	INTRV_TYPE_ID	VARCHAR	No
	The type of this intervention.
4	INTRV_TYPE_ID_INTRVNTN_TYPE_NAME	VARCHAR	No
	The name of the intervention type.
5	INTRV_TYPE_CONTACT	INTEGER	No
	The intervention type contact for this intervention.
6	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this intervention. This column is frequently used to link to the PATIENT table.