IP_RES_TYPEEPISODE

Description:

The IP_RES_TYPEEPISODE table contains information about the restraint type episodes within a restraint episode. A restraint type episode is defined as the period during which a patient has a single type of restraint applied. The information includes start/end dates, length, and starting department.

Primary Key

Column Name	Ordinal Position
INPATIENT_DATA_ID	1
RES_TYPE	2
EPISODE_NUM	3
RES_ROW_ID	4
LINE	5

Column Information

	Name	Type	Discontinued?
1	RES_TYPE	VARCHAR	No
	The restraint type can be a behavioral restraint (BH) or nonbehavioral/medical-surgical restraint (MS).
2	INPATIENT_DATA_ID	VARCHAR	No
	The unique ID of the inpatient data store record.
3	EPISODE_NUM	INTEGER	No
	The EPISODE_NUM refers to the episode number for the admission. The episode number assigned to an episode increases with each new episode and does not repeat until a new admission. An episode is the length of a restraint order. A value of '0' here represents that there were errors for the corresponding restraint type in the current inpatient data record.
4	RES_ROW_ID	VARCHAR	No
	The unique ID of the flowsheet row record for the type of restraint used.
5	RES_ROW_ID_DISP_NAME	VARCHAR	No
	The display name given to the flowsheet group/row.
6	TYPE_START_DT	DATETIME (Local)	No
	The type episode start date refers to the instant for which the flowsheet row for that restraint type had a START documented.
7	TYPE_END_DT	DATETIME (Local)	No
	The type episode end date refers to the instant for which the flowsheet row for that restraint type had a DISCONTINUED documented.
8	TYPE_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
9	TYPE_LENGTH	FLOAT	No
	The length of time in hours that the restraint documentation indicates that the restraint type has been on for.
10	LINE	INTEGER	No
	This column contains a number to uniquely identify different restraint type episodes that have the same episode and restraint row ID.