MCH·OMOPLive

Worked example · 01

Menopause in the OMOP vocabularies

A clinical guide to perimenopause and menopause in OMOP: what the vocabulary represents, where each kind of information belongs, how mappings can change meaning, and the questions to resolve before designing a study.

← Back to Learn Example 02: preterm labor → Open in ATHENA ↗ Open in ATLAS demo ↗

Vocabulary release: v5.0 29-AUG-26. A reference for vocabulary representation, clinical interpretation, and research planning.

Domains and clinical concepts

Menopausal status is not confined to Observation, and menopausal symptoms are not confined to one domain. For a primary clinical event, use the standard concept's domain_id to identify the intended OMOP table. A source vocabulary's domain, the concept's name, and its concept_class_id are not substitutes for that field. A symptom can be a Condition; a concept class named “Procedure” can have the Observation or Measurement domain. [1]

Selected standard Condition concepts (6 rows)
ConceptDomainVocabulary and codeClinical interpretation
Premature menopause (198715)ConditionSNOMED 373717006Age at onset and cause still require clinical interpretation.
Menopausal symptom (4071683)ConditionSNOMED 21801002A symptom finding does not independently establish menopausal stage.
Menopausal flushing (4113666)ConditionSNOMED 198436008Menopausal attribution is explicit in the standard concept name.
Menopause present (4128329)ConditionSNOMED 289903006Positive status finding; documentation date is not necessarily onset.
Menopause finding (4172857)ConditionSNOMED 276477006Broad finding; review descendants for the intended clinical meaning.
Difficulty managing menopause (4307543)ConditionSNOMED 423478005Describes management difficulty; does not specify symptoms or stage.
Where primary records are expected (7 rows)
DomainOMOP tableExamples of research content
ConditionCONDITION_OCCURRENCEStage findings, symptom findings, diagnoses, acquired absence of organs.
ObservationOBSERVATIONHistory questions, some status observables, questionnaire responses, treatment-use status.
MeasurementMEASUREMENTHormone tests, some menstrual observables, scale assessments.
ProcedurePROCEDURE_OCCURRENCEHysterectomy, ovarian removal, some counseling or treatment procedures.
DrugDRUG_EXPOSUREHormone and nonhormone products; some IUD product concepts.
DeviceDEVICE_EXPOSUREDevice-domain contraceptives or symptom-management devices.
Meas ValueA result field, commonly value_as_concept_idAn answer or qualifier, interpreted with its question. This is not a separate clinical-event table.

Value-field exception: when a source code has a paired “Maps to” and “Maps to value,” the first mapping identifies the primary event and the second supplies its value. A value concept's domain does not by itself move that answer to another clinical table. See the HRT example below. [2]

Hot flashes and night sweats across domains

Menopausal flushing (4113666) is a valid standard Condition in v5.0 29-AUG-26. Medication-related and patient-reported hot-flash concepts can use Observation. Check the exact concept and its domain when defining symptoms and selecting OMOP tables.

Standard vasomotor examples (12 rows)
Concept and OMOP IDDomainVocabulary and codeInterpretation
Menopausal flushing (4113666)ConditionSNOMED 198436008Menopause is stated in the target name; inspect incoming mappings before assuming the source stated that cause.
Climacteric flushing (4144760)ConditionSNOMED 427368007Climacteric-specific finding.
Postmenopausal flushing (4301021)ConditionSNOMED 403389006Postmenopause is stated in the concept.
Flushing (318566)ConditionSNOMED 238810007Nonspecific flushing; no menopausal cause established.
Night sweats (4181178)ConditionSNOMED 42984000Night sweats without a stated menopausal cause.
Non-menopausal hot flash (46270134)ConditionSNOMED 143661000119109Explicitly non-menopausal; keep separate from menopausal symptoms.
Hot flash caused by tamoxifen (37174285)ConditionSNOMED 759556531000119104Tamoxifen-attributed hot flash; treatment context differs from spontaneous menopause.
Hot flash caused by aromatase inhibitor (37170543)ObservationSNOMED 968361541000119107Aromatase-inhibitor-attributed symptom in Observation.
Hot flash caused by medication (4231628)ObservationSNOMED 439407002Medication-attributed symptom in Observation.
I have hot flashes in the past 7 days [FACIT] (42868847)ObservationLOINC 70376-9FACIT item; response and recall period are essential. The question alone does not establish symptom presence or menopausal cause.
Did you have hot flashes or chills [Reported.PHQ] (40772136)ObservationLOINC 69710-2PHQ item combines hot flashes with chills; a positive answer cannot distinguish them.
I have night sweats in the past 7 days [FACIT] (42868850)ObservationLOINC 70379-3FACIT night-sweats item; retain its response and seven-day recall period.

