Skip to content

Record which tables are included in omopcat #128

@milanmlft

Description

@milanmlft

Definition of Done / Acceptance Criteria

As a user, I want to know which OMOP tables are included in the catalogue so I have an idea of which concepts I can expect to find.

Testing

No response

Documentation

Document the included tables somewhere visible in the app. Maybe in the help page?

Dependencies

No response

Details and Comments

Example case: a researcher is interested in patient ethnicity so tries searching for that in the catalogue, but this won't show up as the person table is not included in the pre-processed data.

The tables currently included are visible in the monthly_counts preprocessing, but we should record them somewhere more accessible.

arg_list <- list(
list(
omop_table = cdm[["measurement"]],
concept_col = "measurement_concept_id",
date_col = "measurement_date"
),
list(
omop_table = cdm[["observation"]],
concept_col = "observation_concept_id",
date_col = "observation_date"
),
list(
omop_table = cdm[["condition_occurrence"]],
concept_col = "condition_concept_id",
date_col = "condition_start_date"
),
list(
omop_table = cdm[["drug_exposure"]],
concept_col = "drug_concept_id",
date_col = "drug_exposure_start_date"
),
list(
omop_table = cdm[["procedure_occurrence"]],
concept_col = "procedure_concept_id",
date_col = "procedure_date"
),
list(
omop_table = cdm[["device_exposure"]],
concept_col = "device_concept_id",
date_col = "device_exposure_start_date"
),
list(
omop_table = cdm[["specimen"]],
concept_col = "specimen_concept_id",
date_col = "specimen_date"
)
)

Metadata

Metadata

Assignees

No one assigned

    Labels

    documentationImprovements or additions to documentation

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions