Notifications
Clear all
Topic starter
Does anyone have a report that looks at patients who have had an office visit in a certain time period, by LOC, By responsible provider of the document and then you can search within those patients to find specific OBS criteria like, Blood Pressure? I have been trying for two days to get the links right and the tables in and I cannot get it to work!
Thanks!!!
Posted : August 17, 2012 1:18 am
Topic starter
Thanks - I have tried to run it but get an error message stating something about a temp table? Any ideas?
Posted : August 21, 2012 3:18 am
Out of temp table space. Report is returning too much data. Need to expand temp table space in database, or limit the amount of data being returned. As is, the report is returning all data because it doesn't limit by the date range until all of the data has been returned. Limit by LOC or DocType.
Posted : August 21, 2012 3:29 am
Topic starter
Thanks agaain - how can I add in that it needs to be two or more office visit by patient? Also, when I try to limit by provider name, it comes back blank... odd.. you wouldn't have time for a chat via phone next week would you?
Thank you!
Posted : August 24, 2012 6:38 am
You won't be able to limit by number of office visits, but you can limit to office visits (instead of all document types)...see below. Also, see below for provider match.
{@ClinicalDate} >= #8/1/2012#
and {@ClinicalDate} < #9/1/2012#
and {DOCUMENT.DOCTYPE} in [1, 2] // Office Visit, Office Procedure
and {USRINFO.LASTNAME} startswith "provider last name"
Posted : August 26, 2012 10:17 pm
