Condition-Mapping.md

 # Condition Mapping
 ![fhir-to-omop_Condition](uploads/3ef0cdae25e7d56c6d0beeda2a4cd825/fhir-to-omop_Condition.png)
 
-:information_source: All ICD Code will also be mapped to a Snomed Code. The mapping information is available in OMOP in the `public.MATERIALIZED VIEW.icd_snomed_domain_lookup`, which is generated from ICD10GM Vocabulary (CONCEPT) and CONCEPT_RELATIONSHIP tables. 
+:information_source: All ICD codes will also be mapped to a SNOMED Code. The mapping information is available in OMOP in the `cds_etl_helper.MATERIALIZED VIEW.icd_snomed_domain_lookup`, which is generated from ICD10GM vocabulary (CONCEPT) and CONCEPT_RELATIONSHIP tables. 
 
 ## Condition to CONDITION_OCCURRENCE
 | Source | Target | Comments |
 | :---------------- | :---------------------- | :------------------------------------------------- |
 |                   | condition_occurrence_id |this id is automatic generated in database          |
 | subject.reference | person_id               | the `person_id` from PERSON                        |
-| code.coding.code | condition_concept_id <br> condition_source_value <br> condition_source_concept_id | both primary and secondary ICD codes are written here |
+| code.coding.code | condition_concept_id | both primary and secondary ICD codes are written here |
 | recordedDate <br> onsetPeriod.start <br> onsetDateTimeType | condition_start_date <br> condition_start_datetime | one of the resources is used |
+| | condition_end_date <br> condition_end_datetime | |
 |  | condition_type_concept_id| the data _`rank`_ from `Encounter` is used here <br> 1-> HD (44786627) <br> 2-> ND (44786629) |
+|code.coding.extension|condition_status_concept_id |__A__(ausgeschlossene Diagnose) -> __37116688__ <br> __G__(gesicherte Diagnose) -> __4230359__ <br> __V__(Verdachtsdiagnose)-> __4033240__ <br> __Z__(symptomloser Zustand nach der betreffende Diagnose)-> __4284245__|
+| | :x: stop_reason | |
+| | :x: provider_id | |
 | Encounter.reference | visit_occurrence_id | the `visit_occurrence_id` from VISIT_OCCURRENCE |
 | |visit_detail_id| the `visit_detail_id` from VISIT_DETAIL|
-|code.coding.extension|condition_status_concept_id <br> condition_status_resource_value|__A__(ausgeschlossene Diagnose) -> __37116688__ <br> __G__(gesicherte Diagnose) -> __4230359__ <br> __V__(Verdachtsdiagnose)-> __4033240__ <br> __Z__(symptomloser Zustand nach der betreffende Diagnose)-> __4284245__|
+| code.coding.code | condition_source_value <br> condition_source_concept_id |
+| | condition_source_concept_id | |
+|code.coding.extension|condition_status_source_value|__A__(ausgeschlossene Diagnose) -> __37116688__ <br> __G__(gesicherte Diagnose) -> __4230359__ <br> __V__(Verdachtsdiagnose)-> __4033240__ <br> __Z__(symptomloser Zustand nach der betreffende Diagnose)-> __4284245__|
 
 ## Condition to MEASUREMENT
 | Source | Target | Comments |
 | :--------------- | :-------------------- | :---------------------------------------- |
 |                  | measurement_id        |this id is automatic generated in database |
 |subject.reference |  person_id            | the `person_id` from PERSON               |
-| code.coding.code |measurement_concept_id <br> measurement_source_value <br> measurement_source_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
+| code.coding.code |measurement_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
 |recordedDate <br> onsetPeriod.start <br> onsetDateTimeType |measurement_date <br> measurement_datetime|_Analogous to CONDITION_OCCURRENCE_|
+| | :x: measurement_time | |
 | |measurement_type_concept_id|_Analogous to CONDITION_OCCURRENCE_|
+| | :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 |visit_occurrence_id|the `visit_occurrence_id` from VISIT_OCCURRENCE|
 | |visit_detail_id|the `visit_detail_id` from VISIT_DETAIL|
+| code.coding.code |measurement_source_value| _Analogous to CONDITION_OCCURRENCE_           |
+| code.coding.code |measurement_source_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
+| | :x: unit_source_value | |
+| | :x: value_source_value | |
 
 ## Condition to OBSERVATION
 | Source | Target | Comments |
 | :--------------- | :-------------------- | :---------------------------------------- |
 |                  | observation_id        |this id is automatic generated in database |
 |subject.reference |  person_id            | the `person_id` from PERSON               |
-| code.coding.code |observation_concept_id <br> observation_source_value <br> observation_source_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
+| code.coding.code |observation_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
 |recordedDate <br> onsetPeriod.start <br> onsetDateTimeType |observation_date <br> observation_datetime|_Analogous to CONDITION_OCCURRENCE_|
 | |observation_type_concept_id|_Analogous to CONDITION_OCCURRENCE_|
+| | :x: value_as_number | |
+| | :x: value_as_string | |
+| | :x: qualifier_concept_id | |
+| | :x: unit_concept_id | |
+| | :x: provider_id | |
 |Encounter.reference |visit_occurrence_id|the `visit_occurrence_id` from VISIT_OCCURRENCE|
 | |visit_detail_id|the `visit_detail_id` from VISIT_DETAIL|
+| code.coding.code |observation_source_value| _Analogous to CONDITION_OCCURRENCE_           |
+| code.coding.code |observation_source_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
+| | :x: unit_source_value | |
+| | :x: qualifier_source_value | |
 
 ## Condition to PROCEDURE_OCCURRENCE
 | Source | Target | Comments |
 | :--------------- | :-------------------- | :---------------------------------------- |
 |                  | procedure_occurrence_id|this id is automatic generated in database |
 |subject.reference |  person_id            | the `person_id` from PERSON               |
-| code.coding.code |procedure_concept_id <br> procedure_source_value <br> procedure_source_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
+| code.coding.code |procedure_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
 |recordedDate <br> onsetPeriod.start <br> onsetDateTimeType |procedure_date <br> procedure_datetime|_Analogous to CONDITION_OCCURRENCE_|
 | |procedure_type_concept_id|_Analogous to CONDITION_OCCURRENCE_|
+| | :x: modifier_concept_id | |
+| | :x: quantity | |
+| | :x: provider_id | |
 |Encounter.reference |visit_occurrence_id|the `visit_occurrence_id` from VISIT_OCCURRENCE|
 | |visit_detail_id|the `visit_detail_id` from VISIT_DETAIL|
+| code.coding.code |procedure_source_value| _Analogous to CONDITION_OCCURRENCE_           |
+| code.coding.code |procedure_source_concept_id| _Analogous to CONDITION_OCCURRENCE_           |
+| | :x: modifier_source_value | |
 
 
 ## Example