7.5 One year worth of upcoming patient notifications. Jeff Buchbinder

center

FreeMED CONCAT(p.ptlname, ', ', p.ptfname, ' ', p.ptmname) AS 'Patient Name', p.ptid AS 'Patient Id', IF(LENGTH(p.pthphone)=10,CONCAT(SUBSTR(p.pthphone,1,3),'-',SUBSTR(p.pthphone,4,3),'-',SUBSTR(p.pthphone,7,4)),'NONE') AS 'Home Phone', IF(LENGTH(p.ptwphone)=10,CONCAT(SUBSTR(p.ptwphone,1,3),'-',SUBSTR(p.ptwphone,4,3),'-',SUBSTR(p.ptwphone,7,4)),'NONE') AS 'Work Phone', n.ntarget AS 'Date of Notification', n.ndescrip AS 'Description' notification n LEFT OUTER JOIN patient p ON n.npatient=p.id n.ntarget > CURRENT_DATE() AND n.ntarget < DATE_ADD(CURRENT_DATE(), INTERVAL 1 YEAR) n.ntarget 0 0 1 1 1 30 60 left 30 60 left 30 60 left 30 60 left 30 60 left 30 60 left 480 268 1 1 columns

0 0 0

15 0 288 72 11 36 2 10 A3 14 1 1 1 1 1