Manual EVV Status Update

Manual EVV Status Update

This script finds visits that were successfully transmitted but have been updated since, and flags them for retransmission.

Preview: Visits That Will Be Flagged

SELECT pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Date_Change, pSchedules.StartTime, pSchedules.EndTime, pPatients.Pt_Last, pPatients.Pt_First, pEmployee.Emp_Last, pEmployee.Emp_First, EVV.EVV_ID, EVV.Date_Create AS EVV_Date, EVV.San_status FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pSchedules.Emp_ID LEFT JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID LEFT JOIN #Request.prefix_db_lookup#.EVV ON EVV.Schedule_ID = pSchedules.Schedule_ID AND EVV.API_type = 'visits' AND EVV.status = 2 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 status = 2 ) 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.San_status LIKE '%SUCCESS%' OR EVV.San_status LIKE '%Transaction Received%' OR EVV.San_status = 'Transmitted') AND pSchedules.Date_Change IS NOT NULL AND pSchedules.Date_Change > DATE_ADD(EVV.Date_Create, INTERVAL 2 MINUTE) AND pSchedules.Assmt_ID != 0 ORDER BY pSchedules.Date_Change DESC LIMIT 100
Found #previewVisits.recordcount# visits that need EVV status update
Schedule ID Patient Employee Visit Date Start/End Time Date Changed EVV Date Current Status
#Schedule_ID# #Pt_Last#, #Pt_First# #Emp_Last#, #Emp_First# #DateFormat(Visit_Date, "mm/dd/yyyy")# #StartTime# - #EndTime# #DateFormat(Date_Change, "mm/dd/yyyy HH:mm")# #DateFormat(EVV_Date, "mm/dd/yyyy HH:mm")# #San_status#
Go to EVV Update Log
No visits found that need EVV status update

All transmitted visits are up to date.

Go to EVV Update Log

Updating EVV Status...

UPDATE #Request.prefix_db_lookup#.EVV SET San_status = 'Data Changed - Retransmission Required' WHERE EVV_ID IN ( SELECT EVV.EVV_ID FROM #Request.prefix_db_agency#.pSchedules LEFT JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID LEFT JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID LEFT JOIN #Request.prefix_db_lookup#.EVV ON EVV.Schedule_ID = pSchedules.Schedule_ID AND EVV.API_type = 'visits' AND EVV.status = 2 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 status = 2 ) 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.San_status LIKE '%SUCCESS%' OR EVV.San_status LIKE '%Transaction Received%' OR EVV.San_status = 'Transmitted') AND pSchedules.Date_Change IS NOT NULL AND pSchedules.Date_Change > DATE_ADD(EVV.Date_Create, INTERVAL 2 MINUTE) AND pSchedules.Assmt_ID != 0 )
✓ Updated EVV Status Successfully!

Updated #updateEVVStatus.recordcount# EVV records to "Data Changed - Retransmission Required"


Run Again Go to EVV Update Log