OR_CASE_SURG_RSC

Description: |
The OR_CASE_SURG_RSC table contains OR management system case surgeons/staff/resources.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
OR_CASE_ID | 1 |
LINE | 2 |

Column Information

| 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 |
Name of the implant tray