Purpose: The allergy tables contains details of patient allergies. The data is entered in the patient note forms.

Links to:

  • PATIENT on patientUnitStayID

Important considerations

  • The absence of observation does not indicate an absence of allergy.

Table columns

Name Datatype Null Option Comment Is Key Stored Transformed Created
allergyID int IDENTITY surrogate key for the allergy PK C
patientUnitStayID int NOT NULL a globally unique identifier (GUID) used as a foreign key link to the patient table FK C
allergyOffset int NOT NULL number of minutes from unit admit time that the allergy was detected C
allergyEnteredOffset int NOT NULL number of minutes from unit admit time that the allergy was entered C
allergyNoteType varchar(255) NOT NULL unique note picklist types e.g.: Comprehensive Progress Admission Intubation S
specialtyType varchar(255) NOT NULL physician specialty picklist types e.g.: anesthesiology gastroenterology oncology S
userType varchar(255) NULL eCareManager user picklist types e.g.: eICU Physician Nurse Attending Physician S
rxIncluded varchar(5) NOT NULL Does the Note have associated Rx data: True or False S
writtenIneICU varchar(5) NOT NULL Was the Note written in the eICU: True or False S
drugName varchar(255) NULL name of the selected admission drug e.g.: POTASSIUM CHLORIDE/D5NS METAXALONE PRAVACHOL S
allergyType varchar(255) NOT NULL type of allergy: Drug or Non Drug S
allergyName varchar(255) NOT NULL allergy picklist name e.g.: penicillins pollen shellfish S
drugHiclSeqno int NULL HICL sequence number for the drug if drug allergy e.g.: 2734, 33199, 20492 S

Detailed description

The allergy table includes patient data entry date/time, note type, specialty type, user type, drug information, etc. Allergy data for the patient can be entered on notes that contain a section for allergies. All allergies (drug and non-drug) can be entered along with necessary pre-admission medications. If a patient reports an allergy to a drug class, a selection from that class (e.g., Penicillin G) may be chosen. The exact nature of the allergy (e.g., allergic to “all penicillins”) may have halso been described with text in the Patient Description field but this field has been excluded to reduce risk of sharing PHI.

Allergy entry is optional. The Daily Progress Note is the most efficient way to enter allergies. Drug allergies entered in other Notes will display here; any allergies listed here will display in subsequent Notes and on a Patient Profile.

eICU-CRD v1.0 documentation