SELECT Captivate.Test, Captivate.Accuracy, Captivate.Date, Employee.Last_Name, Employee.First_Name, employee_auth.eaRole FROM #Request.prefix_db_lookup#.Captivate, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.employee_auth Where Captivate.Agency_ID = #url.ID# AND Employee.Employee_ID = Captivate.User_ID AND Employee.Employee_ID = employee_auth.eaID ORDER BY Captivate.User_ID, Date SELECT Logon.Agency_ID, Logon.Employee_ID, Logon.Logon_Date, Employee.Last_Name, Employee.First_Name FROM #Request.prefix_db_lookup#.Logon, #Request.prefix_db_lookup#.Employee Where Logon.Agency_ID = #url.ID# AND Logon.Logon_Date > #Period# AND Employee.Employee_ID = Logon.Employee_ID ORDER BY Logon_Date Desc HHA System Administration Superadmin Home

Logon Dates

Name Date Time
#Last_Name#, #First_Name#
#DATEFORMAT(Logon_Date,"mm/dd/yyyy")#
#TIMEFORMAT(Logon_Date,"hh:mm:ss tt")#

Quiz Log!

1 = Home Health IQ
2 = Project Manager

Name Test Date Time Results Role
#Last_Name#, #First_Name#
#Test#
#DATEFORMAT(Date,"mm/dd/yyyy")#
#TIMEFORMAT(Date,"hh:mm:ss tt")#
#Accuracy#
#eaRole#