Retired terms and mappings can change the apparent clinical meaning

Nonstandard source concepts and their mappings (4 rows)
Source conceptStatus in this releaseMaps toClinical question
Hot flushes (40557760)
SNOMED 390053008
Observation; nonstandard; updated/retired (U)Menopausal flushing (4113666); ConditionDoes the source establish menopause, or only hot flushes?
Hot flushes (40562318)
SNOMED 389318003
Observation; nonstandard; updated/retired (U)Menopausal flushing (4113666); ConditionKeep the historical source identity for interpretation.
Hot flash (40618826)
SNOMED 67443009
Condition; nonstandard; updated/retired (U)Menopausal flushing (4113666); ConditionGeneric source wording maps to menopause-specific wording.
Hot flashes (37432081)
HPO HP_0031217
Observation; valid nonstandard source conceptMenopausal flushing (4113666); ConditionThis is a mapping-specificity concern to review, not proof of a menopausal cause.

Open clinical question: should a vasomotor study distinguish clinician-attributed menopausal symptoms, nonspecific flushing/sweating, medication-associated symptoms, and patient-reported burden? A useful review preserves all four categories until the question is settled. Frequency, severity, bother, and duration are different outcomes; a diagnosis label does not supply each of them.

Perimenopause, menopause, and ovarian insufficiency

Keep the menopausal transition, established postmenopause, premature ovarian insufficiency (POI), early menopause, and induced ovarian dysfunction distinct. The vocabulary includes useful labels, but those labels do not supply complete staging or onset histories.

Stage and status concepts to review (13 rows)
Concept and OMOP IDDomainVocabulary and codeInterpretation
Perimenopausal state (45757505)ConditionSNOMED 161541000119104Explicit perimenopausal-state finding; does not encode a detailed transition stage.
Menopause present (4128329)ConditionSNOMED 289903006Positive menopause finding, not necessarily an onset date or natural cause.
Normal menopause (4034019)ConditionSNOMED 237123000Normal menopause; standard Condition even though it reads like status.
Postmenopausal state (4295261)ConditionSNOMED 76498008Explicit postmenopausal-state finding.
Menopause finding (4172857)ConditionSNOMED 276477006Broad parent. Its descendants include Menopause absent and perimenopause; do not automatically include all descendants for established menopause.
Menopause (4059477)ObservationSNOMED 161712005Observable entity. Inspect the associated answer/value and source context.
Female climacteric state (4113665)ObservationSNOMED 198435007Climacteric observable; not an automatic assertion of established postmenopause.
Menopause absent (4128330)ConditionSNOMED 289904000Negative status; retain for interpretation, not positive cohort entry.
Premenopausal state (4331463)ConditionSNOMED 22636003Premenopausal state, distinct from perimenopause.
Premature menopause (198715)ConditionSNOMED 373717006Premature-menopause label; age at first coding is not age at onset.
Premature ovarian insufficiency (4028935)ConditionSNOMED 237788002POI-specific diagnosis; does not imply permanently absent ovarian activity.
Ovarian failure (193739)ConditionSNOMED 111550004Ovarian failure without premature age encoded.
Primary ovarian failure (4279913)ConditionSNOMED 65846009Primary ovarian failure without premature age encoded.

