IP_RES_APP_EPI

Description:

The IP_RES_APP_EPI table links restraint episodes with a restraint application.

Primary Key

Column Name	Ordinal Position
INPATIENT_DATA_ID	1
RES_TYPE	2
APPLICATION_NUM	3
LINE	4

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	APPLICATION_NUM	INTEGER	No
	The APPLICATION_NUM refers to the application number for the admission. The application number assigned to an application increases with each new application and does not repeat until a new admission. Each application indicates the period of time from START to DISCONTINUED of all restraints. There can be multiple episodes (orders) within an application.
4	LINE	INTEGER	No
	Line number for each episode number during the restraint application.
5	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.