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