inspectomop.queries.general.standard_vocab_for_source_code

inspectomop.queries.general.standard_vocab_for_source_code(source_code, source_vocab_id, inspector, return_columns=None)

Convert source code to all mapped standard vocabulary concepts.

Parameters:

  • source_codes (str) – alphanumeric source_code to query on e.g ICD-9 ‘250.00’

  • source_vocab_id (str) –

  • inspector (inspectomop.inspector.Inspector)

  • return_columns (list of str, optional) –

    • optional subset of columns to return from the query

    • columns : [‘domain_id’, ‘concept_id’, ‘concept_name’, ‘concept_code’, ‘concept_class_id’, ‘vocabulary_id’, ‘target_concept_domain’]

Returns:

results

Return type:

sqlalchemy.sql.expression.Executable

Notes

Original SQL

G05: Translate a code from a source to a standard vocabulary:

SELECT DISTINCT
    c1.domain_id,
    c2.concept_id         as Concept_Id,
    c2.concept_name       as Concept_Name,
    c2.concept_code       as Concept_Code,
    c2.concept_class_id   as Concept_Class,
    c2.vocabulary_id      as Concept_Vocabulary_ID,
    c2.domain_id          as Target_concept_Domain
FROM
    concept_relationship cr
JOIN
    concept c1 ON c1.concept_id = cr.concept_id_1
JOIN
    concept c2 ON c2.concept_id = cr.concept_id_2
WHERE
    cr.relationship_id = 'Maps to' AND
    c1.concept_code IN ('070.0') AND
    c1.vocabulary_id = 'ICD9CM' AND
    sysdate BETWEEN cr.valid_start_date AND cr.valid_end_date;