Primary Provider

Search:

Primary Provider

Description

Returns multiple rows for each case: the anesthesia attending(s) (ID and Role Concept ID) and the "other provider(s)" (CRNA/Res/Fellow) (ID and Role Concept ID) signed in for the longest duration the case.

Limitation

Limited to proper sign in documentation. Fellow sign ins are handled differently at individual sites. Many sites will not document the level of resident - please see the logic section of this document.

Value Type

Enumeration

Value	Value Code	Definition

Return Columns

Column Name	Data Type

Granularity

Logic

Returns the attending anesthesiologist with the longest sign in time between CaseStart and CaseEnd, returns their ID and Role Concept ID (attending = 6000)

Returns the other (non-attending) anesthesia provider with the longest sign in time between CaseStart and CaseEnd, returns their ID and Role Concept ID: (for example, unspecified year resident = 6004, CRNA = 6005, etc.):

MPOG_Staff_Role_Concept_ID   concept_desc   (relative count in MPOG)
6000   Staff Level - Anesthesia Attending (12348756)
6001   Staff Level - Anesthesia Resident CA1 (371430)
6002   Staff Level - Anesthesia Resident CA2 (305358)
6003   Staff Level - Anesthesia Resident CA3 (88)
6004   Staff Level - Anesthesia Resident - Unspecified Year (2981009)
6005   Staff Level - Anesthesia CRNA (8646950)
6010   Staff Level - Anesthesia Assistant (154801)
6013   Staff Level - Anesthesia Technician (87)
6014   Staff Level - Anesthesia Fellow (88502)