SELECT pEmployee.*,Agency.Agency_Login FROM hhapowerpath.pEmployee JOIN hhapowerpath.Agency ON Agency.Agency_ID = pEmployee.Loc_ID WHERE pEmployee.Username = AND pEmployee.Password = AND pEmployee.Emp_Type = 'Employee' AND pEmployee.Status = 0 SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = '#Request.prefix_db_agency#'; SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE Loc_ID = AND Status IN (0,1,4) SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = '#Request.prefix_db_agency#'; SELECT pSchedules.*, pPatients.Pt_First,pPatients.Pt_Middle,pPatients.Pt_Last FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status = 0 JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Patient_ID = pSchedules.Patient_ID AND pAssessments.Status = 0 JOIN #Request.prefix_db_agency#.pAuths ON pSchedules.Auth_ID = pAuths.Auth_ID AND pAuths.status = 0 JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pAuths.Rev_ID AND pRevenue_Code.status = 0 JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.status =0 WHERE pSchedules.Status = 0 AND pSchedules.Missed = 0 AND pSchedules.Patient_ID = #arguments.Patient_ID# AND pSchedules.Visit_Date = '#DateFormat(arguments.Visit_Date,"yyyy-mm-dd")#' AND pSchedules.Schedule_ID = '#arguments.Schedule_ID#' AND pSchedules.Emp_ID = #arguments.Emp_ID# GROUP BY pSchedules.Schedule_ID SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = '#Request.prefix_db_agency#'; SELECT pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Status = 0 AND pSchedules.Schedule_ID = '#arguments.Schedule_ID#' UPDATE #Request.prefix_db_agency#.pPatients SET Pt_Longitude = '#arguments.GPS_start_longitude#', Pt_Latitude = '#arguments.GPS_start_latitude#' WHERE pPatients.Status IN (0,1,4) AND Patient_ID = '#get_sched.Patient_ID#' SELECT pSchedules.*,pPatients.* FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status IN (0,1,4) WHERE pSchedules.Status = 0 AND pSchedules.Schedule_ID = '#arguments.Schedule_ID#' visit_longitude:"& #arguments.GPS_start_longitude# & "
Pt_Latitude:" & #Pt_Latitude# & "
Pt_Longitude:" & #Pt_Longitude# /> visit_longitude:"& #arguments.GPS_start_longitude# & "
Pt_Latitude:"& #Pt_Latitude# & "
Pt_Longitude:"& #Pt_Longitude# /> UPDATE #Request.prefix_db_agency#.pSchedules SET GPS_start_time = '#GPS_start_time#', GPS_start_date = '#today_date#', GPS_start_latitude = '#GPS_start_latitude#', GPS_start_longitude = '#GPS_start_longitude#', Change_by = #arguments.Emp_ID#, Date_Change = #now()# WHERE Status = 0 AND pSchedules.Schedule_ID = '#arguments.Schedule_ID#' UPDATE #Request.prefix_db_agency#.pSchedules SET GPS_end_time = '#GPS_end_time#', GPS_end_date = '#today_date#', GPS_end_latitude = '#GPS_end_latitude#', GPS_end_longitude = '#GPS_end_longitude#', Change_by = #arguments.Emp_ID#, Date_Change = #now()# WHERE Status = 0 AND pSchedules.Schedule_ID = '#arguments.Schedule_ID#' SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#arguments.Agency_ID#' SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#arguments.Emp_ID#' SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast,pPatients.Pt_Middle, pPatients.Pt_First AS PatientFirst, pPatients.Pt_Agy_ID,pPatients.Status AS clientStatus,pPatients.Pt_SSN,pPatients.Pt_Street, pPatients.Pt_City,pPatients.Pt_State,pPatients.Pt_Zip,pPatients.Pt_Longitude,pPatients.Pt_Latitude,pPatients.Pt_Phone, pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Skill AS Type, pSchedules.Visit_Type, pSchedules.Total_Units, pSchedules.Mi_Pay,pSchedules.GPS_start_time,pSchedules.GPS_end_time, CASE WHEN length(pSchedules.patient_sign) > 0 THEN true ELSE false END AS patient_sign_indicator, CONCAT(RIGHT(pEmployee.Emp_SSN, 5), LEFT(Emp_Last,4)) AS EmployeeIdentifier, CONCAT(DATE_FORMAT(CONVERT_TZ(pSchedules.Date_Create, @@session.time_zone, '+00:00'),'%Y-%m-%dT%H:%i:%s'), 'Z') AS CallDateTime, pSchedules.Progress_Note, pSchedules.pgnotesdraft,pSchedules.GPS_start_latitude, pSchedules.GPS_start_longitude, pSchedules.Pay_ID, 0 AS No_Days_Progress, "" AS Note_QA , pSchedules.Notes AS Memo, IFNULL(pSchedules.Sch_Latitude,40.34455) AS Sch_Latitude, IFNULL(pSchedules.Sch_Longitude,-21.99383) AS Sch_Longitude, pSchedules.GPS_start_date,pSchedules.GPS_end_date, pSchedules.StartTime,pSchedules.EndTime,pSchedules.Date_Create AS CallDateTime_old, IFNULL(pPtPayer.Sub_HIC,pSchedules.Schedule_ID) AS Sub_HICs, pEmployee.*, pAssessments.Assmt_ID,pAuths.*,pPayer.*,pPtPayer.*,Agency.*,pRevenue_Code.HCPCS,pPhysicians.Phys_NPI,pRevenue_Code.HCPCS FROM #Request.prefix_db_agency#.pSchedules LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status IN (0,1,4) JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID AND pEmployee.Status < 2 LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Patient_ID = pSchedules.Patient_ID AND pAuths.Status =0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.Patient_ID = pPatients.Patient_ID AND pPtPayer.PtPayer_ID = pAuths.PtPayer_ID AND pPtPayer.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_ID = pPatients.Loc_ID AND Agency.Status = 'active' LEFT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pSchedules.Rev_ID AND pRevenue_Code.Status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Emp_ID = pEmployee.Emp_ID AND pPhysicians.Status = 0 WHERE pSchedules.status= 0 AND pSchedules.Emp_ID != 0 AND pSchedules.Missed = '0' AND pSchedules.Visit_Date >= '2024-07-31' AND pSchedules.EVV_Export = 0 AND pSchedules.Schedule_ID IN () GROUP BY pSchedules.Schedule_ID ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pEmployee.Emp_Last ASC, pEmployee.Emp_First ASC, pSchedules.Skill ASC, pSchedules.Visit_Date ASC REQUEST:
RESPONSE: REQUEST:
RESPONSE: Type: #record.type#
Emp_ID: #record.Emp_ID#
Agency_ID: #record.Agency_ID#
Date: #record.date#
Time: #record.time#
Lat: #record.lat#
Lng: #record.lng#

---

SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = '#Request.prefix_db_agency#'; SELECT pSchedules.* FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Status = 0 AND pSchedules.Schedule_ID = '#arguments.Schedule_ID#' UPDATE #Request.prefix_db_agency#.pPatients SET Pt_Longitude = '#arguments.GPS_start_longitude#', Pt_Latitude = '#arguments.GPS_start_latitude#' WHERE pPatients.Status IN (0,1,4) AND Patient_ID = '#get_sched.Patient_ID#' SELECT pSchedules.*,pPatients.* FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status IN (0,1,4) WHERE pSchedules.Status = 0 AND pSchedules.Schedule_ID = '#arguments.Schedule_ID#' SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = '#Request.prefix_db_agency#'; SELECT pSchedules.*, pPatients.Pt_First,pPatients.Pt_Middle,pPatients.Pt_Last FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status = 0 WHERE pSchedules.Status = 0 AND pSchedules.Missed = 0