i2b2 Developer's Forum
Space shortcuts
Space Tools

Versions Compared

Key

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

...

Introduced in Core i2b2 Version 1.6

© Shawn Murphy 2010


In the 1.6 Release of i2b2 we introduce the idea of "Query Timing". Query Timing is a way of specifying co-occurring events. In the Query Timing used in the i2b2 User Interface up to this release, concepts were assumed to be co-occurring in the same patient. In 1.6, the idea gets extended to concepts that co-occur in one visit.

...

Wiki Markup
\\
\[c_name\] = patients that had a visit when they were 40-45 years old
\[c_fullpath\] =
\\
 encounter detail\ age at visit\ 40 -- 45 y/o
\[c_facttablecolumnname\]  = encounter_num
\[c_tablename\]  = visit_dimension
\[c_columnname\]  = start_date
\[c_operator\] = BETWEEN
\[c_dimcode\] =
((select birth_date from patient_dimension
where patient_num = visit_dimension.patient_num)
+ (365.25 * 40))
AND
((select birth_date from patient_dimension
where patient_num = visit_dimension.patient_num)
+ (365.25 * 45))

© Shawn Murphy 2010