SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Employee.Email, Employee.Status, Employee.Cell_Phone, Employee.Agency_ID FROM #Request.prefix_db_lookup#.Employee WHERE Employee.Status = 'active' and Employee.Password != '' and Employee.Agency_ID = '#session.AgencyID#' ORDER BY Employee.Agency_ID, Employee.Last_Name select * from #Request.prefix_db_lookup#.Employee LEFT OUTER JOIN #Request.prefix_db_agency#.Dash_Eligibility on Employee.Employee_ID = Dash_Eligibility.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Dash_no_notes_cargiver on Employee.Employee_ID = Dash_no_notes_cargiver.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Incomplete_Assessment on Employee.Employee_ID = Incomplete_Assessment.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Missing_Assessments on Employee.Employee_ID = Missing_Assessments.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Missing_patients on Employee.Employee_ID = Missing_patients.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Missing_progress_notes on Employee.Employee_ID = Missing_progress_notes.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Physician_face_to_face on Employee.Employee_ID = Physician_face_to_face.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Ready_to_Lock on Employee.Employee_ID = Ready_to_Lock.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Unapproved_Progress_Notes on Employee.Employee_ID = Unapproved_Progress_Notes.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.dash_no_485 on Employee.Employee_ID = dash_no_485.Employee_ID LEFT OUTER JOIN #Request.prefix_db_agency#.dash_missing_items_caregiver on Employee.Employee_ID = dash_missing_items_caregiver.Employee_ID WHERE Employee.Status = 'active' and Employee.Password != '' AND Employee.Agency_ID = '#session.AgencyID#'

Compliance Report

	Employee Name	Missing Assessments	Incomplete Assessments	Assessments Ready for Review	Patients without a current CMS 485	Missing Progress Notes	Missing Progress Notes	Un-Approved Progress Notes	Eligibilities not Verified	Physician Face to Face needed	Incomplete & Unapproved Progress Notes	Missing Patient Documents
	#Last_Name#,#First_Name#	#Missing_Assessments_count#	#Incomplete_Assessment_count#	#Ready_to_Lock_count#	#dash_no_485_count#	#Missing_progress_notes_count#	#Dash_no_notes_cargiver_count#	#Unapproved_Progress_Notes_count#	#Dash_Eligibility_count#	#Physician_face_to_face_count#	#dash_missing_items_caregiver_count#	#Missing_patients_count#