|
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. |
|
|