Perimenopause is also represented by Abnormal perimenopausal bleeding (4201098), Perimenopausal disorder (4141640), Perimenopausal atrophic vaginitis (4255393) and Symptom severity level: perimenopause (4229863). Finding one general perimenopausal-state concept is not evidence that only one relevant concept exists.

Clinical definitions need a named framework

Natural menopause is generally established retrospectively after 12 months without menstruation when another explanation does not apply. Hormonal contraception, hysterectomy, and other causes of absent bleeding require different interpretation. A missing menstrual record is not evidence of amenorrhea. [4]

The ESHRE/ASRM POI guideline distinguishes POI before age 40 from early menopause at ages 40 through 44. Its POI criteria combine at least four months of disordered cycles with FSH above 25 IU/L; repeat FSH is recommended if uncertainty remains. NICE NG23 retains a two-sample POI recommendation. Name the guideline and version chosen for a study instead of assuming one universal laboratory rule. These are clinical definitions to discuss, not validated OMOP algorithms. [5] [4]

Menstrual history, laboratory results, and patient reports

Clinically similar questions can be represented in different domains. LOINC does not mean “laboratory test only,” and SNOMED does not mean “Condition only.” Question concepts need answers, numbers, units, or dates. The event's recording date is not necessarily the date reported in its value.

Menstrual and patient-report examples (11 rows)
Concept and OMOP IDDomainVocabulary and codeInterpretation
Last menstrual period start date (3002314)ObservationLOINC 8665-2LOINC last-menstrual-period date is Observation; retain the reported date.
Date of last menstrual period (4072438)MeasurementSNOMED 21840007SNOMED last-menstrual-period date is Measurement in this release.
Duration of menstrual cycle (4270151)MeasurementSNOMED 364310004Cycle duration is a Measurement; units and repeated observations are needed for change over time.
Menstrual status (3004340)ObservationLOINC 3146-8Menstrual-status question; inspect the coded answer.
Age at menopause (3035281)ObservationLOINC 42802-9LOINC age at menopause; distinguish onset age from age at encounter.
Age at menopause (36676381)ObservationSNOMED 773251000SNOMED age at menopause; same research topic, separate concept.
Have your menstrual periods stopped permanently [PhenX] (40767407)ObservationLOINC 64701-6Periods stopped permanently: Yes/No and cause are required for interpretation.
Cause of menopause [PhenX] (40766612)ObservationLOINC 63891-6Cause of menopause question; useful for natural versus induced categories.
Greene Climacteric Scale (37151821)MeasurementSNOMED 1148241000000105Greene Climacteric Scale concept; distinguish a scale identifier from a completed score.
Assessment using GCS (Greene Climacteric Scale) (37160138)MeasurementSNOMED 1148321000000105Assessment using the Greene scale; does not by itself supply all item responses.
Symptom severity level: perimenopause (4229863)ObservationSNOMED 405163004Perimenopausal symptom severity observable; requires a value.

What remains to be specified

  • Final menstrual period: distinguish an LMP date, an age-at-menopause response, and a retrospectively established final menstrual period. A dedicated final-menstrual-period concept was not identified in this vocabulary review; this is not proof of absence from every vocabulary.
  • Hormone tests: FSH, LH, estradiol, AMH, and inhibin B test concepts are available. Specimen, units, assay, result, timing, and hormone exposure determine interpretation. A test order or a single abnormal value is not a universal menopause definition; routine staging in otherwise healthy people aged 45 or over is often clinical. [4]
  • Patient-reported outcomes: Greene, FACIT, and PhenX-related entries were found. Dedicated standard concepts for MENQOL, the Menopause Rating Scale, and the Kupperman index were not identified by this search. Confirm instrument version, language, scoring, and permissions separately; a vocabulary concept does not grant instrument-use rights.
  • Missing concepts versus incomplete search: search synonyms, component items, panels, answer concepts, and source vocabularies before declaring a gap. A symptom item in a questionnaire is not automatically menopause-specific.

