OR_LOG_ALL_SURG
Description:
The OR_LOG_ALL_SURG table contains OR management system log surgeons.

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 which refers to the surgeon.
2 LINE INTEGER No
The number of the line of the surgeon in this surgical log.
3 SURG_ID VARCHAR No
The unique ID of the surgeon.
4 ROLE_C_NAME VARCHAR No
The category value which represents the role for the corresponding surgeon in the surgical log.
May contain organization-specific values: Yes
Category Entries:
Primary
5 SERVICE_C_NAME VARCHAR No
The category value which represents the kind of service the surgical log falls under.
May contain organization-specific values: Yes
6 START_TIME DATETIME (Local) No
The start date and time for the surgeon in the surgical log.
7 END_TIME DATETIME (Local) No
The end date and time for the surgeon in the surgical log.
8 TOTAL_LENGTH INTEGER No
The total time a surgeon was needed in the surgical log in seconds.
9 PANEL INTEGER No
The panel number in the surgical log in which the surgeon was involved.
10 RTLS_OFF_YN VARCHAR No
If set to Yes, Real Time Location System (RTLS) tracking has manually been turned off for this provider on this case log.
May contain organization-specific values: No
Category Entries:
No
Yes
11 TIME_SOURCE_STATUS_C_NAME VARCHAR No
The source (Manual / RTLS) and status category of this row's start and end time.
May contain organization-specific values: No
Category Entries:
Manual/Active
RTLS/Active
RTLS/Denied
RTLS/Raw Event
RTLS/Unresolved
Manual/PageRespond
12 START_TIME_CMT VARCHAR No
The start time comment for the surgeon in the surgical log.
13 END_TIME_CMT VARCHAR No
The end time comment for the surgeon in the surgical log.
14 START_TIME_DOCU_ID VARCHAR No
The unique ID of the EMP user who documented the start time for each surgeon associated with any panel of the surgical log.
15 START_TIME_DOCU_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
16 END_TIME_DOCU_ID VARCHAR No
The unique ID of the EMP user who documented the end time for each surgeon associated with any panel of the surgical log.
17 END_TIME_DOCU_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.