#ucase(url.diagnosis)#: #ucase(url.description)#

SELECT pd.Assessment_ID, pd.Skill, pd.Type,pd.Description, pd.Created_By, pd.Record_Creation_Date,pd.M0_Answer, pd.Pathway_Details_ID,pd.Assessment_Tracker_ID,si.Visit_Date,pvd.Patient_ID, pvd.Description as pvd_description,pvd.Notes as pvd_notes,pvd.Performed,IFNULL(pvd.Severity,0) as Severity,pvd.Notes,pvd.Reading1,pvd.Type as pvd_type,pvd.Reading2,pvd.Progress_Details_ID FROM #Request.prefix_db_agency#.PatientVisitDetails pvd LEFT OUTER JOIN #Request.prefix_db_agency#.Pathway_Details pd on pvd.Pathway_Details_ID = pd.Pathway_Details_ID LEFT OUTER JOIN #Request.prefix_db_agency#.ScheduleItems si on pvd.ScheduleItems_ID = si.ScheduleItems_ID WHERE pvd.Patient_ID = #url.pid# AND pd.M0_Answer = '#url.diagnosis#' AND pd.Deleted is null AND pd.Resolved_Date is null AND pvd.Type is NOT NULL AND pvd.Notes != 'not performed' AND pvd.Notes != 'not evaluated' AND LENGTH(pd.Description) != 0 AND si.Visit_Date > '2009-05-15' AND pvd.description = '#url.description#' ORDER BY pd.Skill,pd.Type,pd.Description,si.Visit_Date DESC #dateformat(Visit_Date,"MM/DD/YY")# #skill# #type# #sev# #ucase(pvd_description)# #Reading1#

#pvd_notes#

#ucase(url.diagnosis)#: #ucase(url.description)#

No Data Available