Surgery, induced menopause, and mapping specificity

Separate procedures performed, acquired-absence status, historical questions, and diagnosis labels. Hysterectomy does not establish removal of both ovaries; endometrial ablation does not establish loss of ovarian function. Removal of one ovary, both ovaries, or the last remaining ovary has different implications. Bilateral removal after natural menopause does not date the onset of menopause.

Mapping examples that need clinical interpretation (8 rows)
Source or conceptRepresentation in this releaseQuestion to resolve
ICD10CM N95.2, Postmenopausal atrophic vaginitisAtrophic vaginitis (201078); ConditionThe standard name omits postmenopausal context. Preserve source information if that distinction is essential.
ICD9CM 627.2, Symptomatic menopausal or female climacteric statesMenopause finding (4172857); ConditionA generic target should not automatically establish postmenopause.
ICD9Proc 65.53, removal of both ovaries laparoscopicallyLaparoscopic oophorectomy (42872496); ProcedureThe target name omits bilateral detail. Review the source code.
ICD9Proc 65.63, removal of both ovaries and tubes laparoscopicallyLaparoscopic salpingo-oophorectomy (40488381); ProcedureThe target name omits bilateral detail.
ICD9Proc 68.71, laparoscopic radical vaginal hysterectomyLaparoscopic-assisted vaginal hysterectomy with bilateral salpingo-oophorectomy (40480864); ProcedureTarget wording adds bilateral salpingo-oophorectomy. Verify this mapping discrepancy before inferring ovarian removal.
ICD10CM Z90.721, acquired absence of ovaries, unilateralAcquired absence of ovary (4124796); ConditionThe target does not preserve unilateral detail in its name.
Excision of adnexa of uterus (42872678)Procedure; nonspecific adnexal removalDoes this establish ovarian removal, tubal removal, or insufficient organ detail?
Post-hysterectomy menopause (4175534)Condition; menopause documented after hysterectomyThe mechanism and timing remain uncertain without more evidence.

These are specific mappings or clinical ambiguities for review. They do not justify globally deleting a valid target concept or silently changing the OHDSI vocabulary. Record the source and target IDs, release, relationship, proposed interpretation, and evidence when raising a vocabulary issue.

Keep chemotherapy, radiation, GnRH treatment, and endocrine therapy as separate context. Drug-induced suppression may be temporary, and a product concept does not encode whether ovarian function recovered. Pregnancy, lactation, thyroid/pituitary disorders, hypothalamic amenorrhea, and other explanations should be distinguished rather than pooled into menopause.

Coverage limitation: ICD10PCS content was unavailable for this review, and CPT4 coverage was incomplete. The surgical examples therefore do not establish comprehensive coverage of procedure codes. Historical gravidity counts also do not establish a current pregnancy episode.

Hormone therapy, contraception, and other treatments

Treatment representation spans Drug, Observation, Procedure, and sometimes Device. Keep product, formulation, route, strength, combination ingredients, and intended use separate. A prescription can support a research description of treatment but does not independently establish menopause or its cause.

Treatment groups and their interpretation (8 rows)
GroupRepresentation to inspectOpen question
Systemic menopausal hormone therapyRxNorm/RxNorm Extension ingredients and products; oral, transdermal, and some vaginal systemsWhich products and combinations fit the study definition, and which have ambiguous indications?
Local vaginal therapyProduct-specific vaginal estrogens and prasteroneVaginal route alone does not mean local therapy. Femring has systemic effects; distinguish it from Estring. [9]
Contraceptive productsCombined/progestogen-only pills, rings, implants, injections, and hormonal IUDsContraceptives may also be used during the transition. Do not recategorize them as local menopause therapy solely by route.
Progestogen aloneSeparate ingredient/product group with indication uncertaintyPossible uses include bleeding disorders, endometrial protection, and symptom management. Concurrent estrogen is not a universal requirement for menopause-related use. [8]
Nonhormonal treatmentFezolinetant, elinzanetant, selected paroxetine products; separate off-label ingredientsGabapentin, antidepressants, and other agents have multiple indications. Elinzanetant is a dual NK1/NK3 antagonist. [7]
Historical or country-specific productsCountry and calendar availability alongside vocabulary validityA valid concept is not proof of current approval or availability. The package includes veralipride, withdrawn in Europe. [7]
Herbal and compounded productsIngredients, multi-ingredient products, local/source codes, and uncertaintyVocabulary presence does not establish effectiveness, complete formulation, or use by a patient.
Therapy status and proceduresLong-term current use of postmenopausal hormone replacement therapy (37117536); Observation. Postmenopausal hormone replacement therapy (37110086); Procedure.A treatment-use status or procedure label is not a dispensed drug product.

