select agency_id,Agency_Login from #Request.prefix_db_lookup#.Agency where status='active' AND Agency_ID = '#url.Agency_ID#' ORDER BY agency_id SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.status = 0 AND pSchedules.Followup_visit = 1 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.status = 0 SELECT * FROM #Request.prefix_db_agency#.pAdmit JOIN #Request.prefix_db_agency#.pPatients ON pAdmit.Patient_ID = pPatients.Patient_ID WHERE pAdmit.status = 0 AND pPatients.Status < 2 GROUP BY pAdmit.Admit_ID SELECT * FROM getallOASIS WHERE status = 0 AND Admit_ID = '#Admit_ID#' ORDER BY F177 DESC SELECT * FROM getallOASIS WHERE status = 0 AND Admit_ID = '#Admit_ID#' AND F26 = '#assessment_name#' AND F177 >= '#DateFormat( NOW(),"yyyy-mm-dd")#' ORDER BY F177 DESC SELECT * FROM getallschedules WHERE status = 0 AND Assmt_ID IN (#assmt_ids#) AND Visit_Type = '#visit_type#' AND Visit_Date = '#getOASISdate.F176#' INSERT INTO #Request.prefix_db_agency#.Email_Daily_QA (Daily_QA_Date, Emp_ID, Patient_ID, Header, Description, Created_Date) VALUES ( '#completeddate#',#Emps_ID#,#Patient_ID#,'#Header#','#Decription#', NOW()) SELECT * FROM getallOASIS WHERE status = 0 AND Admit_ID = '#Admit_ID#' AND F26 = '#assessment_name#' AND F177 != F176 ORDER BY F177 DESC INSERT INTO #Request.prefix_db_agency#.Email_Daily_QA (Daily_QA_Date, Emp_ID, Patient_ID, Header, Description, Created_Date) VALUES ( '#completeddate#',#Emps_ID#,#Patient_ID#,'SOC Certification Start Date','SOC Certification Start date does not match assessment completion date', NOW())