SELECT EVV_ID, San_status, API_Type, Agency_ID FROM #Request.prefix_db_lookup#.EVV WHERE Patient_ID = AND Agency_ID = AND API_Type IN ('visits', 'clients') AND status = 0 UPDATE #Request.prefix_db_lookup#.EVV SET San_status = 'Data Changed - Retransmission Required', Date_Update = NOW() WHERE Patient_ID = AND Agency_ID = AND API_Type = 'clients' AND status = 0 AND ( (San_status IS NOT NULL AND UPPER(San_status) LIKE '%SUCCESS%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%TRANSMITTED%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%TRANSACTION RECEIVED%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%DATA CHANGED%') OR San_status = '' OR San_status IS NULL ) AND ( San_status IS NULL OR ( UPPER(San_status) NOT LIKE '%FAILED%' AND UPPER(San_status) NOT LIKE '%ERROR%' AND UPPER(San_status) NOT LIKE '%REJECTED%' ) ) UPDATE #Request.prefix_db_lookup#.EVV SET San_status = 'Data Changed - Retransmission Required', Date_Update = NOW() WHERE Patient_ID = AND Agency_ID = AND API_Type = 'clients' AND status = 0 AND ( San_status IS NULL OR San_status = '' OR (San_status IS NOT NULL AND UPPER(San_status) NOT LIKE '%FAILED%' AND UPPER(San_status) NOT LIKE '%ERROR%' AND UPPER(San_status) NOT LIKE '%REJECTED%') ) SELECT EVV_ID, San_status, API_Type, Agency_ID FROM #Request.prefix_db_lookup#.EVV WHERE Emp_ID = AND Agency_ID = AND API_Type IN ('employee') AND status = 0 UPDATE #Request.prefix_db_lookup#.EVV SET San_status = 'Data Changed - Retransmission Required', Date_Update = NOW() WHERE Emp_ID = AND Agency_ID = AND API_Type = 'employee' AND status = 0 AND ( (San_status IS NOT NULL AND UPPER(San_status) LIKE '%SUCCESS%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%TRANSMITTED%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%TRANSACTION RECEIVED%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%DATA CHANGED%') OR San_status = '' OR San_status IS NULL ) AND ( San_status IS NULL OR ( UPPER(San_status) NOT LIKE '%FAILED%' AND UPPER(San_status) NOT LIKE '%ERROR%' AND UPPER(San_status) NOT LIKE '%REJECTED%' ) ) UPDATE #Request.prefix_db_lookup#.EVV SET San_status = 'Data Changed - Retransmission Required', Date_Update = NOW() WHERE Emp_ID = AND Agency_ID = AND API_Type = 'employee' AND status = 0 AND ( San_status IS NULL OR San_status = '' OR (San_status IS NOT NULL AND UPPER(San_status) NOT LIKE '%FAILED%' AND UPPER(San_status) NOT LIKE '%ERROR%' AND UPPER(San_status) NOT LIKE '%REJECTED%') ) UPDATE #Request.prefix_db_lookup#.EVV SET San_status = 'Data Changed - Retransmission Required', Date_Update = NOW() WHERE Schedule_ID = AND Agency_ID = AND API_Type = 'visits' AND status = 0 AND ( (San_status IS NOT NULL AND UPPER(San_status) LIKE '%SUCCESS%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%TRANSMITTED%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%TRANSACTION RECEIVED%') OR (San_status IS NOT NULL AND UPPER(San_status) LIKE '%DATA CHANGED%') OR San_status = '' OR San_status IS NULL ) AND ( San_status IS NULL OR ( UPPER(San_status) NOT LIKE '%FAILED%' AND UPPER(San_status) NOT LIKE '%ERROR%' AND UPPER(San_status) NOT LIKE '%REJECTED%' ) ) UPDATE #Request.prefix_db_agency#.pSchedules SET EVV_Reason_Code_ID = NULL WHERE Schedule_ID = AND Status = 0 UPDATE #Request.prefix_db_lookup#.EVV_Update_Log SET Status = 1, Change_Memo = NULL WHERE Schedule_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.agencyId#' 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 p.*, a.Agency_Name, a.Natl_Provider_ID FROM #Request.prefix_db_agency#.pPatients p LEFT JOIN #Request.prefix_db_lookup#.Agency a ON p.Loc_ID = a.Agency_ID WHERE p.Patient_ID = #Patient_ID# AND p.Status IN (0,1,4) SELECT pPayer.M0150 AS paymentsource,pPtPayer.*,pPayer.*, (SELECT Eligibility.Start_Date FROM #Request.prefix_db_agency#.Eligibility WHERE Eligibility.Patient_ID = pPtPayer.Patient_ID AND Eligibility.PtPayer_ID = pPtPayer.PtPayer_ID AND Eligibility.Status = 0 ORDER BY Start_Date DESC LIMIT 0,1) AS Start_Date FROM #Request.prefix_db_agency#.pPtPayer JOIN #Request.prefix_db_agency#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID WHERE pPtPayer.Patient_ID = #Patient_ID# AND pPtPayer.Status = 0 AND pPayer.Status = 0 ORDER BY pPtPayer.PtPayer_ID DESC LIMIT 1
" />

