SELECT Employee.Login_Id,SuperUsers.User_ID,SuperUsers.User_Id AS Employee_Id, SuperUsers.Username, SuperUsers.Full_Name ,Agency.Agency_ID, Agency.Agency_Name, Agency.Super_ID, Agency.Agency_Login, Agency.Telephony ,Agency.Agency_State, Agency.Agency_Medicare_ID,Agency.Parent_Id, Agency.AgencyType, Agency.CAHPS,Agency.TurboClaim, Agency.Survey,Agency.PatientFileManagerInUse ,Physician.Physician_ID, Physician.Portal ,Employee.Block, Employee.skill,Employee.Email, Employee.Authority_Level, Employee.level ,Employee.First_Name, Employee.Last_Name ,Agency.Agency_contact_Phone,Employee.Home_Phone FROM #Request.prefix_db_lookup#.SuperUsers, #Request.prefix_db_lookup#.Employee LEFT OUTER JOIN #Request.prefix_db_lookup#.Physician ON Employee.Employee_ID = Physician.Employee_ID LEFT JOIN #Request.prefix_db_lookup#.Agency ON Employee.Agency_ID = Agency.Agency_ID WHERE SuperUsers.Super_ID = Agency.Super_ID AND Agency_Login =
Your Login information could not be verified. Please try again...
software homecare business brochure literature physician homecare management tools web based homecare business security homecare management tools