|
Name |
Type |
Discontinued? |
|
1 |
OR_CASE_ID |
VARCHAR |
No |
|
|
|
The unique ID of the case record. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The number of the lines of the surgical staff resource information in the case. |
|
|
3 |
SRG_STF_RSC_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 |
START_OFFSET |
INTEGER |
No |
|
|
|
The start time for the surgeon/staff/resource. It is measured in minutes relative to the beginning of the case. |
|
|
5 |
END_OFFSET |
INTEGER |
No |
|
|
|
The end time for the surgeon/staff/resource. It is measured in minutes relative to the beginning of the case. |
|
|
6 |
REQUIRED_YN |
VARCHAR |
No |
|
|
|
Yes/No flag which indicates whether the surgeon/staff/resource is required for the case. |
May contain organization-specific values: No |
Category Entries: |
Yes |
No |
|
|
7 |
SURG_REC_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The category value which indicates the type of the surgeon/staff/resource. The possibilities are Surgeon, Anesthesia Staff, Operating Room, Surgical Staff, Surgical Equipment, Anesthesia Equipment, or Instrument. |
May contain organization-specific values: No |
Category Entries: |
Surgeon/Performing Physician |
Anesthesia Staff |
Room |
Staff |
Equipment |
Anesthesia Equipment |
Instrument |
Deactivated Category 1 |
Deactivated Category 2 |
Positioning Device |
Implant Trays |
Admission Planning |
|
|
8 |
RESOURCE_TYPE |
VARCHAR |
No |
|
|
|
The specific type of the surgical resource within the case. |
|
|
9 |
LINE_INDEX |
INTEGER |
No |
|
|
|
Line index value of the surgeon/staff/resource within the case. |
|
|
10 |
BATCH_ASSIGN_YN |
VARCHAR |
No |
|
|
|
Yes/No flag which indicates whether or not the surgeon/staff/resource was assigned to the case through the batch assign method of the Assign Resources option within OR management system. |
May contain organization-specific values: No |
Category Entries: |
No |
Yes |
|
|
11 |
MOD_START_OFFSET |
INTEGER |
No |
|
|
|
The start time of the resource, in minutes relative to the start of the case, if it has been shortened or lengthened. |
|
|
12 |
MOD_END_OFFSET |
INTEGER |
No |
|
|
|
The end time of the resource, in minutes relative to the start of the case, if it has been shortened or lengthened. |
|
|
13 |
IMPLANT_TRAY_ID |
NUMERIC |
No |
|
|
|
Stores the implant tray associated with the pool. |
|
|
14 |
IMPLANT_TRAY_ID_RECORD_NAME |
VARCHAR |
No |
|
|
|
|