Contraceptive vaginal rings: ethinyl estradiol/etonogestrel and ethinyl estradiol/segesterone products, including NuvaRing and Annovera, represent hormonal contraception. Classify these products using their ingredients and indications. Vaginal administration alone does not establish local menopausal hormone therapy. [6]

A value-field example: ICD9CM V07.4 maps to 441482 Administrative reason for encounter, with 37110086 Postmenopausal hormone replacement therapy as “Maps to value.” The primary record is an Observation with a therapy value, even though 37110086 has Procedure domain when used as a primary event. A query of only procedure_concept_id would miss that representation. [2]

Organizing concepts for clinical review

A concept set can contain more than one domain. Separate modules often make review easier, but the important rule is that cohort criteria must reach the relevant event tables and, where needed, require the associated value. A Condition criterion does not automatically search Observation. [3]

Suggested review modules (7 rows)
ModuleKeep distinctDecision for the clinician
StagePerimenopause, established postmenopause, negative status, unspecified statusWhich statements directly establish the intended stage?
Cause and ageNatural menopause, surgical/other induced states, POI, early menopause, age-unspecified ovarian failureWhat degree of etiologic and onset-age certainty is needed?
SymptomsMenopause-attributed, nonspecific, treatment-attributed, patient-reportedIs the outcome symptom presence, burden, severity, or menopausal attribution?
Menstrual historyQuestions, answers, dates, cycle duration, bleeding patternsWhat information is needed for a transition or final-period definition?
SurgeryPerformed procedures, organ-absence status, history answers, planned careWhat establishes bilateral ovarian loss and when?
TreatmentSystemic/local therapy, contraceptives, indication-ambiguous drugs, nonhormonal therapyWhich distinctions are necessary for the study?
Supporting contextLabs, competing explanations, cancer therapy, family history, care encountersWhich are supporting evidence, exclusions, or descriptive variables?

Descendants need inspection

Do not switch on descendants for every parent. Under 4172857 Menopause finding, the reviewed hierarchy includes positive menopause, menopause absent, and perimenopause. Under broad menstruation/menopause parents, descendants can extend outside the intended topic. Review the resolved list, not only the selected parent names.

Family-history concepts such as FH: Early menopause (4050823) describe relatives; they may be useful covariates but not the person's own menopausal status. A negative concept can remain useful in a separate interpretation module. Excluding it from a positive set is different from excluding a person forever because a premenopausal record exists.

For each proposed inclusion, record the clinical purpose, domain, standard status, validity, descendant decision, source mappings, required value, and reviewer's rationale. Preserve the vocabulary release and distinguish a semantic concern from a coding or grouping error.

Using ATHENA and ATLAS without a clinical data set

  1. Search ATHENA for the clinical term and its synonyms, then inspect the exact concept page.
  2. Record concept_id, source vocabulary/code, domain, class, standard flag, validity, relationships, and descendants.
  3. In ATLAS, compare the same ID in the vocabulary loaded by that instance. Record the release actually in use; do not assume it matches ATHENA.
  4. Build draft concept sets and inspect their resolved concepts and mapped source codes. Keep unreviewed mappings visible.
  5. Export the reviewed definitions and open questions. Record-count availability is optional at this stage.

