Skip to content

Changes

Page history
Update Incremental Load authored by Henke, Elisa's avatar Henke, Elisa
Hide whitespace changes
Inline Side-by-side
Incremental-Load.md
View page @ 9d61b628
...@@ -52,7 +52,7 @@ When a MedicationAdministration/MedicationStatement resource is read in, the job ...@@ -52,7 +52,7 @@ When a MedicationAdministration/MedicationStatement resource is read in, the job
Due to the fact that the resource types are read in random order, it may happen that the referenced Medication resource is not yet available in OMOP CDM. In this case, the Medication reference of the MedicationAdministration/MedicationStatement resource is set as `drug_source_value` in DRUG_EXPOSURE. After all resources have been processed, post-processing takes place. During post processing, the referenced Medication resource is searched in the FHIR_ID_TO_OMOP_ID_MAP table using the Medication reference in `drug_source_value`. If this Medication resource exists in OMOP CDM, an update in DRUG_EXPOSURE takes place. Due to the fact that the resource types are read in random order, it may happen that the referenced Medication resource is not yet available in OMOP CDM. In this case, the Medication reference of the MedicationAdministration/MedicationStatement resource is set as `drug_source_value` in DRUG_EXPOSURE. After all resources have been processed, post-processing takes place. During post processing, the referenced Medication resource is searched in the FHIR_ID_TO_OMOP_ID_MAP table using the Medication reference in `drug_source_value`. If this Medication resource exists in OMOP CDM, an update in DRUG_EXPOSURE takes place.
![inkrementellesLaden-Medication](uploads/c69677038125a4b6afed204e4e49cddc/inkrementellesLaden-Medication.png) ![inkrementellesLaden-Medication.drawio](uploads/9275198dc30a46dfdd46bf2da0678aac/inkrementellesLaden-Medication.drawio.png)
</details> </details>
</p> </p>
...@@ -79,7 +79,7 @@ Next the job checks if the read resource (e.g. Condition) already exists in OMOP ...@@ -79,7 +79,7 @@ Next the job checks if the read resource (e.g. Condition) already exists in OMOP
If the read resource does not yet exist in OMOP CDM, it will be written to OMOP CDM as a new resource. If the read resource already exists in OMOP CDM, an update will take place in OMOP CDM based on the corresponding `visit_detail_id`/`procedure_occurrence_id`/`observation_id`/`measurement_id`/`drug_exposure_id`/`condition_occurrence_id`. If the read resource does not yet exist in OMOP CDM, it will be written to OMOP CDM as a new resource. If the read resource already exists in OMOP CDM, an update will take place in OMOP CDM based on the corresponding `visit_detail_id`/`procedure_occurrence_id`/`observation_id`/`measurement_id`/`drug_exposure_id`/`condition_occurrence_id`.
![inkrementellesLaden-Others](uploads/9c72e7aa867269a57cce9e9bc74495de/inkrementellesLaden-Others.png) ![inkrementellesLaden-Others.drawio](uploads/694ac2de6a6dbc74aea18aea7d8a2009/inkrementellesLaden-Others.drawio.png)
</details> </details>
</p> </p>
\ No newline at end of file