eGFR Lookup
Report of patients by eGFR values
eGFR lookup.txt
—
Plain Text,
0Kb
File contents
<report title="eGFR lookup" description="Report of patients by eGFR values" active="1">
<query>
select distinct demo.last_name,demo.first_name, type,dataField,dateObserved, demo.provider_no from measurements, demographic demo where type ="eGFR" and dataField <> '> 120' and dataField <> 'Not report' and dataField < {gfr} and dateObserved > ((PERIOD_ADD(EXTRACT(YEAR_MONTH FROM CURDATE()),-{mon})*100)+1) and demo.patient_status = 'AC' and demographicNo =demo.demographic_no order by demo.last_name,demo.first_name and dateObserved ;</query>
<param id="gfr" type="text" description="eGFR less than"> </param>
<param id="mon" type="text" description="Within the last (months)"> </param>
</report>
