|
|
|
# Medication Mapping
|
|
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
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 Medication Mapper 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
|
|
|
|
## Medication to FHIR_ID_TO_OMOP_ID_MAP
|
|
|
|
| Source | Target | Comments |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| | fhir_omop_id | This id is generated for each entry manually. |
|
|
|
|
| | fhir_omop_id | This id is generated for each medication resource automatically. |
|
|
|
|
| | type | "MEDICATION" |
|
|
|
|
| id | logical_id | |
|
|
|
|
| identifier.value | identifier | |
|
|
|
|
| | omop_id | This id is generated for each entry manually. |
|
|
|
|
| | omop_id | This id is generated for each medication resource manually. |
|
|
|
|
| code.coding.code | omop_table | ATC-Code <br> WHERE system: "http://fhir.de/CodeSystem/dimdi/atc" |
|
|
|
|
|
|
|
|
## Example
|
| ... | ... | @@ -72,7 +72,7 @@ When processing MedicationAdministration resources, the table "fhir_id_to_omop_i |
|
|
|
```
|
|
|
|
|
|
|
|
### Output OMOP table
|
|
|
|
+ fhir_id_to_omop_id_map
|
|
|
|
+ FHIR_ID_TO_OMOP_ID_MAP
|
|
|
|
|
|
|
|
|fhir_omop_id|type|logical_id|identifier|omop_id|omop_table|
|
|
|
|
|:----:|:----:|:----:|:----:|:----:|:----:|
|
| ... | ... | |