AHCCCS Client Upload Failed

Patient Information:

  • Name: #Pt_First# #Pt_Last#
  • Patient ID: #Patient_ID#
  • Agency ID: #session.agencyid#
  • Medicaid ID: #FormattedMedicaidID#
  • Sequence ID: #Seq_ID#

Error Details:

#error_status#

API Request Payload:

#jsonPayload#

API Response Data:

#cfhttp.FileContent#

Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

 INSERT INTO #Request.prefix_db_lookup#.EVV (UUID, Seq_ID, San_status, API_type, Agency_ID, Patient_ID, Emp_ID, Schedule_ID, Date_Create, Created_by) VALUES ('#UUID#', '#Seq_ID#','#return_status#', 'clients', '#session.agencyid#', #Patient_ID#, 0, 0, #now()#, #session.employeeid#) INSERT INTO #Request.prefix_db_lookup#.EVV_Update_Log ( Schedule_ID, Agency_ID, EVV_ID, Date_Updated, Change_Memo, Changed_By, Changed_By_Email, Status ) VALUES ( 0, , , , , , , 0 )

AHCCCS Client Upload Successful

Patient Information:

  • Name: #Pt_First# #Pt_Last#
  • Patient ID: #Patient_ID#
  • Agency ID: #session.agencyid#
  • Medicaid ID: #FormattedMedicaidID#
  • Sequence ID: #Seq_ID#

API Response:

  • UUID: #UUID#
  • API Status: #api_return_status#
  • Initial Status (in system): #return_status#
  • Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

API Request Payload:

#jsonPayload#

API Response Data:

#SerializeJSON(responseData)#

The client has been successfully uploaded to AHCCCS EVV system with initial status "Transmitted - Initial submission". Use check status to get the current transaction status.

The client has been successfully uploaded to AHCCCS EVV system.

 " />

AHCCCS Client Upload Error

Patient Information:

  • Name: #Pt_First# #Pt_Last#
  • Patient ID: #Patient_ID#
  • Agency ID: #session.agencyid#
  • Medicaid ID: #FormattedMedicaidID#
  • Sequence ID: #Seq_ID#

Error Details:

#return_status#

HTTP Status Code: #cfhttp.StatusCode#

API Request Payload:

#jsonPayload#

API Response Data:

#cfhttp.FileContent#

Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

 SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.agencyId#' 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 * FROM #Request.prefix_db_lookup#.pEmployee WHERE Status = 0 AND Emp_ID = #Employee_ID#

AHCCCS Employee Upload Successful

Employee Information:

  • Employee Name: #GetEmp.Emp_First# #GetEmp.Emp_Last#
  • Employee ID: #GetEmp.Emp_ID#
  • Employee SSN: #GetEmp.Emp_SSN#
  • Employee Email: #GetEmp.Emp_Email#
  • Position: #GetEmp.Skill_1#
  • Hire Date: #DateFormat(now(), "yyyy-mm-dd")#
  • End Date: #EmployeeEndDate#
  • Agency ID: #session.agencyid#
  • Sequence ID: #Seq_ID#

API Response:

  • UUID: #UUID#
  • API Status: #api_return_status#
  • Initial Status (in system): #return_status#
  • Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

API Request Payload:

#serializeJSON(Request.stFields)#

API Response Data:

#SerializeJSON(structureData)#

The employee has been successfully uploaded to AHCCCS EVV system with initial status "Transmitted - Initial submission". Use check status to get the current transaction status.

The employee has been successfully uploaded to AHCCCS EVV system.

