OR_CASE_STAFF_NEED
Description:
The OR_CASE_STAFF_NEED table contains OR management system case surgical staff.

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 line of the surgical staff requested for the case.
3 STAFF_REQ_YN VARCHAR No
The category value which indicates whether the surgical staff member is required for the case.
May contain organization-specific values: No
Category Entries:
Yes
No
4 STAFF_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.
5 STAFF_START_OFFSET INTEGER No
The start time for the surgical staff. It is measured in minutes relative to the beginning of the case.
6 STAFF_END_OFFSET INTEGER No
The end time for the surgical staff. It is measured in minutes relative to the beginning of the case.
7 STAFF_PANEL VARCHAR No
The panel where the surgical staff is requested.
8 STAFF_TYPE_C_NAME VARCHAR No
The type of surgical staff requested for the case.
May contain organization-specific values: Yes