Skip to content

Add concept_id columns to person_demography_mv (country of birth, language) #21

Description

@GhazalehNiknam

Problem or motivation

person_demography_mv only exposes decoded text for country of birth and language spoken, not the underlying OMOP concept_id, needed to join this data against other OMOP-standard tables and vocabularies.

Proposed solution

Add value_as_concept_id to the person_cob and person_lang subqueries in demography_queries.py, and add matching columns to demographics_join and the PersonDemography ORM class.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions