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 @ e418148c
...@@ -77,6 +77,8 @@ Next the job checks if the read resource (e.g. Condition) already exists in OMOP ...@@ -77,6 +77,8 @@ Next the job checks if the read resource (e.g. Condition) already exists in OMOP
| MedicationAdministration | DRUG_EXPOSURE | person_id <br> drug_concept_id <br> drug_exposure_start_datetime <br> drug_source_concept_id | | MedicationAdministration | DRUG_EXPOSURE | person_id <br> drug_concept_id <br> drug_exposure_start_datetime <br> drug_source_concept_id |
| Condition | CONDITION_OCCURRENCE <br> OBSERVATION <br> PROCEDURE_OCCURRENCE <br> MEASUREMENT | person_id <br> condition/observation/procedure/measurement_concept_id <br> condition_start_datetime / observation/procedure/measurement_datetime <br> condition/observation/procedure/measurement_source_concept_id | | Condition | CONDITION_OCCURRENCE <br> OBSERVATION <br> PROCEDURE_OCCURRENCE <br> MEASUREMENT | person_id <br> condition/observation/procedure/measurement_concept_id <br> condition_start_datetime / observation/procedure/measurement_datetime <br> condition/observation/procedure/measurement_source_concept_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](uploads/9c72e7aa867269a57cce9e9bc74495de/inkrementellesLaden-Others.png)
</details> </details>
......