SELECT patient.Agency_ID AS Agency, patient.Patient_ID, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst,
Assessment_New.Assessment_Tracker_ID, Assessment_New.Assessment_Reason_M0100,
Diagnosis.Diagnosis, Diagnosis.M0230_Link, Diagnosis.Primary_Diagnosis, Diagnosis.Secondary_Diagnosis
FROM #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_agency#.Diagnosis
WHERE patient.Patient_ID = Assessment_New.Patient_ID
AND Diagnosis.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID
AND Assessment_New.Assessment_Tracker_ID = #url.ID#
AND (Diagnosis.Disabled is null or Diagnosis.Disabled = 0)
And Diagnosis.M0230_Link is not null
order by Diagnosis.Primary_Diagnosis DESC, Diagnosis, Secondary_Diagnosis DESC
MyHomecareBiz.com
M0230/240 Diagnoses for #PatientLast#, #PatientFirst#, #Assessment_Reason_M0100#