SELECT * FROM #agency_db#.patients_ai WHERE created_by = #session.EmployeeID# ORDER BY pt_ai_id DESC LIMIT 1 UPDATE #agency_db#.patients_ai SET eligibility_status = 'PENDING', eligibility_response = , verification_date = , modified_date = , modified_by = WHERE pt_ai_id = #GetLatestRecord.pt_ai_id# UPDATE #agency_db#.patients_ai SET eligibility_status = 'ERROR', error_code = 'UPLOAD_FAILED', error_message = , modified_date = , modified_by = WHERE pt_ai_id = #GetLatestRecord.pt_ai_id#