Personal tools
You are here: Home / OSCAR Users / EMR and Case Management Resources / Query By Example - Database Searches / Select patients with HbA1C > 0.07
 

Select patients with HbA1C > 0.07

select distinct  lr.result, lp.patient_first_name, lp.patient_last_name, lp.collection_date  from labTestResults lr, labPatientPhysicianInfo lp where lr.test_name = 'HEMOGLOBIN A1C' and  lr.result != 'PND'  and lr.result > 0.07 and lr.labPatientPhysicianInfo_id = lp.id;

Document Actions

 

Download button

DOWNLOAD OSCAR FOR TESTING

 

eForms button

DOWNLOAD SHARED E-FORMS


 Customize button

FIND PLUG-INS AND TWEAKS
FOR YOUR OSCAR EMR

 

Subscribe Button

SUBSCRIBE TO DISCUSSION LIST 
(SEE ALL LISTS)

  

Help button

ACCESS THE ONLINE MANUALS
(PAID SUPPORT)