... | @@ -73,7 +73,9 @@ Next the job checks if the read resource (e.g. Condition) already exists in OMOP |
... | @@ -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 |
|
|
| 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 |
|
|
| 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 |
|
|
|
|
|
|

|
|

|
|
|
|
|
... | | ... | |