SELECT Assessment_New.Assessment_ID, Assessment_New.Record_creation_Date, Assessment_New.Assessment_tracker_ID, Assessment_New.Patient_ID, Assessment_New.admission_status, Assessment_New.Assessment_Reason_M0100, patient.Last_Name_M0040, patient.First_Name_M0040, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Assessment_Completed_M0090, Assessment_New.Transmission_status
FROM #Request.prefix_db_agency#.Assessment_New
LEFT JOIN #Request.prefix_db_agency#.patient ON Assessment_New.Patient_ID = patient.Patient_ID
WHERE Assessment_New.HHAC_Agency_ID = '#Session.AgencyLogin#'
AND Assessment_Completed_M0090 != ''
AND Assessment_New.Deleted = 0
AND Assessment_New.Certification_End BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 14 DAY)
AND (Assessment_New.Assessment_Reason_M0100 LIKE '1%' OR Assessment_New.Assessment_Reason_M0100 LIKE '4%' OR Assessment_New.Assessment_Reason_M0100 LIKE '3%')
ORDER BY Assessment_New.Certification_End ASC
SELECT Patient_ID, First_Name_m0040, Last_Name_m0040, Middle_Initial_M0040
From #Request.prefix_db_agency#.patient
Where Agency_ID = #session.AgencyID#
AND status = 'active'
Order By Last_Name_m0040
Agency Administration - Expired Assessment List
Important: You can download multiple assessments BUT ONLY
one (1) assessment per patient.