OR_LOG_SURG_RSC

Description:

The OR_LOG_SURG_RSC table contains OR management system log surgical resources.

Primary Key

Column Name	Ordinal Position
LOG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	LOG_ID	VARCHAR	No
	The unique ID of the surgical log the surgeons/staff/resources refers to.
2	LINE	INTEGER	No
	The number of the line of the surgeon/staff/resource in the surgical log.
3	SRG_STF_RES_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	REQUIRED_YN	VARCHAR	No
	Yes/no flag which indicates if the surgeon/staff/resource is required in the surgical log. May contain organization-specific values: No Category Entries: Yes No
5	SURG_REC_TYPE_C_NAME	VARCHAR	No
	The category value indicating the surgical record type for the surgeon/staff/resource. 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
6	RESOURCE_TYPE_C	VARCHAR	No
	The category value indicating the surgical resource type for the staff/resource.
7	BATCH_ASSIGN_YN	VARCHAR	No
	Yes/no flag which indicates if the Surgeon/Staff/Resource was batch assigned in the surgical log. The category values for this column were already listed for column: REQUIRED_YN