patient info SELECT MenuLevel2Id,MenuNames,DefaultPageUrl FROM #Request.prefix_db_lookup#.homecare_menulevel2 where parentid = 3 and Level1Access=1 and Level2Access=1 and Level3Access=1 and Level4Access=1 and Level5Access=1 and Level6Access=1 and Level7Access=1 and Level8Access=1 and Level9Access=1 Contact Physicians vitals inquiry payers medications chart review care plan account history Contact Physicians vitals inquiry payers medications chart review care plan account history