|
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. |
|
|