You are here: Home Information for OSCAR Users EMR Resources Report Templates Billing Report Templates BC Billing Dx code search
Personal tools
Document Actions

BC Billing Dx code search

by David Chan last modified 2007-08-16 10:07

Search patients by icd9 codes based on billing data

<report  title="Billing Dx code search" description="Billing Dx code search (BC billing)" active="1">
<query>
select last_name,first_name from billingmaster, demographic where billingmaster.demographic_no = demographic.demographic_no and dx_code1 in ({multi_field}) ;</query>

<param id="multi_field" type="textlist" description="A comma-separated list of choices (just an example, can leave blank)">
</param>

</report>