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