ATLAS count columns depend on the configured sources and available analyses. They are not universal counts for menopause. Concept metadata can be reviewed without those counts; source-specific recording, table placement, and clinical completeness require a later data review.

Clinical questions to settle before a study

The immediate deliverable is a clinical interpretation guide and a list of unresolved decisions. The following questions can be answered by reviewing the vocabulary with an OB/GYN, before selecting a data source.

Discussion agenda (10 rows)
TopicQuestion to resolveWhy it changes the research definition
Research targetPerimenopause, documented postmenopause, symptoms, treatment, or early/induced menopause?These are overlapping but different populations and outcomes.
Evidence thresholdWhich direct findings are sufficient, and which require a question-answer pair or corroboration?A symptom, generic parent, test name, or care encounter does not necessarily establish stage.
Onset and timeFirst documentation, reported age, final menstrual period, or a surgery/treatment date?These dates answer different questions.
Early menopause and POIWhich guideline, onset-age cutoffs, and evidence of cause will be used?POI and early menopause should not be combined merely because both occur before 45.
Surgical historyHow will hysterectomy, bilateral ovarian removal, ablation, and uncertain laterality be distinguished?Bleeding cessation and ovarian function are different clinical constructs.
Hormones and contraceptionWhich exposures obscure menstrual patterns, alter tests, or have multiple indications?Treatment can change what a symptom or laboratory record means.
Patient experienceFrequency, severity, bother, sleep, cognition, sexual function, or quality of life?Instrument items and diagnostic codes capture different aspects of experience.
Population definitionHow will reproductive anatomy, recorded sex/gender, age, cancer treatment, and care context be represented?A demographic field alone does not describe reproductive physiology.
Competing explanationsWhich alternative causes need separate categories rather than automatic exclusion?Pregnancy history, lactation, thyroid disease, medications, and other causes have distinct meanings.
Vocabulary questionsWhich discrepancies should be submitted to the vocabulary maintainers, with source and target evidence?A reproducible issue needs a release, IDs, relationship, and a proposed clinical interpretation.

Two candidate designs to discuss later

Documented menopausal status: begin with reviewed positive Condition concepts, then consider validated Observation question-answer pairs as a separate route. State that the index is documentation, not biological onset. Prior-observation rules describe visibility in a future data source; they cannot prove that menopause started within that window.

POI or early menopause: use separate definitions with onset-age evidence and distinguish spontaneous from induced cases. Generic ovarian failure and the age at the first coded encounter are insufficient by themselves. A one-year surgical-history exclusion can miss remote surgery; the relevant history interval needs clinical justification. These are design sketches, not executable or validated phenotypes.

Drafting a research question

Use this form to draft a question after the clinical review. Its data-dependent fields start as unknown, and it does not calculate a feasibility score in this vocabulary-only example. A future data source would be needed to assess recording, cohort size, follow-up, and access. The downloaded JSON is a planning draft.

Possible directions include characterizing documentation of the transition, comparing symptom representations, describing systemic versus local therapy, or examining how surgical history changes the interpretation of menopausal status. Treatment-effect questions additionally require an appropriate comparator, timing, and confounding strategy; vocabulary coverage alone cannot establish those.

Download the two unscored research-question drafts.

Downloads and sources

Downloads: reviewed concept reference; source-mapping examples; vocabulary-only review prompt.

Reference release: v5.0 29-AUG-26. Concept metadata, mappings, and hierarchy examples were checked against vocabulary extracts for this release. The downloads distinguish vocabulary fields from clinical interpretation. Coverage is limited to the concepts and source vocabularies reviewed.

Using this reference in a study

  1. Record the vocabulary release and source vocabularies used by the study.
  2. Verify the selected concepts, source mappings, standard status, and validity in the study environment.
  3. Review descendants and any required answers, units, or dates with the clinician.
  4. Document inclusion decisions, mapping ambiguities, and clinical definitions in the protocol.
  5. Assess recording and phenotype performance when an appropriate clinical data source becomes available.

Questions or suggestions: danielle@boycedatascience.com