PheKnowVec_Source_String_Synonym_Query

source_string_synonym_query.sql

-- Query Template: find synonyms between source strings and an OMOP terminology concept codes 
SELECT DISTINCT
lower(source_string) AS source_code,
lower(concept_synonym_name) AS source_name,
"String" AS input_type,
domain_id AS source_domain,
"None" AS source_vocabulary

FROM 
(SELECT DISTINCT
 cs.concept_synonym_name,
 c.domain_id,
 CASE
  {0}
  ELSE "NOT A MATCH TO SOURCE STRING" END AS source_string

 FROM CHCO_DeID_Oct2018.concept c
 JOIN CHCO_DeID_Oct2018.concept_synonym cs
 ON cs.concept_id = c.concept_id
 WHERE c.domain_id IN ("Drug"))
WHERE source_string != "NOT A MATCH TO SOURCE STRING";