Skip to content

Changes

Page history
Update Condition Mapping authored by Henke, Elisa's avatar Henke, Elisa
Show whitespace changes
Inline Side-by-side
Condition-Mapping.md
View page @ f885c544
......@@ -6,85 +6,90 @@
:information_source: This mapper will check the right domain for the SNOMED code and then mapps it to the right table in OMOP CDM.
## Condition to CONDITION_OCCURRENCE
| Source | Target | Comments |
| :---------------- | :---------------------- | :------------------------------------------------- |
| | condition_occurrence_id |This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | person_id | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | condition_concept_id | SNOMED concept associated with the ICD code from condition_source_value without special characters |
| recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | condition_start_date <br> condition_start_datetime | |
| onsetPeriod.end | condition_end_date <br> condition_end_datetime | |
| | condition_type_concept_id| See post processing for diagnosis rank. |
|code.coding.extension|condition_status_concept_id | See mapping in source_to_concept_map. |
| | :x: stop_reason | |
| | :x: provider_id | |
| encounter.reference or <br> encounter.identifier.value | visit_occurrence_id | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| |visit_detail_id| See post processing for visit_detail_id |
| code.coding.code | condition_source_value | ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| | condition_source_concept_id | ICD-code from condition_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = condition_source_value |
|code.coding.extension|condition_status_source_value| |
| FHIR | FHIR - required | OMOP | OMOP - required | Comments |
| :------: | :------: | :------: |:------: |:------: |
| | | condition_occurrence_id | :heavy_check_mark:| This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | | person_id | :heavy_check_mark: | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | | condition_concept_id | :heavy_check_mark: | SNOMED concept associated with the ICD code from condition_source_value without special characters |
| recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | | condition_start_date | :heavy_check_mark: | |
| recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | | condition_start_datetime | | |
| onsetPeriod.end | | condition_end_date | | |
| onsetPeriod.end | | condition_end_datetime | | |
| | | condition_type_concept_id| :heavy_check_mark: | See post processing for diagnosis rank. |
|code.coding.extension| | condition_status_concept_id | | See mapping in source_to_concept_map. |
| | | :x: stop_reason | | |
| | | :x: provider_id | | |
| encounter.reference or <br> encounter.identifier.value | | visit_occurrence_id | | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | |visit_detail_id| | See post processing for visit_detail_id |
| code.coding.code | | condition_source_value | | ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| | | condition_source_concept_id | | ICD-code from condition_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = condition_source_value |
|code.coding.extension| |condition_status_source_value| | |
## Condition to MEASUREMENT
| Source | Target | Comments |
| :--------------- | :-------------------- | :---------------------------------------- |
| | measurement_id |This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | person_id | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| |measurement_concept_id| SNOMED concept associated with the ICD code from measurement_source_value without special characters |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value |measurement_date <br> measurement_datetime||
| | :x: measurement_time | |
| |measurement_type_concept_id| See post processing for diagnosis rank. |
| | :x: operator_concept_id | |
| | :x: value_as_number | |
| | :x: value_as_concept_id | |
| | :x: unit_concept_id | |
| | :x: range_low | |
| | :x: range_high | |
| encounter.reference or <br> encounter.identifier.value | visit_occurrence_id | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| |visit_detail_id| See post processing for visit_detail_id |
| code.coding.code |measurement_source_value| ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| |measurement_source_concept_id| ICD-code from measurement_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = measurement_source_value |
| | :x: unit_source_value | |
| | :x: value_source_value | |
| FHIR | FHIR - required | OMOP | OMOP - required | Comments |
| :------: | :------: |:------: |:------: |:------: |
| | | measurement_id | :heavy_check_mark: | This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | | person_id | :heavy_check_mark: | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | |measurement_concept_id| :heavy_check_mark: | SNOMED concept associated with the ICD code from measurement_source_value without special characters |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | |measurement_date |:heavy_check_mark:| |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | |measurement_datetime|| |
| | | :x: measurement_time | | |
| | |measurement_type_concept_id| :heavy_check_mark: | See post processing for diagnosis rank. |
| | | :x: operator_concept_id | | |
| | | :x: value_as_number | | |
| | | :x: value_as_concept_id | | |
| | | :x: unit_concept_id | | |
| | | :x: range_low | | |
| | | :x: range_high | | |
| encounter.reference or <br> encounter.identifier.value | | visit_occurrence_id | | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | |visit_detail_id| | See post processing for visit_detail_id |
| code.coding.code | |measurement_source_value || ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| | |measurement_source_concept_id| | ICD-code from measurement_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = measurement_source_value |
| | | :x: unit_source_value | | |
| | | :x: value_source_value | | |
## Condition to PROCEDURE_OCCURRENCE
| Source | Target | Comments |
| :--------------- | :-------------------- | :---------------------------------------- |
| | procedure_occurrence_id|This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | person_id | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| |procedure_concept_id| SNOMED concept associated with the ICD code from procedure_source_value without special characters |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value |procedure_date <br> procedure_datetime| |
| |procedure_type_concept_id| See post processing for diagnosis rank. |
| | :x: modifier_concept_id | |
| | :x: quantity | |
| | :x: provider_id | |
| encounter.reference or <br> encounter.identifier.value | visit_occurrence_id | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| |visit_detail_id| See post processing for visit_detail_id |
| code.coding.code |procedure_source_value| ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| |procedure_source_concept_id| ICD-code from procedure_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = procedure_source_value |
| | :x: modifier_source_value | |
| FHIR |FHIR - required | OMOP | OMOP - required | Comments |
|:------: |:------: |:------: |:------: |:------: |
| | | procedure_occurrence_id| :heavy_check_mark: |This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | | person_id | :heavy_check_mark: | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | |procedure_concept_id| :heavy_check_mark: | SNOMED concept associated with the ICD code from procedure_source_value without special characters |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | |procedure_date| :heavy_check_mark: | |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | |procedure_datetime| | |
| | |procedure_type_concept_id| :heavy_check_mark: |See post processing for diagnosis rank. |
| | | :x: modifier_concept_id | | |
| | | :x: quantity | | |
| | | :x: provider_id | | |
| encounter.reference or <br> encounter.identifier.value | | visit_occurrence_id | | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | |visit_detail_id| |See post processing for visit_detail_id |
| code.coding.code | |procedure_source_value| | ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| | |procedure_source_concept_id| | ICD-code from procedure_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = procedure_source_value |
| | | :x: modifier_source_value | | |
## Condition to OBSERVATION
| Source | Target | Comments |
| :--------------- | :-------------------- | :---------------------------------------- |
| | observation_id |This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | person_id | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| |observation_concept_id| SNOMED concept associated with the ICD code from observation_source_value without special characters |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value |observation_date <br> observation_datetime| |
| |observation_type_concept_id| See post processing for diagnosis rank. |
| | :x: value_as_number | |
| | :x: value_as_string | |
| | :x: value_as_concept_id | |
| | :x: qualifier_concept_id | |
| | :x: unit_concept_id | |
| | :x: provider_id | |
| encounter.reference or <br> encounter.identifier.value | visit_occurrence_id | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| |visit_detail_id| See post processing for visit_detail_id |
| code.coding.code |observation_source_value| ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| |observation_source_concept_id| ICD-code from observation_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = observation_source_value |
| | :x: unit_source_value | |
| | :x: qualifier_source_value | |
| FHIR | FHIR - required | OMOP | OMOP - required | Comments |
|:------: |:------: |:------: |:------: |:------: |
| | | observation_id | :heavy_check_mark: |This id is generated for each condition resource automatically. |
| subject.reference or <br> subject.identifier.value | | person_id | :heavy_check_mark: | The patient reference is used to search for the person_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | |observation_concept_id| :heavy_check_mark: | SNOMED concept associated with the ICD code from observation_source_value without special characters |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | |observation_date|:heavy_check_mark: | |
|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | |observation_datetime| | |
| | |observation_type_concept_id| :heavy_check_mark: |See post processing for diagnosis rank. |
| | | :x: value_as_number | | |
| | | :x: value_as_string | | |
| | | :x: value_as_concept_id | | |
| | | :x: qualifier_concept_id | | |
| | | :x: unit_concept_id | | |
| | | :x: provider_id | | |
| encounter.reference or <br> encounter.identifier.value | | visit_occurrence_id | | The encounter reference is used to search for the visit_occurrence_id in FHIR_ID_TO_OMOP_ID_MAP. |
| | |visit_detail_id| | See post processing for visit_detail_id |
| code.coding.code | |observation_source_value| | ICD-code WHERE system = "http://fhir.de/CodeSystem/dimdi/icd-10-gm" |
| | |observation_source_concept_id| | ICD-code from observation_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = observation_source_value |
| | | :x: unit_source_value | | |
| | | :x: qualifier_source_value | | |
## Condition to POST_PROCESS_MAP
| Source| Target | Comments |
| FHIR | OMOP | Comments |
| ------ | ------ | ------ |
| | data_id | This id is generated for each condition resource automatically. |
| | type | default value: "CONDITION" |
......