|
|
# 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.
|
|
|
* CIP: code for packaging, drugs sold in pharmacies
|
|
|
* UCD: code identifying a drug at the hospital
|
... | ... | @@ -36,9 +36,18 @@ To sum-up we have: |
|
|
* 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.
|
|
|
|
|
|
|