INR Flowsheet Review
This query searches for entries in the OSCAR INR flow sheet (for those patients who have INR flowsheets enabled in their disease registry - code v5861). Written by Peter Everett.
INR Flowsheet Lookup.txt
—
Plain Text,
0Kb
File contents
<report title="INR Flowsheet" description="List of Flowsheet Instructions added" active="1">
<query>
SELECT demographic.provider_no, demographic.last_name, demographic.first_name, measurements.type, measurements.dataField, measurements.dateObserved, measurements.comments, demographic.HIN FROM measurements
JOIN demographic ON measurements.demographicNo = demographic.demographic_no
WHERE measurements.dateObserved >= DATE_SUB(CURDATE(), INTERVAL {days} DAY) AND
measurements.type = 'COUM'
ORDER by demographic.provider_no, demographic.last_name, dateEntered;
</query>
<param id="days" type="text" description="Within the last (days)"> </param>
</report>
