Best Gemini prompts for Health Information Technologists and Medical Registrars

Extract all patient records from the past quarter that have a primary diagnosis of diabetes and have been prescribed metformin, then cross-reference these records with our patient portal data to identify any patients who have not viewed their test results in the last 30 days. Output the results in a CSV file with patient IDs, diagnoses, medication lists, and last portal login dates.

Analyze our current care plan templates for patients with chronic obstructive pulmonary disease (COPD) and identify areas where we can reduce unnecessary documentation steps without compromising patient outcomes. Suggest three revised template versions that incorporate more efficient workflows and automate calculation of key metrics such as FEV1 percentages. Provide a comparison table highlighting the changes and potential time savings for each version.

Generate a weekly summary report of all incident escalations related to medication errors that occurred during night shifts. The report should include the date, time, patient ID, nature of the error, and the resolution steps taken. Also, include a bar chart showing the frequency of such incidents over the past month and a list of recommendations for reducing their occurrence, based on historical data and current literature on patient safety.

Design a workflow for integrating our scheduling software with the EHR system to automate the process of updating patient appointment statuses in real-time. This should include APIs for bidirectional data exchange and triggers for sending reminders to patients and notifications to healthcare providers. Provide a step-by-step implementation guide, including sample API calls and database schema changes required for this integration.