Skip to content

Changes

Page history
Update Medication Mapping authored by Henke, Elisa's avatar Henke, Elisa
Show whitespace changes
Inline Side-by-side
Medication-Mapping.md
View page @ 9c954453
......@@ -3,9 +3,9 @@
The content of medication resources is not directly used to fill an already existing table in OMOP. The reason for this is that the DRUG_STRENGTH table is already filled with the vocabulary for medications.
However, the MedicationMapper is used to obtain information about the ATC coding of an administered medication. Therefore a new table in the "cds_etl_helper" schema called "FHIR_ID_TO_OMOP_ID_MAP" is created. This table contains the mapping between the identifier and logical_id of a medication resource and the coding of the medication.
However, the MedicationMapper is used to obtain information about the ATC coding of an administered medication. Therefore a new table in the "cds_etl_helper" schema called "FHIR_ID_TO_OMOP_ID_MAP" is created. This table contains the mapping between the `identifier` and `logical_id` of a medication resource and the coding of the medication.
When processing MedicationAdministration resources, the table "FHIR_ID_TO_OMOP_ID_MAP" is used. Each MedicationAdministration resource contains a reference to a medication resource. This reference (the identifer and/or logical_id of the medication resource) can be used to search for the corresponding ATC coding in the table.
When processing MedicationAdministration resources, the table "FHIR_ID_TO_OMOP_ID_MAP" is used. Each MedicationAdministration resource contains a reference to a medication resource. This reference (the `identifer` and/or `logical_id` of the medication resource) can be used to search for the corresponding ATC coding in the table.
## Medication to FHIR_ID_TO_OMOP_ID_MAP
| Source | Target | Comments |
......