SELECT pPatients.Loc_ID AS Agency ,pAssessments.Patient_ID ,pAssessments.F26 AS Assessment_Reason_M0100 ,pAssessments.F179 AS Start_of_Care_M0030 ,pAssessments.F25 AS Admission_Status ,pAssessments.F176 AS Assessment_Completed_M0090 ,pAssessments.F178 AS Certification_End ,pPatients.Patient_ID ,pPatients.Pt_Last AS PatientLast ,pPatients.Pt_First AS PatientFirst ,pAssessments.F300 AS HIPPS_Code ,Agency.Wage_Index ,casmix_lookup.Weights AS Weight FROM #Request.prefix_db_agency#.pPatients INNER JOIN #Request.prefix_db_agency#.pAssessments ON pPatients.Patient_ID = pAssessments.Patient_ID INNER JOIN #Request.prefix_db_lookup#.Agency ON pPatients.Loc_ID = Agency.Agency_ID LEFT JOIN #Request.prefix_db_lookup#.casmix_lookup ON LEFT(pAssessments.F300, 4) = casmix_lookup.HIPPS_Code WHERE pPatients.Loc_ID = #session.AgencyID# AND pAssessments.Assmt_ID = '#Assmt_ID#' AND pAssessments.status = 0 AND pAssessments.F300 != "" AND (pAssessments.F26 LIKE '1%' OR pAssessments.F26 LIKE '4%') AND pAssessments.F176 >= DATE_ADD(NOW(), INTERVAL -90 DAY) ORDER BY pPatients.Pt_Last, pAssessments.F176 DESC