AHCCCS Employee Upload Failed

Employee Information:

  • Employee Name: #GetEmp.Emp_First# #GetEmp.Emp_Last#
  • Employee ID: #GetEmp.Emp_ID#
  • Employee SSN: #GetEmp.Emp_SSN#
  • Employee Email: #GetEmp.Emp_Email#
  • Position: #GetEmp.Skill_1#
  • Hire Date: #DateFormat(now(), "yyyy-mm-dd")#
  • End Date: #EmployeeEndDate#
  • Agency ID: #session.agencyid#
  • Sequence ID: #Seq_ID#

Error Details:

#return_status#

API Request Payload:

#serializeJSON(Request.stFields)#

API Response Data:

#httpEVVResponse.FileContent#

Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

The employee upload failed. Please check the error details above.

 INSERT INTO #Request.prefix_db_lookup#.EVV (UUID, Seq_ID, San_status, API_type, Agency_ID, Patient_ID, Emp_ID, Schedule_ID, Date_Create, Created_by) VALUES ('#UUID#', '#Seq_ID#','#return_status#', 'employee', '#session.agencyid#', 0, #GetEmp.Emp_ID#, 0, #now()#, #session.employeeid#) INSERT INTO #Request.prefix_db_lookup#.EVV_Update_Log ( Schedule_ID, Agency_ID, EVV_ID, Date_Updated, Change_Memo, Changed_By, Changed_By_Email, Status ) VALUES ( 0, , , , , , , 0 ) " />

AHCCCS Employee Upload Error

Employee Information:

  • Employee Name: #GetEmp.Emp_First# #GetEmp.Emp_Last#
  • Employee ID: #GetEmp.Emp_ID#
  • Employee SSN: #GetEmp.Emp_SSN#
  • Employee Email: #GetEmp.Emp_Email#
  • Position: #GetEmp.Skill_1#
  • Hire Date: #DateFormat(now(), "yyyy-mm-dd")#
  • End Date: #EmployeeEndDate#
  • Agency ID: #session.agencyid#
  • Sequence ID: #Seq_ID#

Error Details:

#return_status#

API Request Payload:

#serializeJSON(Request.stFields)#

API Response Data:

#httpEVVResponse.FileContent#

HTTP Response Code: #httpEVVResponse.responseHeader.Status_Code#

Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

The employee upload encountered an error. Please check the error details above.

AHCCCS Employee Upload Error

Employee Information:

  • Employee Name: #GetEmp.Emp_First# #GetEmp.Emp_Last#
  • Employee ID: #GetEmp.Emp_ID#
  • Employee SSN: #GetEmp.Emp_SSN#
  • Employee Email: #GetEmp.Emp_Email#
  • Position: #GetEmp.Skill_1#
  • Agency ID: #session.agencyid#

Error Details:

An unexpected error occurred during the employee upload process.

Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

