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_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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.