IP_RES_EPISODE

Description: |
The IP_RES_EPISODE table contains information about the restraint episode. An episode is defined as the length of an order. The information includes episode start/end dates, application start/end dates, episode length, clinical justification documentation, and less restrictive alternatives documentation.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INPATIENT_DATA_ID | 1 |
RES_TYPE | 2 |
EPISODE_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 | EPISODE_NUM | INTEGER | No |
Refers to the episode number for the admission. The 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 | APPLICATION_NUM | INTEGER | No |
Displays the application number for the admission. The 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.
5 | EPI_START_DT | DATETIME (Local) | No |
The episode start date refers to the date when the flowsheet rows Order Obtained (for behavioral restraints) or Order Upon Application (for nonbehavioral restraints) were documented on in conjunction with the START status of a restraint type row(s).
6 | EPI_END_DT | DATETIME (Local) | No |
The episode end date refers to the date a new order was obtained (thereby ending the previous episode) or the date that all restraints were DISCONTINUED for the episode.
7 | EPI_LENGTH | FLOAT | No |
The length of time in hours that the restraint documentation indicates that the restraints have been "on" for.