The employee upload encountered an unexpected error. Please check the system logs for more details.

 SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.agencyId#' 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 pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_Middle, pPatients.Pt_First AS PatientFirst, pPatients.Pt_Agy_ID, pPatients.Status AS clientStatus, pPatients.Pt_SSN, pPatients.Pt_Street, pPatients.Pt_City, pPatients.Pt_State, pPatients.Pt_Zip, pPatients.Pt_Longitude, pPatients.Pt_Latitude, pPatients.Pt_Phone, pPatients.Email, pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Skill AS Type, pSchedules.Visit_Type, pSchedules.Total_Units, pSchedules.Mi_Pay, pSchedules.GPS_start_time, pSchedules.GPS_end_time, pSchedules.patient_sign, pSchedules.Date_Change, pSchedules.Change_by, pSchedules.EVV_Reason_Code_ID, CASE WHEN length(pSchedules.patient_sign) > 0 THEN true ELSE false END AS patient_sign_indicator, CONCAT(RIGHT(pEmployee.Emp_SSN, 5), LEFT(Emp_Last,4)) AS EmployeeIdentifier, CONCAT(DATE_FORMAT(CONVERT_TZ(pSchedules.Date_Create, @@session.time_zone, '+00:00'),'%Y-%m-%dT%H:%i:%s'), 'Z') AS CallDateTime, pSchedules.Progress_Note, pSchedules.pgnotesdraft, pSchedules.GPS_start_latitude, pSchedules.GPS_start_longitude, pSchedules.GPS_end_latitude, pSchedules.GPS_end_longitude, pSchedules.Pay_ID, 0 AS No_Days_Progress, "" AS Note_QA, pSchedules.Notes AS Memo, IFNULL(pSchedules.Sch_Latitude,40.34455) AS Sch_Latitude, IFNULL(pSchedules.Sch_Longitude,-21.99383) AS Sch_Longitude, pSchedules.GPS_start_date, pSchedules.GPS_end_date, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Date_Create AS CallDateTime_old, (TIME_TO_SEC(TIMEDIFF(pSchedules.EndTime,pSchedules.StartTime))/3600) AS totalhours, IFNULL(pPtPayer.Sub_HIC,pSchedules.Schedule_ID) AS Sub_HICs, pEmployee.*, pAssessments.Assmt_ID, pAuths.*, pPayer.*, pPtPayer.*, Agency.*, pRevenue_Code.HCPCS, pRevenue_Code.Modifier, pPhysicians.Phys_NPI 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 LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status IN (0,1,4) JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID AND pEmployee.Status < 2 LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Patient_ID = pSchedules.Patient_ID AND pAuths.Auth_ID = pSchedules.Auth_ID AND pAuths.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.Patient_ID = pPatients.Patient_ID AND pPtPayer.PtPayer_ID = pAuths.PtPayer_ID AND pPtPayer.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_ID = pPatients.Loc_ID AND Agency.Status = 'active' LEFT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pSchedules.HCPCS_ID AND pRevenue_Code.Status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Emp_ID = pEmployee.Emp_ID AND pPhysicians.Status = 0 WHERE pSchedules.status = 0 AND pSchedules.Emp_ID != 0 AND pSchedules.Missed = '0' AND pSchedules.Visit_Date >= '2024-07-31' AND pSchedules.EVV_Export = 0 AND pSchedules.Schedule_ID IN () GROUP BY pSchedules.Schedule_ID ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pEmployee.Emp_Last ASC, pEmployee.Emp_First ASC, pSchedules.Skill ASC, pSchedules.Visit_Date ASC SELECT UUID, San_status, Date_Create, Seq_ID as Original_Seq_ID FROM #Request.prefix_db_lookup#.EVV WHERE API_Type = 'visits' AND Agency_ID = '#session.agencyid#' AND Schedule_ID = '#Sch_ID#' AND status = 0 ORDER BY EVV_ID DESC LIMIT 1 SELECT Visit_Date, StartTime, EndTime, GPS_start_time, GPS_end_time, GPS_start_date, GPS_end_date, GPS_start_latitude, GPS_start_longitude, GPS_end_latitude, GPS_end_longitude, Emp_ID, Total_Units, Mi_Pay, Notes, patient_sign FROM #Request.prefix_db_agency#.pSchedules WHERE Schedule_ID = '#Sch_ID#' AND status = 2 ORDER BY Date_Create DESC LIMIT 1 SELECT rc.Reason_Code_ID, rc.Description, ul.Change_Memo, ul.Date_Updated, ul.Changed_By, ul.Changed_By_Email FROM #Request.prefix_db_lookup#.EVV_Update_Log ul LEFT JOIN #Request.prefix_db_lookup#.EVV_Reason_Codes rc ON rc.Reason_Code_ID = ul.Reason_Code_ID WHERE ul.Schedule_ID = '#Sch_ID#' AND ul.Status = 0 ORDER BY ul.Date_Reason_Added DESC LIMIT 1 SELECT Emp_Email FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = LIMIT 1 --->

Visit Data Confirmation

Please review the following data before submission:

Visit Information

Patient Name: #GtSched.PatientFirst# #GtSched.PatientLast#
Patient ID: #GtSched.Patient_ID#
Client Identifier (Medicaid ID): #ClientIdentifier#
Schedule ID: #GtSched.Schedule_ID#
Visit Date: #DateFormat(GtSched.Visit_Date, "yyyy-mm-dd")#
Visit Type: #GtSched.Type#

Employee Information

Employee Name: #GtSched.Emp_First# #GtSched.Emp_Last#
Employee ID: #GtSched.Emp_ID#
Employee Identifier: #EmployeeIdentifier#

Time Information

Scheduled Start Time: #Start_Time#
Scheduled End Time: #End_Time#
Actual Start Time: #Start_Time#
Actual End Time: #End_Time#
Hours to Bill: #Total_Hours#
Hours to Pay: #Total_Hours#

