SELECT Employee.Last_Name as Last_Name, Employee.First_Name as First_Name FROM #Request.prefix_db_lookup#.Employee WHERE Employee.Employee_ID = #url.eid# AND EmployeeType != 'Physician' SELECT Telephony from #Request.prefix_db_lookup#.Agency where Agency_ID = #Session.AgencyId# SELECT patient.Last_Name_M0040, patient.First_Name_M0040, Employee.Last_Name, Employee.First_Name, ScheduleItems.Visit_Type, ScheduleItems.Visit_Notes,ScheduleItems.Progress_Note,ScheduleItems.Telephony_ID,ScheduleItems.Assessment_ID,ScheduleItems.Assessment_Tracker_ID, ScheduleItems.ScheduleItems_ID, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Visit_Date,ScheduleItems.Patient_ID, SuperUsers.Username FROM #Request.prefix_db_agency#.ScheduleItems,#Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_lookup#.SuperUsers, #Request.prefix_db_agency#.Assessment_New WHERE (ScheduleItems.Visit_Date >= #CreateODBCDate(start)# AND ScheduleItems.Visit_Date <= #CreateODBCDate(end)#) AND ScheduleItems.Agency_ID = '#Session.AgencyId#' AND ScheduleItems.Visit_Type = SuperUsers.Password AND ScheduleItems.Telephony_Yes = 1 AND ScheduleItems.Employee_ID = Employee.Employee_ID AND ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID AND ScheduleItems.patient_ID IN (#Session.eventpatientview#) AND Employee.Employee_ID IN (#Session.eventemployeeview#) AND ScheduleItems.Patient_Id = patient.Patient_Id AND Assessment_New.Deleted = 0 AND ScheduleItems.Deleted = 0 ORDER BY Visit_Date, StartTime SELECT * FROM GetAllVisits WHERE Visit_Date = #CreateODBCDate(curntDate)# ORDER BY StartTime Weekly Schedule for #Left(DayOfWeekAsString(DayofWeek(CurntDate)), 9)#, #monthasstring(month(CurntDate))# #Day(CurntDate)#, #Year(CurntDate)#
__________________________________________________________________________________

#ThisDate#
SELECT * FROM GetAllVisits WHERE Visit_Date = #CreateODBCDate(CreateDate(year, month, day))# ORDER BY StartTime

SELECT * FROM #Request.prefix_db_agency#.Pathway_Details WHERE assessment_tracker_id = '#GetDaysVisits.assessment_tracker_id#' AND patient_id = '#GetDaysVisits.patient_id#' AND Skill = '#GetDaysVisits.Username#' AND type = 'intervention' AND Deleted IS NULL AND Resolved_Date IS NULL ORDER BY Pathway_Details_Id, Description

#gettoken(StartTime,1,":")#:#gettoken(StartTime,2,":")#-#gettoken(endTime,1,":")#:#gettoken(endTime,2,":")#	Employee: #Last_Name#, #First_Name# Patient: #Last_Name_M0040#, #First_Name_M0040# Visit Type: #Visit_Type#
	Telephony Hotline: 877-666-9573 Enter 10-Digit Telephony ID: #mid(telephony_id,1,3)#-#mid(telephony_id,4,3)#-#mid(telephony_id,7,4)#
	Service Code: #mid(pdid,len(pdid)-1,2)# - #description#
	#Visit_Notes#