IP_RES_COMP
Description:
The IP_RES_COMP table contains information about the restraint assessments that must be documented. The information includes details about the order, assessment, and frequent monitoring.

Primary Key
Column Name Ordinal Position
INPATIENT_DATA_ID 1
RES_TYPE 2
EPISODE_NUM 3
DOC_TYPE 4
ROW_TYPE_BH 5
ROW_TYPE_MS 6

Column Information
Name Type Discontinued?
1 RES_TYPE VARCHAR No
Displays the restraint type. The restraint can be a behavioral (BH) or nonbehavioral/medical-surgical (MS) restraint.
2 INPATIENT_DATA_ID VARCHAR No
The unique ID of the inpatient data store record.
3 EPISODE_NUM INTEGER No
Displays 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' represents that there were errors for the corresponding restraint type in the current inpatient data record.
4 DOC_TYPE VARCHAR No
Displays whether the restraint documentation is done once per episode or periodically during a restraint episode. The one-time documentation will have a DOC_TYPE of INFO and the periodic documentation will have a DOC_TYPE of MONITOR.
5 COMPLIANT VARCHAR No
Determines whether the compliance measure for the particular episode is compliant by displaying a "Y" or "N". If it cannot be determined a "-" will be displayed.
6 COMP_VALS VARCHAR No
Displays the compliant data that was filed for the compliance measures that are only documented once per episode.
7 ROW_TYPE_BH INTEGER No
Displays ID number of the value of compliance measure being reported on within the "Violent Restraint Monitoring Row Type" category list. If the row does not apply to a Violent Restraint, then a value of 999 will be displayed.
8 ROW_TYPE_MS INTEGER No
Displays ID number of the value of compliance measure being reported on within the "Non Violent Restraint Monitoring Row Type" category list. If the row does not apply to a Non Violent Restraint, then a value of 999 will be displayed.