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, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Assessment_Completed_M0090, Assessment_New.Transmission_status ,(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, #Request.prefix_db_agency#.patient Where Assessment_New.Agency_ID = '#Session.AgencyID#' AND Assessment_New.Patient_ID = patient.Patient_ID AND patient.Status = 'active' AND Assessment_New.Admission_Status = 'In Progress' AND Assessment_New.NotAdmitted != 1 AND Assessment_New.Archive <> 1 AND Assessment_New.Deleted <> 1 AND Assessment_New.Certification_Start < Now() ORDER BY Assessment_New.Certification_Start

Assessments Still in Progress

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

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

There are currently no Assessment records.

--->