Condition-Mapping.md

@@ -146,6 +146,30 @@
 | id | | fhir_logical_id | | prefix "con-"|
 | identifier.value| | fhir_identifier | | prefix "con-"|
 
+### Information for stage
+| 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 PERSON. |
+| | |observation_concept_id| :heavy_check_mark: | SNOMED-code from observation_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = observation_source_value AND CONCEPT.vocabulary_id = 'SNOMED' |
+|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | :heavy_check_mark: <br>  <br> |observation_date|:heavy_check_mark: | |
+|recordedDate or <br> onsetPeriod.start or <br> onsetDateTime.value | :heavy_check_mark: <br>  <br> |observation_datetime| | |
+| | |observation_type_concept_id| :heavy_check_mark: |default value: 32817 (EHR) |
+| | | :x: value_as_number | | |
+| stage.summary.coding.code | | 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 VISIT_OCCURRENCE. |
+| | | :x: visit_detail_id| | |
+| stage.summary.coding.code | |observation_source_value| | |
+| | | observation_source_concept_id| | SNOMED-code from observation_source_value <br> CONCEPT.concept_id WHERE CONCEPT.concept_code = observation_source_value AND CONCEPT.vocabulary_id = 'SNOMED'|
+| | | :x: unit_source_value | | |
+| | | :x: qualifier_source_value | | |
+| id | | fhir_logical_id | | prefix "con-"|
+| identifier.value| | fhir_identifier | | prefix "con-"|
+
 ## Condition to POST_PROCESS_MAP
 
 ### Information for primary and secondary ICD
@@ -184,6 +208,18 @@
 | id | | fhir_logical_id | | prefix "con-"|
 | identifier.value| | fhir_identifier | | prefix "con-"|
 
+### Information for stage
+| FHIR | FHIR - required | OMOP | OMOP - required | Comments |
+| ------ | ------ | ------ | ------ | ------ |
+| | | data_id | | This id is generated for each condition resource automatically. |
+| | | type | | default value: "CONDITION" |
+| stage.summary.coding.code | | data_one | | stage + ":Observation" |
+| code.coding.code | :heavy_check_mark: | data_two | | It represents the linkage between the diagnosis code and its respective domain. |
+| | | omop_id | | This id represents the person_id of the PERSON table. |
+| | | omop_table | | default value: "stage" |
+| id | | fhir_logical_id | | prefix "con-"|
+| identifier.value| | fhir_identifier | | prefix "con-"|
+
 ## Example
 
 ### Input Condition Resource
@@ -237,6 +273,29 @@
          ]
       }
    ],
+   "stage":  [
+        {
+            "summary": {
+                "coding":  [
+                    {
+                        "system": "http://snomed.info/sct",
+                        "code": "24484000",
+                        "display": "Severe (severity modifier) (qualifier value)"
+                    }
+                ],
+                "text": "Critical phase"
+            },
+            "type": {
+                "coding":  [
+                    {
+                        "system": "http://loinc.org",
+                        "code": "88859-4",
+                        "display": "Disease stage score for risk calculation"
+                    }
+                ]
+            }
+        }
+    ],
    "meta":{
       "source":"#p21"
    },
@@ -277,6 +336,11 @@ Information for severity
 |----|----|----|----|----|----|----|----|----|----|----|
 |2|1|4087703|2018-02-15|2018-02-15 17:25:00|32817|24484000|1|24484000|4197258|con-id-1|con-id-1|
 
+Information for severity
+|observation_id|person_id|observation_concept_id|observation_date|observation_datetime|observation_type_concept_id|value_as_string|visit_occurrence_id|observation_source_value|observation_source_concept_id|fhir_logical_id|fhir_identifier|  
+|----|----|----|----|----|----|----|----|----|----|----|
+|3|1|4087703|2018-02-15|2018-02-15 17:25:00|32817|24484000|1|24484000|4197258|con-id-1|con-id-1|
+
 + POST_PROCESS_MAP
 
 Information for primary and secondary ICD
@@ -295,3 +359,9 @@ Information for severity
 |:----:|:----:|:----:|:----:|:----:|:----:|:----:|:----:|
 | 4 | CONDITION | 24484000:Observation | Z71:Condition | 1 | severity |con-id-1|con-id-1|
 | 5 | CONDITION | 24484000:Observation | Z50.1:Condition | 1 | severity |con-id-1|con-id-1|
+
+Information for severity
+|data_id|type|data_one|data_two|omop_id|omop_table|fhir_logical_id|fhir_identifier|
+|:----:|:----:|:----:|:----:|:----:|:----:|:----:|:----:|
+| 6 | CONDITION | 24484000:Observation | Z71:Condition | 1 | stage |con-id-1|con-id-1|
+| 7 | CONDITION | 24484000:Observation | Z50.1:Condition | 1 | stage |con-id-1|con-id-1|