SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Skill AS Type, pSchedules.Visit_Type, pSchedules.Progress_Note, pSchedules.pgnotesdraft, pSchedules.Pay_ID, 0 AS No_Days_Progress, "" AS Note_QA , pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, pAssessments.Assmt_ID 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 < 2 JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID AND pEmployee.Status < 2 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.Visit_Date BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# AND pPatients.patient_id = '#FORM.pid#' AND pEmployee.Emp_ID = '#FORM.eid#' AND pPatients.Patient_ID IN (SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 AND pAssessments.Status =0 ) 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 SELECT p.Patient_ID, p.Pt_Last, p.Pt_First, p.Status FROM #Request.prefix_db_agency#.pPatients p WHERE p.Loc_ID = '#session.agencyid#' AND p.Status < 2 AND p.Patient_ID IN (SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 AND pAssessments.Status =0 ) ORDER BY p.Pt_Last ASC, p.Pt_First ASC SELECT e.Emp_ID, e.Emp_Last, e.Emp_First, e.Status FROM #Request.prefix_db_lookup#.pEmployee e WHERE e.Loc_ID = '#session.agencyid#' AND e.Emp_Type = 'employee' ORDER BY e.Emp_Last ASC, e.Emp_First ASC
EVV Visits Ready For Export
" /> to " />
Date Format: mm/dd/yyyy
Patient Employee Visit Date Skill Visit Type
#PatientLast#, #PatientFirst# #Emp_Last#, #Emp_First# #DateFormat(Visit_Date,"mm/dd/yyyy")# #Type# routine visit#Visit_Type#