Personal tools
You are here: Home → OSCAR Users → EMR and Case Management Resources → QBE → 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
Help us support OSCAR!
Listservs

Subscribe to:

OSCAR Users (this is the most active list)

Medical Office Assistants

Developers

Listserv Archives

Membership

OSCAR users- please register with the OSCARcanada Users Society. There is no cost to be a member of the OSCARcanada Users Society and you will receive periodic updates about important OSCAR developments, news and meetings. Members are also be able to vote at the AGM

Useful Links
Contact Us

Oscar Canada Users Society

#425 - 1917 West 4th Avenue

Vancouver  BC  V6J 1M7

OscarCanadaUserSociety@gmail.com