Notifications
Clear all
Topic starter
If your staff has been tempted by that little 'Approximate' checkbox when you go to add a new problem to a chart, then your CQR numbers are probably off. When you add a new problem and check that box, it actually gets entered into a separate column in the database which is a Varchar data type. That means, people can usually type whatever they want in there so CQR can't use that column to pull dates from. The terminology of ‘For Problems, do not use the Approximate check box’ appears pretty much everywhere in the CQR guide. If you'd like to see how many rows you have of that, here's some code you can run in sqlplus or developer.
CPS
select PB.PID,PP.PatientId,PP.First,PP.Last,PP.Birthdate,PB.SDID,PB.CODE,PB.DESCRIPTION,PB.ONSETDATE,PB.DB_CREATE_DATE
from PROBLEM PB, PatientProfile PP
where PB.PID = PP.PId
and PB.ONSETDATE is NULL
order by PP.Last
EMR
select problem.APROXONSETDATE, person.SEARCHNAME, problem.DESCRIPTION from problem, person where xid > 991773588469287120 and APROXONSETDATE is not null and person.pid = problem.pid and person.PSTATUS = 'A' order by problem.APROXONSETDATE;
Posted : September 28, 2017 6:24 am
