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.