Changes

Page history
Update drugs authored by Cossin Sebastien's avatar Cossin Sebastien
Show whitespace changes
Inline Side-by-side
drugs.md
View page @ 3b19e101
# Local terminology # Mappings French drugs
## CIS - CIP - UCD definition: ## CIS - CIP - UCD definition
* CIS: code identifying a drug approved by French National Agency (ANSM) to be sold in France. * CIS: code identifying a drug approved by French National Agency (ANSM) to be sold in France.
* CIP: code for packaging, drugs sold in pharmacies * CIP: code for packaging, drugs sold in pharmacies
* UCD: code identifying a drug at the hospital * UCD: code identifying a drug at the hospital
...@@ -36,9 +36,18 @@ To sum-up we have: ...@@ -36,9 +36,18 @@ To sum-up we have:
* CIS-UCD relations in our local hospital database system * CIS-UCD relations in our local hospital database system
### Mapping process
We have a total of 11,096 French drugs in our hospital database system that were administered at least one time.
In this repository we removed all drugs prescribed less than 30 times (see drugs_to_map.csv file). Only 7.4% of our hospital drugs don't have a UCD code.
```sql
SELECT DRUG_SOURCE_CONCEPT_ID, COUNT(*) AS FREQUENCY FROM OMOP.DRUG_EXPOSURE
GROUP BY DRUG_SOURCE_CONCEPT_ID
```
**463 drugs and 835 drugs** represent 80% and 90% administered drugs in our hospital, respectively.
#### Automatic mappings
To reuse the mappings of the BDPM, we use the CIS relations in the ANSM-database to perform two joins. Among drugs that have a UCD codes, we found that 82% can be mapped by using the UCD-CIS-CIP path to find a standard concept. Some UCD codes map to CIP code, others map to CIS codes.
In the ANSM database was integrated in Athena, 100% of hospital drugs that have a UCD could be integrated.