SELECT Assessment_New.Assessment_Id, 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, patient.Status, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Assessment_Completed_M0090, Assessment_New.Transmission_status, Employee.Last_Name, Employee.First_Name ,(select count(*) from #Request.prefix_db_agency#.PatientRecordLock where patient_id = patient.Patient_ID and agency_id = Assessment_New.Agency_ID and UnlockedBy_ID = 0) as locked From #Request.prefix_db_agency#.Assessment_New LEFT OUTER JOIN #Request.prefix_db_agency#.patient on Assessment_New.Patient_ID = patient.Patient_ID LEFT OUTER JOIN hhapowerpath.Employee on Assessment_New.Record_Created_By = Employee.Employee_ID Where Assessment_New.Agency_ID = '#Session.AgencyID#' AND patient.Status = 'active' AND Assessment_New.Patient_ID = patient.Patient_ID AND Assessment_New.Admission_Status = 'In Progress' AND Assessment_New.NotAdmitted != 1 AND Assessment_New.Archive = 0 AND Assessment_New.Deleted = 0 AND Assessment_New.Certification_Start < Now() ORDER BY Assessment_New.Certification_Start

Active Patients with Incomplete Assessments/Evaluations

IMPORTANT: You can download multiple assessments BUT ONLY one (1) assessment per patient.

	Cert Start	Cert End	Patient	Employee	Assessment Reason	Download
	#DateFormat(Certification_Start, "mm/dd/yy")#	#DateFormat(Certification_End, "mm/dd/yy")#	#Last_Name_M0040#, #First_Name_M0040#	#Last_Name# #First_Name#	6/7 - Transfer #Assessment_Reason_M0100#	Signed out

--->