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.