INSERT INTO #Request.prefix_db_agency#.PatientVisitDetails ( ScheduleItems_ID, Intervention_Code, Description, Performed, Assessment_ID, Assessment_Tracker_ID, Type, Agency_ID, Patient_ID, Item_Number, Notes, Record_Creation_Date ) Values ( #ScheduleItems_Id#, '#scode#', '#desc#', 'Yes', #assid#, #atId#, 'Intervention', #agency_id#, #patient_id#, #item#, 'performed', DATE(Now()) ) Delete from #Request.prefix_db_agency#.PatientVisitDetails where Progress_Details_ID='#url.cid#' And ScheduleItems_ID=#url.ScheduleItems_Id# And Assessment_Tracker_ID=#url.atId# 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, ScheduleItems.Telephony_ID, ScheduleItems.Assessment_Tracker_Id 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'