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