Tracking referrals to MD

[Hersheydmd]

I check every patients' blood pressure when they come in for a recare.
If it is elevated I advise the patient to see a physician.
I wanted a way to keep track of all patients that I refer for a medical problem.
I created a procedure code N4010 "Refer MD". I enter it with status "Referred".
The following query will give you a list of all those patients and the date referred:

SELECT CONCAT(LName, ', ',FName, ' ', MiddleI) As Patient,
pc.ProcCode as 'Code', abbrdesc as 'Description', pn.Note as "Note", DATE_FORMAT(pl.ProcDate,'%m-%d-%Y') AS 'Date', ProcFee
FROM patient
INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum
INNER JOIN procedurecode pc ON pl.CodeNum=pc.CodeNum
INNER JOIN procnote pn ON pl.ProcNum= pn.ProcNum
WHERE pl.ProcStatus=5 and pc.proccode='N4010'
ORDER BY pl.ProcDate, patient.LName, patient.FName ASC