inspectomop.queries.drug.drug_classes_for_drug_concept_id

inspectomop.queries.drug.drug_classes_for_drug_concept_id(concept_id, inspector, return_columns=None)

Returns drug classes for drug or ingredient concept_ids.

Parameters:

• concept_id (int)

• inspector (inspectomop.inspector.Inspector)

• return_columns (list of str, optional) –

  • optional subset of columns to return from the query

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

Returns:

results

Return type:

sqlalchemy.sql.expression.Executable

Notes

Original SQL

D08: Find drug classes for a drug or ingredient:

SELECT
    c1.concept_id                Class_Concept_Id,
    c1.concept_name              Class_Name,
    c1.concept_code              Class_Code,
    c1.concept_class_id          Classification,
    c1.vocabulary_id             Class_vocabulary_id,
    v1.vocabulary_name           Class_vocabulary_name,
    ca.min_levels_of_separation  Levels_of_Separation
FROM
    concept_ancestor             ca,
    concept                      c1,
    vocabulary                   v1
WHERE
    ca.ancestor_concept_id = c1.concept_id
    AND    c1.vocabulary_id IN ('NDFRT', 'ETC', 'ATC', 'VA Class')
    AND    c1.concept_class_id IN ('ATC','VA Class','Mechanism of Action','Chemical Structure','ETC','Physiologic Effect')
    AND    c1.vocabulary_id = v1.vocabulary_id
    AND    ca.descendant_concept_id = 1545999
    AND    sysdate BETWEEN c1.valid_start_date AND c1.valid_end_date;