IP_DEVICE_CAPTURE
Description:
This table contains device capture information for the given Inpatient Data (INP) record.

Primary Key
Column Name Ordinal Position
INPATIENT_DATA_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 INPATIENT_DATA_ID VARCHAR No
The unique identifier for the inpatient record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 INST_START_DTTM DATETIME (Local) No
This column displays the start instant of capture for the associated device.
4 DEVICE_ID VARCHAR No
This column displays the unique ID of the associated device record.
5 DEVICE_ID_DEVICE_NAME VARCHAR No
The name for this device.
6 SELECT_VAR_IDS VARCHAR No
This column displays the ID of the associated variable record.
7 ATTACH_INSTANT_DTTM DATETIME (Local) No
This column displays the instant at which the associated device record was attached to the patient for the given encounter.
8 REMOVE_INSTANT_DTTM DATETIME (Local) No
This column displays the instant at which the associated device record was removed from the patient for the given encounter.
9 INSTANT_TO_VAL_DTTM DATETIME (Local) No
This column displays the instant at which the associated device was validated.
10 VALIDATED_USER_ID VARCHAR No
This column displays the users who validated the associated device.
11 VALIDATED_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 LINKED_ORD_ID NUMERIC No
This column displays the order ID that is linked with the device
13 SECONDARY_ORD_ID NUMERIC No
This column displays the secondary order id when second order is linked to the device
14 LINE_NUMBER INTEGER No
This column stores the audit trail line number for edited device data.
15 FLO_TEMPLATE_ID VARCHAR No
This column displays the flowsheet template that will be updated when device data is filed in the flowsheet.
16 FLO_TEMPLATE_ID_DISPLAY_NAME VARCHAR No
The display name associated with this template.
17 DRCT_CPTR_INTERVAL INTEGER No
Interval for direct capture of Anesthesia device data, in minutes
18 AUTOFILE_EFF_UTC_DTTM DATETIME (UTC) No
The instant at which Auto Filing for this device association was enabled or disabled (as described in I INP 9160).
19 AUTO_FILE_C_NAME VARCHAR No
Stores whether device data is auto filed for this device association
May contain organization-specific values: No
Category Entries:
No
Yes
Stopping
20 AUTOFILE_INTERVAL INTEGER No
This item determines the filing interval for this device association when using Inpatient automatic filing. This item overrides the Device Type, Department, and/or System level interval values.