SELECT * FROM #Request.prefix_db_agency#.pCMS4857 JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Phys_ID = pCMS4857.Render_Phys_ID WHERE Order_ID = '#url.afId#' SELECT Assmt_ID, F179 AS Start_of_Care_M0030, F26 AS Assessment_Reason_M0100, F176 AS Assessment_Completed_M0090, F176 AS Certification_Start, F177 AS Certification_End, "" AS Rehab_Prognosis_M0270, pAdmit.M0030_START_CARE_DT, pAdmit.clinical_authorization,pAdmit.case_authorization,pAdmit.Clinical_Manager,pAdmit.Case_Manager FROM #Request.prefix_db_agency#.pAssessments JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID WHERE Assmt_ID = '#Get485phy.Assmt_ID#' AND pAssessments.status = 0 AND pAdmit.status = 0 ORDER BY F176 Desc SELECT * FROM #Request.prefix_db_agency#.pCMS4857 WHERE Order_ID = '#url.afId#' SELECT Emp_ID, Emp_First, Emp_Last FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#GetAssessDet.Clinical_Manager#' Emp_ID = '#GetAssessDet.Case_Manager#' Emp_ID = '#Get_487.Created_by#' SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Emp_ID = '#url.Emp_ID#' AND status =0