Decrypted_Emp_ID=decrypt(#url.eid#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); 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 = '#url.eid#' AND EmployeeType != 'Physician' SELECT * FROM #Request.prefix_db_lookup#.Training_Log WHERE Agency_ID = '#session.AgencyId#' AND Train_ID = '#url.Train_ID#'

New Training Log for #getEmp.First_Name# #getEmp.Last_Name# Update Training Log for #getEmp.First_Name# #getEmp.Last_Name#

Employee Name

#getEmp.First_name# #getEmp.Last_name#

Training Step *

Training Date *

Date Format: mm/dd/yyyy

Notes