SELECT Agency.Agency_Name,
Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Employee.Address1, Employee.City, Employee.State,
Employee.Zip, Employee.Home_Phone, Employee.Soc_Sec_No, Employee.Gender, Employee.Birthdate,
Employee_Payroll.Pay_Rate, Employee_Payroll.Measure, Employee_Payroll.EmpPay_ID,
Agency_Payroll.Visit_Type, Agency_Payroll.Description
FROM #Request.prefix_db_lookup#.Agency, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.Employee_Payroll, #Request.prefix_db_agency#.Agency_Payroll
Where Agency.Agency_ID = Employee.Agency_ID
AND Employee.Employee_ID = Employee_Payroll.Employee_ID
AND Employee_Payroll.Payroll_ID = Agency_Payroll.Payroll_ID
AND Agency.Status = 'active'
AND Employee.Status = 'active'
AND Employee.EmployeeType != 'Physician'
And Agency.QBInUse = 1
AND Employee_Payroll.QB_Export = 0
Order by Agency_Name, Last_Name
Employee List
Superadmin Home
Unexported Employees
___________________________________
#Agency_Name#: #Last_Name#, #First_Name# #Address1# #City#, #State# #Zip#
#Home_Phone# #Soc_Sec_No#, #Gender#, #DATEFORMAT(Birthdate,"mm/dd/yyyy")#
#Visit_Type# - #Description# #Pay_Rate#/#Measure#