i2b2 Web Client
Space shortcuts
Space Tools

Versions Compared

Old Version 3

changes.mady.by.user Rudy Potenzone

Saved on

compared with

New Version Current

changes.mady.by.user Rudy Potenzone

Saved on

Key

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


Example Box
titleExampleQuestion
Anchor
Example
Example

Example:

Patient has 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

RESULTS: there There are 3 patients who have had a

  • A medication with a dose of 500 mg
and
  • and 
  • AND a frequency of once a day entered as a fact in the observation_fact table
, where
  • Where the medication dose and frequency have the same encounter_num , concept_cd, provider_id, start_date,
 ANDinstance_num AND the
  •  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

...