Find patients who have a diagnosis of Acute MI documented at any time in their history and they have a medication with a dose greater than 500 mg and a medication that is taken once a day documented during the same instance.



There are 3 patients who have had

  • A medication with a dose of 500 mg and 
  • AND a frequency of once a day entered as a fact in the observation_fact table
  • Where the medication dose and frequency have the same encounter_num , concept_cd, provider_id, start_date, AND instance_num
  • AND the diagnosis of acute MI
  • AND the medication dose and frequency all have the same patient_num



Step-by-step guide

Add the steps involved:

  1. Insert your steps.
  2. You can also copy and paste or drag and drop images into your instructions.

 

You may also want to use visual panels to communicate related information, tips or things users need to be aware of.

Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.



Related issues