Billing Information

Provider ID: #LOCAL.ProviderID#
Payer ID: #PayerID#
Payer Program: #PayerProgram#
Procedure Code (HCPCS): #ProcedureCode#
Modifier: #Modifier1Value#
Sequence ID: #Seq_ID#

Notes/Memo

#Left(Trim(GtSched.Memo), 511)#

Is all the information correct?

View JSON Payload (Click to expand) 
#jsonPayload#

AHCCCS Visit Upload Successful

Visit Information:

  • Patient Name: #GtSched.PatientFirst# #GtSched.PatientLast#
  • Patient ID: #GtSched.Patient_ID#
  • Schedule ID: #GtSched.Schedule_ID#
  • Employee: #GtSched.Emp_First# #GtSched.Emp_Last#
  • Visit Date: #DateFormat(GtSched.Visit_Date, "yyyy-mm-dd")#
  • Visit Type: #GtSched.Type#
  • Agency ID: #session.agencyid#
  • Sequence ID: #Seq_ID#

API Response:

  • UUID: #UUID#
  • API Status: #api_return_status#
  • Initial Status (in system): #return_status#
  • Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

API Request Payload:

#jsonPayload#

API Response Data:

#SerializeJSON(structureData)#

The visit has been successfully uploaded to AHCCCS EVV system with initial status "Transmitted - Initial submission". Use check status to get the current transaction status.

 " /> " />

AHCCCS Visit Upload Failed

Visit Information:

  • Patient Name: #GtSched.PatientFirst# #GtSched.PatientLast#
  • Patient ID: #GtSched.Patient_ID#
  • Schedule ID: #GtSched.Schedule_ID#
  • Employee: #GtSched.Emp_First# #GtSched.Emp_Last#
  • Visit Date: #DateFormat(GtSched.Visit_Date, "yyyy-mm-dd")#
  • Visit Type: #GtSched.Type#
  • Agency ID: #session.agencyid#
  • Sequence ID: #Seq_ID#

Error Summary:

#error_summary#

Error Details:

#error_details#

API Request Payload:

#jsonPayload#

API Response Data:

#httpEVVResponse.FileContent#

Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

The visit upload failed. Please check the error details above.

 INSERT INTO #Request.prefix_db_lookup#.EVV (UUID, Seq_ID, San_status, API_type, Agency_ID, Patient_ID, Emp_ID, Schedule_ID, Date_Create, Created_by) VALUES ('#UUID#', '#Seq_ID#','#return_status#', 'visits', '#session.agencyid#', #GtSched.Patient_ID#, #GtSched.Emp_ID#, #GtSched.Schedule_ID#, #now()#, #session.employeeid#) UPDATE #Request.prefix_db_lookup#.EVV_Update_Log SET Status = 1 WHERE Schedule_ID = AND Status = 0 INSERT INTO #Request.prefix_db_lookup#.EVV_Update_Log ( Schedule_ID, Agency_ID, EVV_ID, Date_Updated, Change_Memo, Changed_By, Changed_By_Email, Reason_Code_ID, Status ) VALUES ( , , , , , , , , NULL, 0 ) " />

AHCCCS Visit Upload Error

Visit Information:

  • Patient Name: #GtSched.PatientFirst# #GtSched.PatientLast#
  • Patient ID: #GtSched.Patient_ID#
  • Schedule ID: #GtSched.Schedule_ID#
  • Employee: #GtSched.Emp_First# #GtSched.Emp_Last#
  • Visit Date: #DateFormat(GtSched.Visit_Date, "yyyy-mm-dd")#
  • Visit Type: #GtSched.Type#
  • Agency ID: #session.agencyid#
  • Sequence ID: #Seq_ID#

Error Details:

#return_status#

API Request Payload:

#jsonPayload#

API Response Data:

#httpEVVResponse.FileContent#

HTTP Response Code: #httpEVVResponse.responseHeader.Status_Code#

Upload Date: #DateFormat(now(), "yyyy-mm-dd")# #TimeFormat(now(), "HH:mm:ss")#

The visit upload encountered an error. Please check the error details above.

 SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.agencyId#' 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 Pt_First, Pt_Last FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = '#Patient_ID#' AND status IN (0,1,4) SELECT UUID FROM #Request.prefix_db_lookup#.EVV WHERE API_Type = 'clients' AND Agency_ID = '#session.agencyid#' AND status = 0 AND Patient_ID = '#Patient_ID#' ORDER BY EVV_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV SET San_status = , Date_Update = NOW() WHERE UUID = AND API_Type = 'clients' AND Agency_ID = '#session.agencyid#' AND Patient_ID = '#Patient_ID#' AND status = 0

AHCCCS Client Status Check Results

Patient Name: #GetPatientInfo.Pt_First#, #GetPatientInfo.Pt_Last#

Patient ID: #Patient_ID#

UUID: #LOCAL.uuid#

Status Check Time: #now()#

Current EVV Status: #currentStatus#

Full API Response:

#httpStatusResponse.Filecontent#

AHCCCS Client Status Check Error

Patient Name: #GetPatientInfo.Pt_First#, #GetPatientInfo.Pt_Last#

Patient ID: #Patient_ID#

Error: No UUID found for this client in EVV table

Status Check Time: #now()#

AHCCCS Client Status Check Error

Patient Name: #GetPatientInfo.Pt_First#, #GetPatientInfo.Pt_Last#

Patient ID: #Patient_ID#

Error: #cfcatch.message#

Status Check Time: #now()#

 SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.agencyId#' 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 Emp_First, Emp_Last FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#Employee_ID#' AND status = 0 SELECT UUID FROM #Request.prefix_db_lookup#.EVV WHERE API_Type = 'employee' AND Agency_ID = '#session.agencyid#' AND status = 0 AND Emp_ID = '#Employee_ID#' ORDER BY EVV_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV SET San_status = , Date_Update = NOW() WHERE UUID = AND API_Type = 'employee' AND Agency_ID = '#session.agencyid#' AND Emp_ID = '#Employee_ID#' AND status = 0

AHCCCS Employee Status Check Results

Employee Name: #GetEmpInfo.Emp_First#, #GetEmpInfo.Emp_Last#

Employee ID: #Employee_ID#

UUID: #LOCAL.uuid#

Status Check Time: #now()#

Current EVV Status: #currentStatus#

Full API Response:

#httpStatusResponse.Filecontent#

AHCCCS Employee Status Check Error

Employee Name: #GetEmpInfo.Emp_First#, #GetEmpInfo.Emp_Last#

Employee ID: #Employee_ID#

Error: No UUID found for this employee in EVV table

Status Check Time: #now()#

AHCCCS Employee Status Check Error

Employee Name: #GetEmpInfo.Emp_First#, #GetEmpInfo.Emp_Last#

Employee ID: #Employee_ID#

Error: #cfcatch.message#

Status Check Time: #now()#

 SELECT * FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.agencyId#' 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 pp.Pt_First, pp.Pt_Last, ps.Schedule_ID FROM #Request.prefix_db_agency#.pSchedules ps INNER JOIN #Request.prefix_db_agency#.pPatients pp ON ps.Patient_ID = pp.Patient_ID WHERE ps.Schedule_ID = '#Schedule_ID#' AND ps.Status = 0 SELECT UUID FROM #Request.prefix_db_lookup#.EVV WHERE API_Type = 'visits' AND Agency_ID = '#session.agencyid#' AND status = 0 AND Schedule_ID = '#Schedule_ID#' ORDER BY EVV_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV SET San_status = , Date_Update = NOW() WHERE UUID = AND API_Type = 'visits' AND Agency_ID = '#session.agencyid#' AND Schedule_ID = '#Schedule_ID#' AND status = 0

AHCCCS Visit Status Check Results

Patient Name: #GetVisitInfo.Pt_First#, #GetVisitInfo.Pt_Last#

Schedule ID: #Schedule_ID#

UUID: #LOCAL.uuid#

Status Check Time: #now()#

Current EVV Status: #currentStatus#

Full API Response:

#httpStatusResponse.Filecontent#

AHCCCS Visit Status Check Error

Patient Name: #GetVisitInfo.Pt_First#, #GetVisitInfo.Pt_Last#

Schedule ID: #Schedule_ID#

Error: No UUID found for this visit in EVV table

Status Check Time: #now()#

AHCCCS Visit Status Check Error

Patient Name: #GetVisitInfo.Pt_First#, #GetVisitInfo.Pt_Last#

Schedule ID: #Schedule_ID#

Error: #cfcatch.message#

Status Check Time: #now()#