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
