inst/QueryLibrary/Assign/concept_name/observation.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

observation

Description

This query loads the observation table and adds a few useful columns by joining it to the concept table.

Query

SELECT o.person_id, o_name.concept_name as observation_name, o.observation_concept_id, o.observation_date, o_type.concept_name as observation_type,o.value_as_number,o.value_as_string, o.value_as_concept_id, o.qualifier_concept_id, o_unit.concept_name as unit, o.provider_id, o.visit_occurrence_id, o.visit_detail_id, vo.visit_source_value as visit_label
FROM @cdm.observation AS o 
LEFT JOIN @cdm.visit_occurrence as vo ON o.visit_occurrence_id = vo.visit_occurrence_id
LEFT JOIN @vocab.concept as o_name ON o.observation_concept_id = o_name.concept_id
LEFT JOIN @vocab.concept as o_type ON o.observation_type_concept_id = o_type.concept_id
LEFT JOIN @vocab.concept as o_unit ON o.unit_concept_id = o_unit.concept_id

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.