... | ... | @@ -8,7 +8,7 @@ This article is interesting for coding anesthetists activities (French only): ht |
|
|
|
|
|
# Mapping process
|
|
|
|
|
|
## 80/20 codes
|
|
|
### 80/20 codes
|
|
|
|
|
|
Quote from the [book of ODHSI](https://ohdsi.github.io/TheBookOfOhdsi/ExtractTransformLoad.html#step-2-create-the-code-mappings):
|
|
|
|
... | ... | @@ -25,11 +25,13 @@ GROUP BY PROCEDURE_SOURCE_CONCEPT_ID |
|
|
|
|
|
We have 6.993 distinct CCAM codes. **207 CCAM codes** represent 80% of codes used and 504 codes represent 90% codes used in our hospital. So we started by mapping the first 207 CCAM codes.
|
|
|
|
|
|
## Translation of labels
|
|
|
### Translation of labels
|
|
|
As suggested by the book of ODHSI we used Google Translate to translate French labels to English.
|
|
|
|
|
|
## tools
|
|
|
### Tools
|
|
|
We used **Usagi** as the mapping tool to find corresponding standard concepts to our local ones. After downloading the latest version of the terminologies (v5) on the [Athena webiste](https://athena.ohdsi.org/search-terms/start) and indexing them with Usagi, we started the manual mapping process. The "Filter by domain" button was clicked to filter standards concepts that belong to this domain.
|
|
|
|
|
|
![usagi_mapping](./images/usagi_laryngo.png)
|
|
|
|
|
|
We found it useful to navigate in the SNOMED terminology by accessing it online on the [UMLS website](https://www.nlm.nih.gov/research/umls/index.html).
|
|
|
|