Changes
Page history
Update Incremental Load
authored
May 14, 2021
by
Henke, Elisa
Show whitespace changes
Inline
Side-by-side
Incremental-Load.md
View page @
96906b2a
...
...
@@ -73,7 +73,9 @@ Next the job checks if the read resource (e.g. Condition) already exists in OMOP
| :------: | :------: | :------ |
| Encounter | VISIT_DETAIL | person_id
<br>
visit_detail_start_datetime
<br>
visit_occurrence_id |
| Procedure | PROCEDURE_OCCURRENCE | person_id
<br>
procedure_concept_id
<br>
procedure_datetime
<br>
procedure_source_concept_id |
| Observation | OBSERVATION
<br>
MEASUREMENT | person_id
<br>
observation_concept_id/measurement_concept_id
<br>
observation_datetime/measurement_datetime
<br>
observation_source_concept_id/measurement_source_concept_id |
| Observation | OBSERVATION
<br>
MEASUREMENT | person_id
<br>
observation/measurement_concept_id
<br>
observation/measurement_datetime
<br>
observation/measurement_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 |
...
...
...
...
