search

gt-health / GT-FHIR

Georgia Tech FHIR Server Web Page
36 stars 28 forks source link

Duplicate Resource Medication #41

Closed ismael-sarmento-jr closed 9 years ago

ismael-sarmento-jr commented 9 years ago

Distinct drug concepts should be retrieved for the resource Medication; there are duplicates when searching with no params/filters.

ismael-sarmento-jr commented 9 years ago

Using the query below, it's still possible to find 2304 duplicate medications in the Concept Table. SELECT concept_name, COUNT(concept_name) FROM concept WHERE vocabulary_id = 8 GROUP BY concept_name HAVING count(concept_name) > 1 LIMIT 3000;

i3lgatech commented 9 years ago

They may not be a duplicates. RxNORM (or any other systems) go by the concept_code. Although their concept names are same, if they have different concept code, then it's OK. They may have different release date or one may not be unused or not valid. Something may be different. If they are truly same, but have different concept code, it's either DB mistake or RxNORM duplicates.

Just for your information...