SELECT Employee_ID, Last_Name, First_Name FROM #Request.prefix_db_lookup#.Employee WHERE Agency_ID = #session.AgencyID# AND Status = 'active' AND EmployeeType != 'Physician' ORDER BY Last_Name, First_Name SELECT Employee_ID, ScheduleEdit FROM #Request.prefix_db_lookup#.Employee WHERE Agency_ID = '#session.AgencyId#' AND Employee_ID = '#session.EmployeeId#' SELECT Patient_ID, First_Name_m0040, Last_Name_m0040, Middle_Initial_M0040 FROM #Request.prefix_db_agency#.patient WHERE Agency_ID = '#session.AgencyID#' AND status = 'active' ORDER BY Last_Name_m0040, First_Name_M0040 Employee Level = #session.EmpLevel# SELECT MenuLevel2Id,MenuNames,DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel2 where ParentId=4 and Level1Access=1 and Level2Access=2 and Level3Access=3 and Level4Access=4 and Level5Access=5 and Level6Access=6 and Level7Access=7 and Level8Access=8 and Level9Access=9

#GetMenuLevel2.MenuNames# -