Revision [209]
Last edited on 2009-01-16 08:59:30 by adminAdditions:
//Is there a report or query that we can run that will give us a list of the active patients with a zero balance and no activity within the last 31 days?//
In the following query you can adjust the desired period of inactivity by simply changing "31" in the WHERE clause to some other number of days. If you want to sort by primary provider, just change the ORDER BY clause as in the second version below.
"Name/ID",
The version below has a 90 day inactivity period and sorts by primary provider.
"Name/ID",
AND lfeedate < ( TODAY() - 90 )
ORDER BY "Primary Provider","name/id"
In the following query you can adjust the desired period of inactivity by simply changing "31" in the WHERE clause to some other number of days. If you want to sort by primary provider, just change the ORDER BY clause as in the second version below.
"Name/ID",
The version below has a 90 day inactivity period and sorts by primary provider.
"Name/ID",
AND lfeedate < ( TODAY() - 90 )
ORDER BY "Primary Provider","name/id"
Deletions:
days?//
"name/id",
Revision [99]
Edited on 2008-10-26 16:47:59 by adminAdditions:
----
CategoryQueries
CategoryQueries
Revision [88]
Edited on 2008-10-26 16:09:06 by adminAdditions:
%%(sql)
