SELECT Agency.* FROM #Request.prefix_db_lookup#.Agency WHere status = 'active' and (Agency_ID > 600) ORDER BY Agency_Name HHA System Administration --->

Active Employee

select agency_id,Agency_Name from #Request.prefix_db_lookup#.Agency where status='active' and (Agency_ID > 600) ORDER BY agency_id SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Employee.Email, Employee.Agency_ID, Agency.Agency_Name, Agency.PPInUse, Agency.QBInUse, Agency.PatientFileManagerInUse, Agency.telephony, Agency.BillingSvcs, Agency.CodingSvcs, Employee.Username, Employee.Password, employee_auth.eaRole, employee_auth.eaType ,TA.Employee_ID as EmployeeID, TA.Comment as Comment,TQ.Role,TQ.Step FROM #Request.prefix_db_lookup#.Employee JOIN #Request.prefix_db_lookup#.Agency on Employee.Agency_ID = Agency.Agency_ID JOIN #Request.prefix_db_agency#.employee_auth on Employee.Employee_ID = employee_auth.eaID Left Outer Join #Request.prefix_db_lookup#.Test_Answer TA on TA.Employee_ID = Employee.Employee_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.TestQuestions TQ on (TQ.ROle = substring_index(employee_auth.eaRole,',',1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',2 ), ',', -1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',3 ), ',', -1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',4 ), ',', -1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',5 ), ',', -1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',6 ), ',', -1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',7 ), ',', -1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',8 ), ',', -1) or TQ.ROle = substring_index(substring_index(employee_auth.eaRole,',',9 ), ',', -1)) WHERE Employee.Agency_ID = Agency.Agency_ID and Employee.Employee_ID = employee_auth.eaID AND Agency.Status = 'active' AND Employee.Status = 'active' AND Employee.Password is not null AND Employee.Password != '' AND Agency.Agency_ID = '#myarray[ind]#' and Agency.Status = 'active' AND Employee.EmployeeType = 'Employee' AND TQ.Question_ID > 106 GROUP BY Employee_ID,TQ.Step ORDER BY Agency.Agency_Name,TQ.Step,Employee.Last_Name ASC

#AgencyName[ind]#

SELECT count(TA.Answer) as total,TA.Comment as Comment FROM #Request.prefix_db_lookup#.Test_Answer TA WHERE TA.Employee_ID = #GetEmps.Employee_ID# AND TA.Role LIKE '%#Role#%' AND TA.Step like '%#Step#%' AND TA.Answer = 'No' Group by TA.Role SELECT *,TA.Date as testdate, TA.Comment as Comment FROM #Request.prefix_db_lookup#.Test_Answer TA WHERE TA.Employee_ID = #Employee_ID# AND TA.Role LIKE '%#Role#%' AND TA.Step LIKE '%#Step#%' SELECT * FROM #Request.prefix_db_lookup#.Training_Log TL WHERE TL.Employee = #GetEmps.Employee_ID# AND TL.Train_Step LIKE '%#Step#%'

Employee	Role	Class	Class Date	Any No´s?	Feedback Date	Resend?	Comments	Next Training Date	Next Training Time	Next Trainer	Action
#Last_Name#, #First_Name#	#Role#	#Left(Step,20)#	#DateFormat(GetTraining.Train_Date,"mm/dd/yyyy")#	#GetRecent.total#completednot yet	Encrypted_ID=encrypt(#GetEmps.Employee_ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); #DateFormat(GetTraining_Log.testdate,"YYYY-MM-DD")#	Resend	#GetTraining_Log.Comment#	#DateFormat(GetTraining.Next_Train_Date,"mm/dd/yyyy")#	#GetTraining.Next_Time#	#GetTraining.Next_Trainer#	ADD/Update

Employee	Role	Class	Class Date	Any No´s?	Feedback Date	ResendFeedback	Comments	Next Training Date	Next Training Time	Next Trainer	Action
There is no employee

--->