IP_RES_APPLICATION

Description:

The IP_RES_APPLICATION table contains information about the restraint application, which is the period of time from START to DISCONTINUED. There can be multiple episodes (length of an order) within an application. The table gives the start/end date of the application and the number of episodes within the application.

Primary Key

Column Name	Ordinal Position
INPATIENT_DATA_ID	1
RES_TYPE	2
APPLICATION_NUM	3

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 (length of an order) within an application.
4	APP_START_DT	DATETIME (Local)	No
	The application start date refers to the date when the initial restraint had a status of START. There can be multiple episodes (length of an order) within an application, but the application start date is the date of the first episode in a series of episodes back to back.
5	APP_END_DT	DATETIME (Local)	No
	The application end date refers to the date when the restraint had a status of DISCONTINUED. There can be multiple episodes (length of an order) within an application, but the application end date is the date of the last episode that is being discontinued.
6	EPISODE_MAX_NUM	INTEGER	No
	The number of episodes within the restraint application.