select agency_id from #Request.prefix_db_lookup#.Agency where status='active' AND Agency_ID = '#url.Agency_ID#' ORDER BY agency_id SELECT pAssessments.*,pAdmit.M1100_PTNT_LVG_STUTN, CASE WHEN LEFT(F26,1) = '4' THEN IFNULL(F40,0) WHEN LEFT(F26,2) = 'OT' THEN IFNULL(F38,0) WHEN F26 = 'SN Adult Evaluation' THEN IFNULL(F47,0) ELSE IFNULL(F34,0) END AS M1700, CASE WHEN (LEFT(F26,1) = '1' OR LEFT(F26,1) = '4') THEN IFNULL(F72,0) WHEN F26 = 'SN Adult Evaluation' THEN IFNULL(F49,0) ELSE IFNULL(F240,0) END AS M2102d FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID WHERE pAssessments.status = 0 AND pAdmit.status = 0 AND pAssessments.F27 IN ('SN','PT','OT','ST') AND (pAssessments.F26 like '1%' OR pAssessments.F26 like '4%' OR pAssessments.F26 like '%Eval%') GROUP BY pAssessments.F27,pAssessments.Assmt_ID ORDER BY pAssessments.Patient_ID,pAssessments.F177 DESC SELECT * FROM #Request.prefix_db_agency#.pAuths WHERE status = 0 AND Assmt_ID != 0 SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Type = 'goal' AND status = 0 SELECT * FROM #Request.prefix_db_lookup#.VBP_Analysis SELECT * FROM getallass WHERE F26 like '#oasis#%' AND Admit_ID = '#Admit_ID#' ORDER BY F26 DESC,F176 DESC SELECT SUM(getallauths.Total_Visits) AS tot_visits FROM getallauths WHERE Skill = '#item#' AND Assmt_ID = '#parent_assmtid#' SELECT * FROM getallcareplans WHERE Skill = '#item#' AND Assmt_ID = '#parent_assmtid#' SELECT * FROM getallVBP WHERE M1700 = '#getallass.M1700#' AND M2102d = '#getallass.M2102d#' AND Skill = '#item#' AND M1100 like '%#getallass.M1100_PTNT_LVG_STUTN#%' UPDATE #Request.prefix_db_agency#.pAssessments SET F304 = '#LsNumberFormat(achieved_goals, "0.0")#', F305 = '#LsNumberFormat(Goals_Per_Visit, "0.0")#' WHERE status = 0 AND Assmt_ID = '#update_assmt_Id#' AND F27 = '#item#'