|
|
|
# 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 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.
|
|
|
|
|
|
|
|
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 |
|
|
|
|
| ------ | ------ | ------ |
|
|
|
|
| | fhir_omop_id | This id is generated for each entry manually. |
|
|
|
|
| | type | "MEDICATION" |
|
|
|
|
| id | logical_id | |
|
|
|
|
| identifier.value | identifier | |
|
|
|
|
| | omop_id | This id is generated for each entry manually. |
|
|
|
|
| code.coding.code | omop_table | ATC-Code <br> WHERE system: "http://fhir.de/CodeSystem/dimdi/atc" |
|
|
|
|
|
|
|
|
## Example
|
|
|
|
|
|
|
|
### Input Medication Resource
|
|
|
|
|
|
|
|
```json
|
|
|
|
{
|
|
|
|
"id":"id-d10af0f92b077d2d",
|
|
|
|
"code":{
|
|
|
|
"coding":[
|
|
|
|
{
|
|
|
|
"code":"J02AC04",
|
|
|
|
"system":"http://fhir.de/CodeSystem/dimdi/atc",
|
|
|
|
"version":"ATC/DDD Version 2020"
|
|
|
|
}
|
|
|
|
]
|
|
|
|
},
|
|
|
|
"meta":{
|
|
|
|
"source":"#p21"
|
|
|
|
},
|
|
|
|
"status":"active",
|
|
|
|
"identifier":[
|
|
|
|
{
|
|
|
|
"value":"id-d10af0f92b077d2d",
|
|
|
|
"system":"https://miracum.org/fhir/NamingSystem/identifier/P21SurrogateMedicationId"
|
|
|
|
}
|
|
|
|
],
|
|
|
|
"ingredient":[
|
|
|
|
{
|
|
|
|
"itemCodeableConcept":{
|
|
|
|
"coding":[
|
|
|
|
{
|
|
|
|
"code":"J02AC04",
|
|
|
|
"system":"http://fhir.de/CodeSystem/dimdi/atc"
|
|
|
|
},
|
|
|
|
{
|
|
|
|
"code":"6TK1G07BHZ",
|
|
|
|
"system":"http://fdasis.nlm.nih.gov"
|
|
|
|
},
|
|
|
|
{
|
|
|
|
"code":"29576",
|
|
|
|
"system":"http://fhir.de/CodeSystem/ask"
|
|
|
|
},
|
|
|
|
{
|
|
|
|
"code":"171228-49-2",
|
|
|
|
"system":"urn:oid:2.16.840.1.113883.6.61"
|
|
|
|
}
|
|
|
|
]
|
|
|
|
}
|
|
|
|
}
|
|
|
|
],
|
|
|
|
"resourceType":"Medication"
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
### Output OMOP table
|
|
|
|
+ fhir_id_to_omop_id_map
|
|
|
|
|
|
|
|
|fhir_omop_id|type|logical_id|identifier|omop_id|omop_table|
|
|
|
|
|:----:|:----:|:----:|:----:|:----:|:----:|
|
|
|
|
|1|MEDICATION|id-d10af0f92b077d2d|id-d10af0f92b077d2d|1|J02AC04| |
|
|
\ No newline at end of file |
