This phenotype returns the attending anesthesiologist and non-attending anesthesia providers for each provider type based on the Staff Roles phenotype that were signed into a case for the longest duration between the following times:
*If there are multiple sign-ins and sign-outs, this phenotype will combine the multiple durations to return a total amount of time between the above time bounds.
Each return has a unique combination of case ID, provider ID, provider role concept ID, and a Staff Type. We are only returning anesthesia provider concept IDs (not surgical):
Example:
MPOG_Case_ID |
AIMS_Staff_ID |
MPOG_Staff_Role_Concept_ID |
Staff_Type |
123456-789101112 |
654321 |
6000 |
Attending |
123456-789101112 |
954321 |
6001 |
Resident |
123456-789101112 |
854321 |
6005 |
CRNA |