microLab

Purpose: Microbiology data.

Links to:

  • PATIENT on patientUnitStayID

Important considerations

  • The dataset is not well populated due to limited availability of microbiology interfaces.

Table columns

Name Datatype Null Option Comment Is Key Stored Transformed Created
patientUnitStayID int NOT NULL foreign key link to the patient table FK C
microLabID int IDENTITY surrogate key for the micro lab PK C
cultureTakenOffset int NOT NULL number of minutes from unit admit time that the culture was taken C
cultureSite varchar(255) NOT NULL picklist site name from where the culture was taken e.g.: Wound, Drainage Fluid, Sputum, Expectorated, Nasopharynx, etc. S
organism varchar(255) NOT NULL picklist organism found e.g.: Staphylococcus aureus, Pseudomonas aeruginosa, no growth, etc. S
antibiotic varchar(255) NULL picklist antibiotic used e.g.: ceftazidime, aztreonam, other, etc. S
sensitivityLevel varchar(255) NULL picklist sensitivity level of antibiotic: Intermediate, Resistant, or Sensitive S
eICU-CRD v1.0 documentation