SELECT pPatients.Loc_ID AS Agency_ID, pAssessments.Assmt_ID,pAssessments.AutoAssmt_ID, pAssessments.F177 AS CertStart, pAssessments.F178 AS CertEnd, pAssessments.Patient_ID, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F176 AS Assessment_Completed_M0090, pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst FROM #Request.prefix_db_agency#.pAssessments, #Request.prefix_db_agency#.pPatients WHERE pPatients.Loc_ID = #session.AgencyId# AND pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.Status = 1 AND pPatients.Status < 2 ORDER BY pPatients.Pt_Last, pPatients.Pt_First ASC

Deleted Assessments

Name	Reason	Date	Cert Start Date	Cert End Date	Action
#PatientLast#, #PatientFirst#	#Assessment_Reason_M0100#	#DateFormat(Assessment_Completed_M0090,"mm/dd/yyyy")#	#DateFormat(CertStart,"mm/dd/yyyy")#	#DateFormat(CertEnd,"mm/dd/yyyy")#	Un-Delete