Post Project Brief: MR Implants and Device LookUp Plugin

Overview

The MR Implants and Device LookUp Plugin is a WordPress-integrated clinical utility designed to help radiology professionals quickly assess MRI safety parameters of implanted medical devices. It leverages data stored in AltusCampus’s internal MySQL databases, connects to OpenAI for enhanced device summaries, and utilizes Zapier automation for backend workflow.

Trigger & Flow

The core automation is powered by a Zap titled “MR Device LookUp Utility – AI” (view published Zap). The workflow is triggered when a new record is added to the adl_implant_device_details_log table in the MySQL database.

Database Tables Involved

• adl_implant_list – Master list of medical devices
• adl_implant_device_details_log – Log of device detail queries
• adl_data_meta_update_log – Stores historical data and OpenAI-modified summaries
• adl_implant_search_log – Records user search text, search URLs, contact ID, and result counts

Zapier + OpenAI Interaction

1. New entry in adl_implant_device_details_log triggers the Zap
2. Zap pulls the device record from adl_implant_list
3. Zap sends the record and a structured prompt to OpenAI to return a compact, HTML-formatted MRI safety summary
4. Upon response, Zap updates the record and logs the change in adl_data_meta_update_log
5. If the “Instructions for Use (IFU)” field is empty, the Zap attempts to:
   • Query the FDA site to retrieve the manufacturer contact
   • Send an email requesting the IFU
6. If IFU data is already present, no further action is taken

Design Decisions

• Manufacturer response tracking: Not implemented (by decision)
• Bulk search/export: Not yet supported; to be added as a feature validation survey item
• OpenAI rate limiting: Result caching should be added – e.g., via Redis or local DB cache – to reduce re-querying the same Device ID

Current Usage

The plugin is actively in use for clinical lookup workflows and supports HTML summary rendering embedded in AltusCampus LMS. Device queries are logged and augmented by AI-generated summaries in near real-time. The workflow supports accurate compliance with MRI safety standards and institutional policies.

Integration Summary

• AltusCampus: Hosts plugin interface and LMS delivery
• Zapier: Manages workflow, database queries, and email IFU requests
• OpenAI: Provides concise, structured HTML summaries based on structured prompts
• FDA Site: Used to find manufacturer contact if IFU is missing