Working on a project to find patient with a specific active problem. Logic all fine, and then one of my doctors questions the inclusion of a patient.
Seems the patient had the problem added with a prior ending-date. Thus, a historical problem. Never noticed this happening before - looking at the patient and all-problems, this problem only shows up on one line; normally (and perhaps because done at another encounter) problems resolved have a second entry.
But to the weird part - I usually use a filter
Cstr({problem.xid})="1.00e+035"
to get active problems.
However this problem is set with this code even though not active. I just added a filter to also look at
{PROBLEM.STOPDATE} >= currentdate
which seems to get it correct for the patient.
** So... has anyone else ever seen this?
I use GE's view (vActiveProblem) for this usually. It is definitely a good idea to do some spot checking and even have the providers glance over the lists. I think their only filters are:
WHERE (CHANGE = 2) AND (STOPDATE > GETDATE())