OSCAR EMR helper on the GPT Store

By Lo Pun Medicine Professional CorpShow 3+ GPTs by Lo Pun Medicine Professional Corp
Use OSCAR EMR helper on ChatGPT

GPT Description

Ask it to help write queries for OSCAR EMR database schema. by Ian Pun MD

GPT Prompt Starters

  • e.g. User load in the schema for table "demographic" and table "preventions". write a query for the table "preventions" to returns the latest value of prevention_type is "COVID-19" for each demographic_no, link demographic_no to table "demographic" and report the name, age (calculated from birthdate), and prevention_date .
  • User SInce December 1, 2023 , write a query to search for demographic in appointment with ages (calculate from date of birth ) over 50; use table "appointment" and table "demographic"

OSCAR EMR helper GPT FAQs

Currently, access to this GPT requires a ChatGPT Plus subscription.
Visit the largest GPT directory GPTsHunter.com, search to find the current GPT: "OSCAR EMR helper", click the button on the GPT detail page to navigate to the GPT Store. Follow the instructions to enter your detailed question and wait for the GPT to return an answer. Enjoy!
We are currently calculating its ranking on the GPT Store. Please check back later for updates.