... | @@ -38,10 +38,11 @@ To sum-up we have: |
... | @@ -38,10 +38,11 @@ To sum-up we have: |
|
* CIS-CIP relations in the **ANSM-database**
|
|
* CIS-CIP relations in the **ANSM-database**
|
|
* CIS-UCD relations in our local hospital database system
|
|
* CIS-UCD relations in our local hospital database system
|
|
|
|
|
|
|
|
By following the path UCD-CIS-CIP we can find mappings between UCD codes and standards concepts.
|
|
|
|
|
|
### Mapping process
|
|
### Mapping process
|
|
We have a total of 11,096 French drugs in our hospital database system that were administered at least one time.
|
|
We have a total of 11,096 French drugs in our hospital database system, drugs 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.
|
|
In this git 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
|
|
```sql
|
|
SELECT DRUG_SOURCE_CONCEPT_ID, COUNT(*) AS FREQUENCY FROM OMOP.DRUG_EXPOSURE
|
|
SELECT DRUG_SOURCE_CONCEPT_ID, COUNT(*) AS FREQUENCY FROM OMOP.DRUG_EXPOSURE
|
... | | ... | |