MyHomecareBiz.com
#session.Display#  .  #session.AgencyName#  .  #session.AgencyLogin#
Select count(Agency_ID) as AgencyCount from #Request.prefix_db_lookup#.Employee where Employee.Login_Id=#session.ULoginID#
Show Agency Profile
SELECT MenuNames, DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel1 h where Level1Access=1 where Level2Access=1 where Level3Access=1 where Level4Access=1 where Level5Access=1 where Level6Access=1 where Level7Access=1 where Level8Access=1 where Level9Access=1 Union SELECT MenuNames, DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel1 h where (eaSetPayers=1 or eaSetRevenueCodes=1 or eaSetSupplies=1 or eaBilling = 1) AND MenuLevel1id=5 Union SELECT MenuNames, DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel1 h where (eaSetEmployees=1 or eaSetPayrollCodes=1 or eaPayroll=1) AND MenuLevel1id=6 Union SELECT MenuNames, DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel1 h where (eaStatistics=1) Union SELECT MenuNames, DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel1 h where (eaReports=1) Union SELECT MenuNames, DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel1 h where (eaUndo=1) Union SELECT MenuNames, DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel1 h where (eaSetCareplanItems = 1 or eaSetCommSubjects = 1 or eaSetEmployees = 1 or eaSetIncidentSubjects = 1 or eaSetPayers = 1 or eaSetPayrollCodes = 1 or eaSetPhysicians = 1 or eaSetReferralSrcs = 1 or eaSetRevenueCodes = 1 or eaSetSupplies = 1 or eaSetReferralSrcs = 1 or eaSetAgyInfoUpdate = 1 or eaPayroll = 1 or eaBilling = 1 )
class='LeftMenuHover' class='LeftMenuHover' class='LeftMenu' onmouseout ="this.className = 'LeftMenu';"> #GETLevel.MenuNames#
class='LeftMenuHover'class='LeftMenu' onmouseout ="this.className = 'LeftMenu';"> Help
class='LeftMenuHover'class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" onclick="window.location.replace('/dashboard/index.cfm?mmid=1&from=news');this.className = 'LeftMenuHover';"> News
class='LeftMenuHover'class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" > Dashboard
class='LeftMenuHover' class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" > Clients
style='display:none;'>
 Patient List
 New Patient
class='LeftMenuHover'class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" onclick = "javascript:window.location.replace('/schedules/index.cfm?view=day&mmid=3');this.className = 'LeftMenuHover';" > Schedules
class='LeftMenuHover' class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" > Billing
class='LeftMenuHover' class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" > Payroll
class='LeftMenuHover'class='LeftMenu' onmouseout = "this.className = 'LeftMenu';" > Statistics
class='LeftMenuHover' class='LeftMenu' onmouseout = "this.className = 'LeftMenu';" > Reports
class='LeftMenuHover' class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" > Undo
class='LeftMenuHover' class='LeftMenu' onmouseout = "this.className = 'LeftMenu';" > Setup
class='LeftMenuHover'class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" > MHB University
class='LeftMenuHover'class='LeftMenu' onmouseout ="this.className = 'LeftMenu';" onclick = "javascript: window.location.replace('/incidents/index.cfm?mmid=9&page=incidents&cat=&rpt=incident_log');" > Help