SELECT Agency_ID, Agency_Name, agency_login FROM #Request.prefix_db_lookup#.Agency WHERE status = 'active' AND Agency_ID = ORDER BY Agency_Name SELECT id, PatientId, FileName, Title, Notes, Created, CreatedBy FROM #table_files# WHERE Status = 0 AND Notes LIKE AND ( FileName LIKE OR Title LIKE OR Notes LIKE ) ORDER BY Created DESC PowerPath Vertex Updates - System Administration System Admin Home

Intake AI Process - PowerPath will update (from Vertex API)

Clear

Total Records: #allResults.recordcount#

Agency File ID Patient ID File Name Title Created Date Review Choice Date Notes
#Agency_Name# (#agency_login#) #File_ID# #PatientId# #FileName# #Title# #dateFormat(Created, "mm/dd/yyyy")# #timeFormat(Created, "hh:mm:ss tt")# #Review_Date# #Notes#

No files found with "PowerPath will review and update" status.