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: 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;