SELECT pPayer.evv_payer_required, pPayer.Pay_ID, pPayer.Pay_Name, pPtPayer.Payer_Responsibility FROM #agencyDb#.pPtPayer JOIN #agencyDb#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID WHERE pPtPayer.Patient_ID = AND pPtPayer.Status = 0 AND pPayer.Status = 0 AND pPayer.evv_payer_required IN (1) LIMIT 1 SELECT Agency_ID FROM #lookupDb#.Agency WHERE Agency_ID = AND Status = AND EVV_prod_username IS NOT NULL AND EVV_prod_password IS NOT NULL AND EVV_username IS NOT NULL AND EVV_password IS NOT NULL SELECT San_status FROM #lookupDb#.EVV WHERE LOWER(API_Type) = AND Agency_ID = AND Patient_ID = AND status = ORDER BY EVV_ID DESC LIMIT 1 SELECT EVV_Status, Job_Status FROM #lookupDb#.EVV_Patient_Automation WHERE Agency_ID = AND Patient_ID = AND Job_Status IN () ORDER BY Automation_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV_Patient_Automation SET Job_Status = , Date_Update = WHERE Agency_ID = AND Patient_ID = AND Job_Status IN () INSERT INTO #Request.prefix_db_lookup#.EVV_Patient_Automation ( Agency_ID, Patient_ID, Admit_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_Patient_Automation SET Job_Status = , Transmit_Result = , Status_Check_Start = , Status_Check_End = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Patient_Automation SET Job_Status = , Last_Error = , Date_Update = WHERE Automation_ID = ]+>", "", "all"))>

EVV Patient Transmit Error

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

Server: #envLabel#

Agency ID: #arguments.agencyID#

Patient ID: #arguments.patientID#

Employee ID: #arguments.employeeID#

EVV component: #getSandataComponentName(arguments.agencyID)#

Error: #htmlEditFormat(arguments.errorMessage)#

SELECT EVV_ID FROM #lookupDb#.EVV WHERE LOWER(API_Type) = AND Agency_ID = AND Patient_ID = AND status = ORDER BY EVV_ID DESC LIMIT 1 UPDATE #lookupDb#.EVV SET San_status = , Date_Update = WHERE EVV_ID = SELECT * FROM #Request.prefix_db_lookup#.EVV_Patient_Automation WHERE Job_Status IN () AND Agency_ID = ORDER BY Automation_ID ASC LIMIT 100 UPDATE #Request.prefix_db_lookup#.EVV_Patient_Automation SET Job_Status = , EVV_Status = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Patient_Automation SET Job_Status = , Transmit_Result = , Status_Check_Start = , Status_Check_End = , Last_Error = NULL, Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Patient_Automation SET Job_Status = , Last_Error = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Patient_Automation SET Job_Status = , Date_Update = WHERE Automation_ID = UPDATE #Request.prefix_db_lookup#.EVV_Patient_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_Patient_Automation SET Last_Error = , Date_Update = WHERE Automation_ID =

EVV Patient 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 patient automation jobs required processing on this run.

#local.mailBody# SELECT Automation_ID, Job_Status, EVV_Status FROM #Request.prefix_db_lookup#.EVV_Patient_Automation WHERE Agency_ID = AND Patient_ID = AND Job_Status IN () ORDER BY Automation_ID DESC LIMIT 1 SELECT Automation_ID, Job_Status FROM #Request.prefix_db_lookup#.EVV_Patient_Automation WHERE Agency_ID = AND Patient_ID = AND Job_Status IN () ORDER BY Automation_ID DESC LIMIT 1 SELECT Automation_ID, Job_Status FROM #Request.prefix_db_lookup#.EVV_Patient_Automation WHERE Agency_ID = AND Patient_ID = AND Job_Status <> ORDER BY Automation_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV_Patient_Automation SET EVV_Status = , Job_Status = , Status_Check_Count = Status_Check_Count + 1, Last_Status_Check = , Last_Error = NULL, Date_Update = WHERE Automation_ID =