SELECT pPayer.evv_payer_required, pPayer.Pay_ID, pPayer.Pay_Name FROM #agencyDb#.pSchedules s LEFT JOIN #agencyDb#.pPtPayer pt ON s.PtPayer_ID = pt.PtPayer_ID AND pt.Status = 0 LEFT JOIN #agencyDb#.pPayer ON pPayer.Status = 0 AND ( (pt.PtPayer_ID IS NOT NULL AND pPayer.Pay_ID = pt.Payer_ID) OR (s.Pay_ID IS NOT NULL AND s.Pay_ID > 0 AND pPayer.Pay_ID = s.Pay_ID) ) WHERE s.Schedule_ID = AND s.Status = 0 AND pPayer.evv_payer_required IN (1) LIMIT 1 SELECT UUID FROM #Request.prefix_db_lookup#.EVV WHERE LOWER(API_Type) = AND Agency_ID = AND Schedule_ID = AND status = ORDER BY EVV_ID DESC LIMIT 1

EVV Visit Transmit Error

Time: #dateTimeFormat(now(), "yyyy-mm-dd HH:nn:ss")#

Agency ID: #arguments.agencyID#

Schedule ID: #arguments.scheduleID#

Employee ID: #arguments.employeeID#

Error: #htmlEditFormat(arguments.errorMessage)#

SELECT EVV_ID FROM #lookupDb#.EVV WHERE LOWER(API_Type) = AND Agency_ID = AND Schedule_ID = AND status = ORDER BY EVV_ID DESC LIMIT 1 UPDATE #lookupDb#.EVV SET San_status = , Date_Update = WHERE EVV_ID = UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , Date_Update = WHERE Agency_ID = AND Schedule_ID = AND Job_Status IN () INSERT INTO #Request.prefix_db_lookup#.EVV_Visit_Automation ( Agency_ID, Schedule_ID, Patient_ID, Trigger_Source, Job_Status, Transmit_At, Status_Check_Start, Status_Check_End, Created_By, Date_Create, Date_Update ) VALUES ( , , , , , , , , , , ) UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , Transmit_Result = , Transaction_ID = , Status_Check_Start = , Status_Check_End = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , Last_Error = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , Date_Update = WHERE Agency_ID = AND Schedule_ID = AND Job_Status IN () INSERT INTO #Request.prefix_db_lookup#.EVV_Visit_Automation ( Agency_ID, Schedule_ID, Patient_ID, Trigger_Source, Job_Status, Transmit_At, Transmit_Result, Transaction_ID, Status_Check_Start, Status_Check_End, Created_By, Date_Create, Date_Update ) VALUES ( , , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_lookup#.EVV_Visit_Automation WHERE Job_Status IN () AND Agency_ID = ORDER BY Automation_ID ASC LIMIT 100 UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , Transmit_Result = , Transaction_ID = , Status_Check_Start = , Status_Check_End = , Last_Error = NULL, Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , Last_Error = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Job_Status = , EVV_Status = , Status_Check_Count = Status_Check_Count + 1, Last_Status_Check = , Last_Error = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET Last_Error = , Date_Update = WHERE Automation_ID = SELECT e.Agency_ID, e.Schedule_ID, e.San_status, e.Date_Create FROM #Request.prefix_db_lookup#.EVV e WHERE LOWER(e.API_Type) = AND e.status = AND e.San_status = AND e.UUID IS NOT NULL AND TRIM(e.UUID) <> '' AND e.Agency_ID IN () AND e.Agency_ID = AND NOT EXISTS ( SELECT 1 FROM #Request.prefix_db_lookup#.EVV_Visit_Automation a WHERE a.Agency_ID = e.Agency_ID AND a.Schedule_ID = e.Schedule_ID AND a.Job_Status IN () ) ORDER BY e.EVV_ID ASC LIMIT 50 SELECT Automation_ID, Job_Status, EVV_Status FROM #Request.prefix_db_lookup#.EVV_Visit_Automation WHERE Agency_ID = AND Schedule_ID = AND Job_Status IN () ORDER BY Automation_ID DESC LIMIT 1 SELECT Automation_ID, Job_Status FROM #Request.prefix_db_lookup#.EVV_Visit_Automation WHERE Agency_ID = AND Schedule_ID = AND Job_Status IN () ORDER BY Automation_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV_Visit_Automation SET EVV_Status = , Job_Status = , Status_Check_Count = Status_Check_Count + 1, Last_Status_Check = , Last_Error = NULL, Date_Update = WHERE Automation_ID =

EVV Visit Automation Cron Run

Run time: #dateTimeFormat(arguments.summary.ranAt, "yyyy-mm-dd HH:nn:ss")#

Server: #envLabel#

Fatal error: #arguments.fatalError.message#

Detail: #arguments.fatalError.detail#

Pending jobs found	#arguments.summary.jobsFound#
Transmitted	#arguments.summary.transmitted#
Status polls	#arguments.summary.polled#
Completed	#arguments.summary.completed#
Failed	#arguments.summary.failed#

Details

#htmlEditFormat(local.detailItem)#

Errors

#htmlEditFormat(local.errorItem)#

No pending EVV visit automation jobs required processing on this run.

#local.mailBody#