SELECT First_name, Last_name, Username, Password, scheduleEdit, Employee_ID, Authority_Level, employee_auth.eaRole, employee_auth.eaSetup, employee_auth.eaPayroll, employee_auth.eaBilling, employee_auth.eaOrders, employee_auth.eaAuthorizations, employee_auth.eaDataTransmit, employee_auth.eaType, employee_auth.eaCareplan, employee_auth.eaLock, employee_auth.eaSchedule, employee_auth.eaSetCareplanItems, employee_auth.eaSetSchedule, employee_auth.eaSetCommSubjects, employee_auth.eaSetEmployees, employee_auth.eaSetIncidentSubjects, employee_auth.eaSetPayers, employee_auth.eaSetPayrollCodes, employee_auth.eaSetPhysicians, employee_auth.eaSetReferralSrcs, employee_auth.eaSetRevenueCodes, employee_auth.eaSetSupplies, employee_auth.eaSetAgyInfoUpdate, employee_auth.eaClientEdit, employee_auth.eaNoteEdit, employee_auth.eaUndo, employee_auth.eaReports, employee_auth.eaStatistics, employee_auth.eaPatientSurvey, employee_auth.eaFileEdit, employee_auth.eaonlinechat FROM #Request.prefix_db_lookup#.Employee employee INNER JOIN #Request.prefix_db_agency#.employee_auth ON Employee_ID = employee_auth.eaID WHERE Agency_Id = '#session.AgencyId#' AND Employee_Id = '#Session.EmployeeId#' AND EmployeeType != 'Physician' SELECT Authority_Level, AuthorityLevelDesc FROM #Request.prefix_db_lookup#.AuthorityLevels where Authority_Level >= 2 and Authority_Level != 2.5 order by Authority_Level
View Authority & Update Photo for #getEmp.First_Name# #getEmp.Last_Name#


#getEmp.Username#

* keep blank to prevent user access

SELECT * from #Request.prefix_db_lookup#.Employee_Images where EmployeeId = '#Session.EmployeeId#'
src="../../datafiles/Employee_images/#getfile_name.FileName#" style="max-height: 140px;"/>
src="../../datafiles/Employee_images/empty.jpg" style="max-height: 140px;"/>

Select permitted access

Check the following roles and responsibilities that apply