i2b2 Web Client
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


SEE PAGE 135

Example Box
titleQuestion
Anchor
Example
Example

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.



Note
titleResult

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

 

Info

...