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.