SQL: Active Patients with Non-Medication Allergies

About

This report shows all active patients with active-non medication allergies, along with detail about the allergy.

A sample image of this SQL report run in the Database Viewer is shown below:

Caveats

None.

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

select chartnotes.patno, startdate, icd_1, icd_1_descript, snomed1, snomed1_descript, note1, severity, symptoms,ref_name as refer_coord from chartnotes
inner join register on register.patno = chartnotes.patno
where section_subheading = 'NON-MEDICATION ALLERGY'
and status_pat = 'ACTIVE' and problem_list = 'Y'
order by patno