SELECT DISTINCT pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Date_Change, pSchedules.Change_by, IFNULL(log.Change_Memo, '') AS Change_Memo, pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, pEmployee.Emp_Email, EVV.EVV_ID, EVV.Date_Create AS EVV_Transmission_Date, EVV.San_status, EVV.Created_by AS EVV_Created_By, IFNULL(pAssessments.Assmt_ID, 0) AS Assmt_ID, IFNULL(log.Update_Log_ID, 0) AS Update_Log_ID, IFNULL(log.Reason_Code_ID, 0) AS Reason_Code_ID, rc.Description AS Reason_Code_Description, IFNULL(log.Date_Reason_Added, '') AS Date_Reason_Added, IFNULL(log.Changed_By_Email, '') AS Changed_By_Email 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 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 LEFT JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID AND pPtPayer.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT JOIN #Request.prefix_db_lookup#.EVV ON EVV.Schedule_ID = pSchedules.Schedule_ID AND EVV.API_type = 'visits' AND EVV.Agency_ID = #session.AgencyId# AND EVV.EVV_ID = ( SELECT MAX(EVV_ID) FROM #Request.prefix_db_lookup#.EVV WHERE Schedule_ID = pSchedules.Schedule_ID AND API_type = 'visits' AND San_status LIKE '%Data Changed%' AND San_status LIKE '%Retransmission Required%' ) LEFT JOIN #Request.prefix_db_lookup#.EVV_Update_Log log ON log.Update_Log_ID = ( SELECT MAX(Update_Log_ID) FROM #Request.prefix_db_lookup#.EVV_Update_Log WHERE Schedule_ID = pSchedules.Schedule_ID AND Agency_ID = #session.AgencyId# AND Status = 0 ) LEFT JOIN #Request.prefix_db_lookup#.EVV_Reason_Codes rc ON rc.Reason_Code_ID = log.Reason_Code_ID WHERE pSchedules.status = 0 AND pSchedules.Emp_ID != 0 AND pSchedules.Missed = '0' AND pPayer.EVV = 0 AND EVV.EVV_ID IS NOT NULL AND EVV.Status = 0 AND (EVV.San_status LIKE '%Data Changed%' OR EVV.San_status LIKE '%Retransmission Required%' OR EVV.San_status LIKE 'Transmitted - %') AND pSchedules.Date_Change IS NOT NULL 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 ) AND pSchedules.Assmt_ID != 0 GROUP BY pSchedules.Schedule_ID ORDER BY pSchedules.Date_Change DESC, pPatients.Pt_Last ASC, pPatients.Pt_First ASC SELECT DISTINCT p.Patient_ID, p.Pt_Last, p.Pt_First FROM #Request.prefix_db_agency#.pPatients p JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Patient_ID = p.Patient_ID LEFT JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID AND pPtPayer.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT JOIN #Request.prefix_db_lookup#.EVV ON EVV.Schedule_ID = pSchedules.Schedule_ID AND EVV.API_type = 'visits' AND EVV.Agency_ID = #session.AgencyId# AND EVV.San_status LIKE '%Data Changed%' AND EVV.San_status LIKE '%Retransmission Required%' WHERE p.Loc_ID = '#session.agencyid#' AND p.Status < 2 AND pSchedules.status = 0 AND pSchedules.Emp_ID != 0 AND pSchedules.Missed = '0' AND pPayer.EVV = 0 AND EVV.EVV_ID IS NOT NULL AND pSchedules.Date_Change IS NOT NULL 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 DISTINCT e.Emp_ID, e.Emp_Last, e.Emp_First FROM #Request.prefix_db_lookup#.pEmployee e JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Emp_ID = e.Emp_ID LEFT JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID AND pPtPayer.Status = 0 LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT JOIN #Request.prefix_db_lookup#.EVV ON EVV.Schedule_ID = pSchedules.Schedule_ID AND EVV.API_type = 'visits' AND EVV.Agency_ID = #session.AgencyId# AND EVV.San_status LIKE '%Data Changed%' AND EVV.San_status LIKE '%Retransmission Required%' WHERE e.Loc_ID = '#session.agencyid#' AND e.Emp_Type = 'employee' AND e.Status < 2 AND pSchedules.status = 0 AND pSchedules.Emp_ID != 0 AND pSchedules.Missed = '0' AND pPayer.EVV = 0 AND EVV.EVV_ID IS NOT NULL AND pSchedules.Date_Change IS NOT NULL ORDER BY e.Emp_Last ASC, e.Emp_First ASC SELECT Reason_Code_ID, Description FROM #Request.prefix_db_lookup#.EVV_Reason_Codes WHERE Status = 0 ORDER BY Reason_Code_ID SELECT Emp_Email, Emp_First, Emp_Last FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID =
EVV Update Log
EVV Transmitted Datasets EVV Visits
" /> to " />
Date Format: mm/dd/yyyy

Total Updated Visits: #GetList.recordcount#

# Visit ID Visit Date Client Name Date/Time of Update Change Reason Memo Change Made By Reason Code Reason Code Description EVV Status Action Status
#currentRow# #Schedule_ID# #DateFormat(Visit_Date, "mm/dd/yyyy")# #PatientLast#, #PatientFirst# #DateFormat(Date_Change, "mm/dd/yyyy")# #TimeFormat(Date_Change, "HH:mm")# N/A #changedByEmail# #Reason_Code_Description# Not yet assigned #San_status# #San_status# #San_status# #San_status# No status

Reason Code Added Pending Reason Code