... | ... | @@ -8,4 +8,15 @@ This article is interesting for coding anesthetists activities (French only): ht |
|
|
|
|
|
# Mapping process
|
|
|
|
|
|
## 80/20 codes
|
|
|
|
|
|
Quote from the [book of ODHSI](https://ohdsi.github.io/TheBookOfOhdsi/ExtractTransformLoad.html#step-2-create-the-code-mappings):
|
|
|
|
|
|
> The 80/20 rule. If you can avoid it do not spend too much time manually mapping source codes to concepts sets. Ideally, map the source codes that cover the majority of your data. This should be enough to get you started and you can address any remaining codes in the future based on use cases
|
|
|
|
|
|
We counted the number of procedures in the procedure_occurence table:
|
|
|
```sql
|
|
|
SELECT PROCEDURE_SOURCE_CONCEPT_ID, COUNT(*) AS FREQUENCY
|
|
|
FROM OMOP.PROCEDURE_OCCURRENCE
|
|
|
GROUP BY PROCEDURE_SOURCE_CONCEPT_ID
|
|
|
``` |