Hi Everyone
I hate to bother with this question and I tried looking myself but I need a couple of reports that I can't find or figure out.
1. General Patient Demographics (patients by age, patients by zip code, patient with insurance,)
2. How many of active patients are in recall program (ie, how many are good patients, not just a limited and gone)
Thanks in advance for any help anyone can give me.
Looking for a couple of reports
Re: Looking for a couple of reports
Could you please be a little more explicit in what you are looking for please?
For general patient demographics are you looking for a report that finds (patients by age AND patients by zip code AND patient with insurance) or 3 individual reports?
Query #208 "Patient count by age, with at least 1 completed procedure" might be useful to you.
For the second report we need to more clearly define your requirements before we can find or make one that works for you. Do you want a list of patients with status as active AND more than one completed procedure? If you are looking to exclude patients with a limited and nothing else we should probably make a report to find them and then inactivate or schedule them to clean up your database.
You might find that Query example #177 fits your needs for finding active patients. "Active Patients who have had a particular proc completed relative to Active patients who have had any proc completed within a given date range"
http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
For general patient demographics are you looking for a report that finds (patients by age AND patients by zip code AND patient with insurance) or 3 individual reports?
Query #208 "Patient count by age, with at least 1 completed procedure" might be useful to you.
For the second report we need to more clearly define your requirements before we can find or make one that works for you. Do you want a list of patients with status as active AND more than one completed procedure? If you are looking to exclude patients with a limited and nothing else we should probably make a report to find them and then inactivate or schedule them to clean up your database.
You might find that Query example #177 fits your needs for finding active patients. "Active Patients who have had a particular proc completed relative to Active patients who have had any proc completed within a given date range"
http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
Re: Looking for a couple of reports
I guess my other one would be how many patients we have from each zipcode
Re: Looking for a couple of reports
Query #229 "Patient count by Zipcode, with at least 1 completed procedure in date range"
Or Query #178 "Patient count by Zipcode, with at least 1 completed procedure"
Or Query #178 "Patient count by Zipcode, with at least 1 completed procedure"