SELECT Admit_ID, Loc_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0 LIMIT 1 SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = AND Status = 0 AND drafts = 0 ORDER BY Admit_ID DESC LIMIT 1 SELECT F178 FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Patient_ID = AND Status = 0 AND F178 IS NOT NULL AND Left(F26, 1) IN ('1', '4') ORDER BY F178 DESC LIMIT 1 SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND Admit_ID = AND F26 = AND F176 = AND Status = 0 ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT pAssessments.Assmt_ID, pAssessments.F176, pAssessments.F25, pSchedules.Visit_Date AS Missed_Visit_Date FROM #Request.prefix_db_agency#.pSchedules INNER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Patient_ID = pSchedules.Patient_ID AND pAssessments.Admit_ID = AND pAssessments.Status = 0 AND pAssessments.F26 = AND IFNULL(pAssessments.F25, 0) <> 1 AND ( pAssessments.Assmt_ID = pSchedules.Assmt_ID OR pAssessments.F176 = pSchedules.Visit_Date ) WHERE pSchedules.Patient_ID = AND pSchedules.Status = 0 AND pSchedules.Followup_visit = 1 AND IFNULL(pSchedules.Missed, 0) > 0 AND pSchedules.Visit_Type = AND pSchedules.Schedule_ID <> ORDER BY CASE WHEN pAssessments.Assmt_ID = pSchedules.Assmt_ID THEN 0 ELSE 1 END, CASE WHEN pAssessments.F176 = pSchedules.Visit_Date THEN 0 ELSE 1 END, pSchedules.Schedule_ID DESC, pAssessments.AutoAssmt_ID DESC LIMIT 1 UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 SELECT Assmt_ID, F176 FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND Admit_ID = AND F26 = AND Status = 0 AND IFNULL(F25, 0) <> 1 ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Status = 0 AND IFNULL(Missed, 0) = 0 AND Followup_visit = 1 AND Visit_Type = AND ( Assmt_ID = OR Visit_Date = ) AND Schedule_ID <> LIMIT 1 UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 SELECT Assmt_ID, F176, F25, F26 FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Patient_ID = AND Status = 0 LIMIT 1 SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Status = 0 AND IFNULL(Missed, 0) = 0 AND Followup_visit = 1 AND Visit_Type = AND Assmt_ID = AND Schedule_ID <> LIMIT 1 UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 SELECT Assmt_ID, F25, F176 FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND Admit_ID = AND F26 = AND Status = 0 ORDER BY CASE WHEN IFNULL(F25, 0) <> 1 THEN 0 ELSE 1 END, AutoAssmt_ID DESC LIMIT 1 SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Status = 0 AND IFNULL(Missed, 0) = 0 AND Followup_visit = 1 AND Visit_Type = AND ( Assmt_ID = OR Visit_Date = ) AND Schedule_ID <> LIMIT 1 SELECT Schedule_ID, Visit_Date FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Status = 0 AND Followup_visit = 1 AND IFNULL(Missed, 0) > 0 AND Visit_Type = AND Schedule_ID <> ORDER BY Schedule_ID DESC LIMIT 1 UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 SELECT a.Assmt_ID, a.F176 FROM #Request.prefix_db_agency#.pAssessments a WHERE a.Patient_ID = AND a.Admit_ID = AND a.F26 = AND a.Status = 0 AND IFNULL(a.F25, 0) <> 1 AND NOT EXISTS ( SELECT 1 FROM #Request.prefix_db_agency#.pSchedules s WHERE s.Patient_ID = a.Patient_ID AND s.Status = 0 AND IFNULL(s.Missed, 0) = 0 AND s.Followup_visit = 1 AND s.Visit_Type = AND ( s.Assmt_ID = a.Assmt_ID OR s.Visit_Date = a.F176 ) AND s.Schedule_ID <> ) ORDER BY a.AutoAssmt_ID DESC LIMIT 1 UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Status = 0 AND IFNULL(F25, 0) <> 1 SELECT IFNULL(MAX(Assmt_ID), 0) + 1 AS Assmt_ID FROM #Request.prefix_db_agency#.pAssessments INSERT INTO #Request.prefix_db_agency#.pAssessments ( Assmt_ID, Admit_ID, Patient_ID, Loc_ID, Status, F26, F27, F176, F177, F178, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( , , , , 0, , , , , , , , , )