Select a.Agency_Name,a.Agency_Address1,a.Agency_City,a.Agency_State,a.Agency_Zip,a.Agency_Contact_Phone,a.Agency_Fax, a.Natl_Provider_ID,e.Last_Name,e.First_Name,e.Address1,e.Address2,e.City,e.State,e.Zip,e.Home_Phone,e.Cell_Phone,e.Email,e.Birthdate,e.HireDate,e.Terminatdate,e.DistanceTravel,e.CEU_Annual,e.Inservice_Annual,e.Professional,e.Drivers,e.Auto,e.Background,e.Physical,e.CPR,e.TB,e.Skill,e.Skill2,e.Skill3 from #Request.prefix_db_lookup#.Agency a inner join #Request.prefix_db_lookup#.Employee e on a.agency_id = e.agency_id where a.agency_id = #session.AgencyID# and e.Status = 'inactive' AND e.EmployeeType != 'Physician' ORDER BY e.Last_Name

					Inactive
					#GetEmployeeList.Agency_Name# 

					#GetEmployeeList.Agency_Address1# 

					#GetEmployeeList.Agency_City#,   #GetEmployeeList.Agency_State#   #GetEmployeeList.Agency_Zip#   #GetEmployeeList.Agency_Contact_Phone#   #GetEmployeeList.Agency_Fax# 

					#GetEmployeeList.Natl_Provider_ID#

Employee List

						#Last_Name#, #First_Name# #Skill#, #Skill2#, #Skill3#

						#Address1#, #Address2#

						#City#, #State# #Zip#

									Home_Phone:  #Home_Phone#
								
									Cell_Phone:  #Cell_Phone#
								
									Email:  #Email#
								
									BirthDate:   #DateFormat(Birthdate,"dd-mm-yyyy")#
								
									Hire Date:  #DateFormat(HireDate,"dd-mm-yyyy")#
								
									Termination Date:  #DateFormat(Terminatdate,"dd-mm-yyyy")#
								
									Travel Distance
								
									#DistanceTravel#
								
									Annual CEU Requirement
								
									#CEU_Annual#
								
									Annual Inservice Requirement
								
									#Inservice_Annual#
								
									Professional License Expiration
								
									#Professional#
								
									Drivers License Expiration
								
									#Drivers#
								
									Auto Insurance Expiration
								
									#Auto#
								
									Background Check Expiration
								
									#Background#
								
									Physical Expiration
								
									#Physical#
								
									CPR Expiration
								
									#CPR#
								
									TB Expiration
								
									#TB#