OR_LOG_ALL_STAFF

Description:

The OR_LOG_ALL_STAFF table contains information about all staff members associated with a procedural case that has been performed. This includes physicians, procedural staff, anesthesia staff, pre-op nurses, and recovery nurses.

Primary Key

Column Name	Ordinal Position
LOG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	LOG_ID	VARCHAR	No
	The unique ID associated with the procedural log record for this row.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	STAFF_TYPE_MAP_C_NAME	VARCHAR	No
	The staff type mapping category ID for the staff member. May contain organization-specific values: No Category Entries: Physician Anesthesia Provider Other Anesthesia Staff Preprocedure Nurse Recovery Nurse Phase II Nurse General Staff Circulator Scrub Nurse Surgical Tech Sedationist Sedation Physician Primary Perfusionist Secondary Perfusionist Perfusion Student Anesthesiologist Anesthesia Faculty Anesthesia Fellow Anesthesia Resident Certified Registered Nurse Anesthetist Student Nurse Anesthetist Graduate Nurse Anesthetist Anesthesiologist Assistant Anesthesia Assistant Anesthesia Nurse Practitioner Anesthesia Technician Anesthesia Block Nurse Nurse Anesthetist Anesthetic Nurse Anesthesia Associate Anesthesia Specialist Recovery Nurse
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	ROLE_C_NAME	VARCHAR	No
	The role category ID for the staff member. This will only have a value for physicians. May contain organization-specific values: Yes Category Entries: Primary
6	SERVICE_C_NAME	VARCHAR	No
	The service category ID for the staff member. This will only have a value for physicians. May contain organization-specific values: Yes
7	PANEL	INTEGER	No
	The panel number for the staff member. This will only have a value for physicians.
8	STAFF_TYPE_C_NAME	VARCHAR	No
	The staff type category ID for the staff member. This will only have a value for procedural staff. May contain organization-specific values: Yes
9	ANES_STAFF_TYPE_C_NAME	VARCHAR	No
	The anesthesia staff type category ID for the staff member. This will only have a value for anesthesia staff. May contain organization-specific values: Yes
10	ACCOUNTBLE_STAFF_YN	VARCHAR	No
	Indicates whether the staff member is considered primary or responsible for the log record represented by this row. Y indicates that the staff member is considered primary for procedural staff or responsible for anesthesia providers. N indicates that the staff member is not considered primary or responsible. For physicians, it is only the primary physician on the first panel. May contain organization-specific values: No Category Entries: No Yes
11	TIME_DURATION_MINS	INTEGER	No
	The length of time the staff member is documented as either in room or responsible in minutes for the log represented by this row.