carePlanCareProvider

Purpose: Details relating to the managing or consulting physician, including specialty and intervention category.

Links to:

  • PATIENT on patientUnitStayID

Table columns

Name Datatype Null Option Comment Is Key Stored Transformed Created
cplCareProviderID int IDENTITY surrogate key for care plan care provider PK C
patientUnitStayID int NOT NULL a globally unique identifier (GUID) used as a foreign key link to the patient table Fk C
careProviderSaveOffset int NOT NULL number of minutes from unit admit time that the care provider was entered C
providerType varchar(255) NULL the picklist type of the care provider: Admitting Consultant Referring Primary S
specialty varchar(255) NULL the picklist specialty of the care provider e.g.: cardiology unknown obstetrics/gynecology S
interventionCategory varchar(255) NULL The eICU intervention category of the care provider: I, II, III, IV, Unknown, or NULL. This data denotes the level of oversight and intervention authorized for eICU clinicians for this patient by the managing physician (MP). Category I – Ermercency interaction only, Cat II – Emergency and Best Practices intervention only, Cat III – Full interaction, Cat IV - Full interaction (redundant). S
managingPhysician varchar(50) NULL picklist value which denotes whether this care provider is the managing physician: Managing or Consulting S
activeUponDischarge varchar(10) NOT NULL denotes if this physician was active upon patient discharge: True or False S

Detailed description

Care Plan Provider data includes type (e.g. Admitting, Consultant); specialty (e.g. cardiology), a managing physician indicator, and intervention category which denotes the level of oversight and intervention authorized for eICU clinicians for the patient by a managing physician.

Managing Physician designates the physician who has the overall charge of the patient’s care. In many instances, the managing physician will be the admitting physician. If a consultant, such as an intensivist, is managing care, the consultant should be designated as the managing physician. Only one managing physician at a time may be assigned to the patient. If a managing physician is not selected, the admitting physician will be employed as managing.

Consultants with specialties and intervention categories are provided. Intervention category denotes the level of oversight and intervention authorized for eICU clinicians for a patient by the managing physician.

eICU-CRD v1.0 documentation