OR_LOG_CASE_TIMES

Description:

The OR_LOG_CASE_TIMES table contains OR management system log timing information.

Primary Key

Column Name	Ordinal Position
LOG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	LOG_ID	VARCHAR	No
	The unique ID of the surgical log referred to by the case times.
2	LINE	INTEGER	No
	The number of the line of the tracking event in the surgical log.
3	TRACKING_EVENT_C_NAME	VARCHAR	No
	The category value which lists the event being tracked within your facility for the surgical log. May contain organization-specific values: Yes
4	TRACKING_TIME_IN	DATETIME (Local)	No
	The date and time at which the patient was moved into the corresponding item in the event column in the surgical log.
5	TRACKING_TIME_OUT	DATETIME (Local)	No
	The date and time at which the patient was moved out of the corresponding item in the event column in the surgical log.
6	TRACKING_TIME_ELPS	INTEGER	No
	The total amount of time in seconds for the event in the surgical log.
7	TRACK_EVENT_TYPE_C_NAME	VARCHAR	No
	The category indicating the type of event, whether preop, intraop, or postop. May contain organization-specific values: Yes Category Entries: Pre Intra Post Anesthesia
8	TRACKING_STATUS_C_NAME	VARCHAR	No
	The category value indicating the progress status that corresponds to this timing event. May contain organization-specific values: Yes
9	TRACKING_STAT_INST	DATETIME (Local)	No
	The instant at which the status took effect.
10	TRACKING_PAT_LOCATION_EVNT_ID	NUMERIC	No
	The patient location that triggered this event to be documented.
11	TRACKING_LOCATION_ID	NUMERIC	No
	The patient location that the patient was moved to when a patient location change triggered the event.
12	INTERVAL_EVENT_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	The instant of update for a case tracking event.