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.