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) –
- vocabulary_id from the vocabulary table e.g ‘ICD9CM’
- see https://github.com/OHDSI/CommonDataModel/wiki/VOCABULARY for a full list
- 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: 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;