|
|
|
# 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.
|
|
|
|
|
|
|
|
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 code of an administered medication. Therefore a new table in the "cds_etl_helper" schema called "MEDICATION_ID_MAP" is created. This table contains the mapping between the `fhir_logical_id` and `fhir_identifier` of a medication resource and the ATC code 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/MedicationStatement resources, the table "MEDICATION_ID_MAP" is used. Each MedicationAdministration/MedicationStatement resource contains a reference to a medication resource. This reference (`fhir_logical_id` or `fhir_identifier` of the medication resource) can be used to search for the corresponding ATC code in the table.
|
|
|
|
|
|
|
|
## Medication to FHIR_ID_TO_OMOP_ID_MAP
|
|
|
|
## Medication to MEDICATION_ID_MAP
|
|
|
|
| FHIR | FHIR - required | OMOP | OMOP - required | Comments |
|
|
|
|
| ------ | ------ | ------ | ------ | ------ |
|
|
|
|
| | | fhir_omop_id | | This id is generated for each medication resource automatically. |
|
| ... | ... | @@ -15,7 +15,7 @@ When processing MedicationAdministration resources, the table "FHIR_ID_TO_OMOP_I |
|
|
|
| id | | logical_id | | |
|
|
|
|
| identifier.value | | identifier | | |
|
|
|
|
| | | 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" |
|
|
|
|
| code.coding.code | | atc | | ATC-Code <br> WHERE system = "http://fhir.de/CodeSystem/dimdi/atc" |
|
|
|
|
|
|
|
|
## Example
|
|
|
|
|
| ... | ... | @@ -72,8 +72,8 @@ When processing MedicationAdministration resources, the table "FHIR_ID_TO_OMOP_I |
|
|
|
```
|
|
|
|
|
|
|
|
### Output OMOP table
|
|
|
|
+ FHIR_ID_TO_OMOP_ID_MAP
|
|
|
|
+ MEDICATION_ID_MAP
|
|
|
|
|
|
|
|
|fhir_omop_id|type|logical_id|identifier|omop_id|omop_table|
|
|
|
|
|fhir_omop_id|type|logical_id|identifier|omop_id|atc|
|
|
|
|
|:----:|:----:|:----:|:----:|:----:|:----:|
|
|
|
|
|1|MEDICATION|id-d10af0f92b077d2d|id-d10af0f92b077d2d|1|J02AC04| |
|
|
\ No newline at end of file |
