EVV Manual Transmission

This agency is set to Auto-send EVV transmission. Change Agency setup to Review first (manual_trans) to use this report.

EVV automation is not enabled for this agency.

Completed visits that have not been sent to EVV. Rows in red have waited more than 2 hours since the progress note was completed.

SELECT pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Visit_Type, pSchedules.Skill, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Total_Units, pSchedules.Mi_Pay, pSchedules.Sch_Latitude, pSchedules.Sch_Longitude, pSchedules.Date_Change AS Note_Completed_At, pSchedules.HCPCS_ID, pSchedules.Assmt_ID, TIMESTAMPDIFF(HOUR, pSchedules.Date_Change, NOW()) AS Hours_Waiting, pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, pPayer.Pay_ID, pPayer.Pay_Name, IFNULL(NULLIF(TRIM(pPayer.EVV_Payer_ID), ''), pPayer.Payer_No) AS Payer_EVV_ID, IFNULL(NULLIF(TRIM(pRevenue_Code.HCPCS), ''), (SELECT TRIM(rc.HCPCS) FROM #Request.prefix_db_agency#.pRevenue_Code rc WHERE rc.Rev_CodeID = pSchedules.HCPCS_ID AND rc.Status = 0 LIMIT 1) ) AS HCPCS FROM #Request.prefix_db_agency#.pSchedules 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_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pSchedules.HCPCS_ID AND pRevenue_Code.Status = 0 WHERE pSchedules.Status = 0 AND pSchedules.pgnotesdraft = 2 AND pSchedules.Missed = '0' AND pPayer.evv_payer_required IN (1) AND NOT EXISTS ( SELECT 1 FROM #Request.prefix_db_lookup#.EVV e WHERE LOWER(IFNULL(e.API_Type, '')) = 'visits' AND e.Agency_ID = AND e.Schedule_ID = pSchedules.Schedule_ID AND e.status = 0 AND e.San_status LIKE ) AND pPatients.Patient_ID = AND pEmployee.Emp_ID = ORDER BY Hours_Waiting DESC, pSchedules.Visit_Date DESC

Pending transmission: #GetList.recordCount#

Select All	Patient	Employee	Payer	Payer ID	Visit Date	HCPCS	Start	End	Units	Duration	Location	JSON	EVV Status	Waiting (hrs)	Action
	#Pt_Last#, #Pt_First#	#Emp_Last#, #Emp_First#	#Pay_Name# #Pay_Name#	#Payer_EVV_ID#	#DateFormat(Visit_Date, "mm/dd/yyyy")#	#HCPCS#	#TimeFormat(StartTime, "hh:mm tt")#	#TimeFormat(EndTime, "hh:mm tt")#	#Total_Units#	#visitDuration#	#locLat#, #locLng#		#evvStatusDisplay#	#Hours_Waiting#
No visits are waiting for manual EVV transmission.