Quick reference

Cheat sheets.

Printable quick-reference sheets; written against OMOP CDM v5.4.

Sheet 01

Concepts, standard vs classification vs source, mappings, the hierarchy, and the SQL patterns you actually write.

Open sheet

Sheet 02

The five moving parts: entry, initial event limit, inclusion, exit and censoring, plus worked patterns and what to export.

Open sheet

Sheet 03

Target and event cohorts, persistence windows, a session flow that works, and how to read the sunburst and the tables.

Open sheet

Each sheet prints cleanly to a few pages. They are written against OMOP CDM v5.4, the version supported by the OHDSI tool stack.

See the sheets do something

Worked examples

Dated walkthroughs that follow one clinical idea from a vocabulary search to a concept set, a cohort, and a research question.

Example 01 · Current as of 1 Aug 2026

Search menopause in ATHENA, find the same concepts in ATLAS, then build a concept set and a cohort from them.

Open the example

Example 02 · Current as of 4 Aug 2026

Preterm labor is not preterm birth, and the vocabulary keeps them apart. Search it, build both concept sets, and see which one your question needs.

Open the example