SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, patient.Patient_ID, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Agency_Assigned_ID, ScheduleItems.ScheduleItems_ID, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Mileage, ScheduleItems.Visit_Notes FROM #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems WHERE ScheduleItems.ScheduleItems_ID = #url.scheduleItems_ID# And patient.Patient_ID = ScheduleItems.Patient_ID And ScheduleItems.Employee_ID = Employee.Employee_ID AND Employee.EmployeeType != 'Physician' SELECT ScheduleItems.ScheduleItems_ID ,PatientVisitDetails.Progress_Details_ID, PatientVisitDetails.Description, PatientVisitDetails.Type ,PatientVisitDetails.Notes, PatientVisitDetails.ScheduleItems_ID FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.PatientVisitDetails WHERE ScheduleItems.ScheduleItems_ID = #url.scheduleItems_ID# And ScheduleItems.ScheduleItems_ID = PatientVisitDetails.ScheduleItems_ID ORDER BY PatientVisitDetails.Type Desc

#First_Name_M0040# #Last_Name_M0040# (#Agency_Assigned_ID#) #Visit_Type#

#DateFormat(Visit_Date,"mm/dd/yyyy")#, #StartTime# - #EndTime#, #First_Name# #Last_Name#

Visit Notes:

#HTMLEditFormat(Visit_Notes)#

_______________________________________________________________________
_______________________________________________________________________

#Type#	Notes
Intervention	Notes

#Description#

#Notes#