|
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. |
|
|
