Open Dental Forum

In query 1203 Count of new patients, total patients, and total patient visits in date range. you can potentially miss new patients. The new patient part boils down to : SET @StartDate=curdate() - INTERVAL 1 MONTH, @EndDate=curdate(); SET @ignoreCodes='D9986,D9987'; /*New patients*/ SELECT 'NP' AS 'C...

This query was very useful for me. Unfortunately, there's a security/permissions issue when released (probably from drop table). Here's a re-write to get around that: SET @FromDate=CURDATE()-INTERVAL 30 DAY, @ToDate=CURDATE(); SELECT t1.Date , t1.Seen , t2.Sched , CONCAT(ROUND((t2.Sched/t1.Seen*100)...

Nevermind, I fixed it. Order by ProcDate, then group by PatNum: SET @bwCodes = 'D0272,D0274,M0274'; SET @Date = curdate(); SELECT aptDay.PatNum, bwproc.CodeNum, bwproc.ProcCode, DATE(LastBW) FROM (SELECT * FROM appointment a WHERE date(a.AptDateTime) = @Date) aptDay /*Most recent @bwCode date for ea...

I have the following query: SET @bwCodes = 'D0272,D0274,M0274'; SET @Date = curdate(); SELECT aptDay.PatNum, bwproc.CodeNum, bwproc.ProcCode, DATE(LastBW) FROM (SELECT * FROM appointment a WHERE date(a.AptDateTime) = @Date) aptDay /*Most recent @bwCode date for each patient*/ LEFT JOIN ( SELECT pl.P...

I've set up custom Treatment Plan Priorities definitions. Is there a way to set a default priority by procedure code or by procedure buttons?

You can archive the patients. This only secures against a person manually pulling charts, but wouldn't affect reporting. You could also scramble identifying information (name, DOB, phone, address (maybe leave the ZIP?), SSN, etc) and leave everything else. This is probably the way to do what you wan...