UPDATE #Request.prefix_db_agency#.pSchedules
SET patient_sign = ,
sign_datetime = ,
Sch_Latitude = ,
Sch_Longitude = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
AND pSchedules.status =
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID = '#URL.SID#' AND Status =0
AND EVV_Override = 0
SELECT pPayer.EVV, pPayer.evv_payer_required
FROM #Request.prefix_db_agency#.pSchedules s
LEFT JOIN #Request.prefix_db_agency#.pPtPayer pt ON s.PtPayer_ID = pt.PtPayer_ID AND pt.Status = 0
LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pt.Payer_ID AND pPayer.Status = 0
WHERE s.Schedule_ID =
AND s.Status = 0
SELECT *, '' as CODING_WIZARD FROM #Request.prefix_db_lookup#.Agency WHERE Agency_Id = '#session.AgencyId#'
UPDATE #Request.prefix_db_agency#.pSchedules SET
EVV_end = ,
GPS_end_date = ,
EndTime = ,
GPS_end_time = ,
GPS_end_latitude = ,
GPS_end_longitude = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
ANd Status = 0
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID = '#URL.SID#' AND Status =0
SELECT pPatients.Patient_ID, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle,pAssessments.F26,
pSchedules.Visit_Date
FROM #Request.prefix_db_agency#.pPatients
JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Patient_ID = pPatients.Patient_ID
JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Assmt_ID = pAssessments.Assmt_ID
WHERE pPatients.Patient_ID =
AND pAssessments.Assmt_ID =
AND pSchedules.Schedule_ID =
AND pPatients.status <
AND pAssessments.status =
AND pSchedules.status =
SELECT pSchedules.EVV_Override, pPayer.EVV, pPayer.evv_payer_required
FROM #Request.prefix_db_agency#.pSchedules
LEFT JOIN #Request.prefix_db_agency#.pPtPayer pt ON pSchedules.PtPayer_ID = pt.PtPayer_ID AND pt.Status = 0
LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pt.Payer_ID AND pPayer.Status = 0
WHERE pSchedules.Schedule_ID =
AND pSchedules.Status = 0
#Getpat.Pt_Last#, #Getpat.Pt_First# > visit for #dateformat(Getpat.Visit_Date,'mm/dd/yy')#