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 VARCHAR No
The unique ID of the surgeon/staff/resource record.
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