SELECT e.Address1, e.City, e.State, e.Zip as empZip, e.Last_Name, e.First_Name ,z.zip, z.latitude, z.longitude FROM #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_lookup#.zipcodes z WHERE e.Employee_Id = '#url.empId#' AND z.zip >= e.Zip ORDER BY z.zip LIMIT 10
Beginning Latitude / Longitude based on the Employee's home Zip Code could not be determined for the Route Planner
SELECT si.Visit_Date, si.Visit_Type, si.StartTime, si.EndTime, si.Visit_Notes, si.Telephony_Yes, si.Telephony_Id, si.Telephony_ItemNumber ,p.Last_Name_M0040, p.First_Name_M0040, p.Street_Address, p.City, p.State_M0050, p.Zip_M0060, p.Telephone FROM #Request.prefix_db_agency#.ScheduleItems si, #Request.prefix_db_agency#.patient p WHERE si.ScheduleItems_Id IN (#url.sids#) AND si.Agency_Id = '#session.AgencyId#' AND si.Employee_Id = '#url.empId#' AND p.Patient_Id = si.Patient_Id ORDER BY si.StartTime ASC, si.ScheduleItems_Id ASC ArrayAppend(letters, 'A'); ArrayAppend(letters, 'B'); ArrayAppend(letters, 'C'); ArrayAppend(letters, 'D'); ArrayAppend(letters, 'E'); ArrayAppend(letters, 'F'); ArrayAppend(letters, 'G'); ArrayAppend(letters, 'H'); ArrayAppend(letters, 'I'); ArrayAppend(letters, 'J'); ArrayAppend(letters, 'K'); ArrayAppend(letters, 'L'); ArrayAppend(letters, 'M'); ArrayAppend(letters, 'N'); ArrayAppend(letters, 'O'); ArrayAppend(letters, 'P'); ArrayAppend(letters, 'Q'); ArrayAppend(letters, 'R'); ArrayAppend(letters, 'S'); ArrayAppend(letters, 'T'); ArrayAppend(letters, 'U'); ArrayAppend(letters, 'V'); ArrayAppend(letters, 'W'); ArrayAppend(letters, 'X'); ArrayAppend(letters, 'Y'); ArrayAppend(letters, 'Z');
No Scheduled Visits were found. Please try again.
<cfoutput>Route Planner for #eZip.First_Name# #eZip.Last_Name# on #url.d# - by MyHomeCareBiz.com</cfoutput>
Route Planner for #eZip.First_Name# #eZip.Last_Name# on #url.d# - by MyHomeCareBiz.com
#letters[x]# Start #eZip.First_Name# #eZip.Last_Name#
#eZip.Address1#
#eZip.City#, #eZip.State# #eZip.empZip#
 
#letters[x]# Patient #gv.First_Name_M0040# #gv.Last_Name_M0040#
  Address #gv.Street_Address#
#gv.City#, #gv.State_M0050# #gv.Zip_M0060#
  Phone #gv.Telephone#
  Visit Type #gv.Visit_Type#
  Visit Times #gv.StartTime# to #gv.EndTime#
  Telephony #gv.Telephony_Id#
  Visit Notes #gv.Visit_Notes#