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_RECORD_NAME VARCHAR No
The name of the PLF record.
12 INTERVAL_EVENT_UPDATE_UTC_DTTM DATETIME (UTC) No
The instant of update for a case tracking event.