SELECT Assmt_ID, Admit_ID, Patient_ID, F26, F177, F178 FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = 0 LIMIT 1 SELECT F177, F178 FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Patient_ID = AND Status = 0 AND LEFT(F26, 1) IN ('1', '4') AND F177 IS NOT NULL AND F178 IS NOT NULL AND F177 <= AND F178 >= ORDER BY F177 DESC, Assmt_ID DESC LIMIT 1 SELECT F177, F178 FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Patient_ID = AND Status = 0 AND LEFT(F26, 1) IN ('1', '4') AND F177 IS NOT NULL AND F178 IS NOT NULL ORDER BY F178 DESC, Assmt_ID DESC LIMIT 1

Certification Period Violation

#Request.certValidate_message#