Changes

Page history
fix: added mapping of qualifier_concept_id for stage and severity authored by Henke's avatar Henke
Show whitespace changes
Inline Side-by-side
Condition-Mapping.md
View page @ b1a8eb7d
...@@ -134,7 +134,7 @@ ...@@ -134,7 +134,7 @@
| | | :x: value_as_number | | | | | | :x: value_as_number | | |
| severity.coding.code | | value_as_string | | | | severity.coding.code | | value_as_string | | |
| | | :x: value_as_concept_id | | | | | | :x: value_as_concept_id | | |
| | | :x: qualifier_concept_id | | | | | | qualifier_concept_id | | default value: 4077563 (Severity (attribute)) |
| | | :x: unit_concept_id | | | | | | :x: unit_concept_id | | |
| | | :x: provider_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. | | 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. |
...@@ -158,7 +158,7 @@ ...@@ -158,7 +158,7 @@
| | | :x: value_as_number | | | | | | :x: value_as_number | | |
| stage.summary.coding.code | | value_as_string | | | | stage.summary.coding.code | | value_as_string | | |
| | | :x: value_as_concept_id | | | | | | :x: value_as_concept_id | | |
| | | :x: qualifier_concept_id | | | | | | qualifier_concept_id | | default value: 4106767 (Stage (attribute)) |
| | | :x: unit_concept_id | | | | | | :x: unit_concept_id | | |
| | | :x: provider_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. | | 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. |
...@@ -332,14 +332,14 @@ Information for ICD site localization ...@@ -332,14 +332,14 @@ Information for ICD site localization
|1|1|4197258|2018-02-15|2018-02-15 17:25:00|32817|B|1|B|4197258|con-id-1|con-id-1| |1|1|4197258|2018-02-15|2018-02-15 17:25:00|32817|B|1|B|4197258|con-id-1|con-id-1|
Information for severity 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| |observation_id|person_id|observation_concept_id|observation_date|observation_datetime|observation_type_concept_id|value_as_string|qualifier_concept_id|visit_occurrence_id|observation_source_value|observation_source_concept_id|fhir_logical_id|fhir_identifier|
|----|----|----|----|----|----|----|----|----|----|----| |----|----|----|----|----|----|----|----|----|----|----|
|2|1|4087703|2018-02-15|2018-02-15 17:25:00|32817|24484000|1|24484000|4197258|con-id-1|con-id-1| |2|1|4087703|2018-02-15|2018-02-15 17:25:00|32817|24484000|4077563|1|24484000|4197258|con-id-1|con-id-1|
Information for severity Information for stage
|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| |observation_id|person_id|observation_concept_id|observation_date|observation_datetime|observation_type_concept_id|value_as_string|qualifier_concept_id|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| |3|1|4087703|2018-02-15|2018-02-15 17:25:00|32817|24484000|4106767|1|24484000|4197258|con-id-1|con-id-1|
+ POST_PROCESS_MAP + POST_PROCESS_MAP
...@@ -360,7 +360,7 @@ Information for severity ...@@ -360,7 +360,7 @@ Information for severity
| 4 | CONDITION | 24484000:Observation | Z71:Condition | 1 | severity |con-id-1|con-id-1| | 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| | 5 | CONDITION | 24484000:Observation | Z50.1:Condition | 1 | severity |con-id-1|con-id-1|
Information for severity Information for stage
|data_id|type|data_one|data_two|omop_id|omop_table|fhir_logical_id|fhir_identifier| |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| | 6 | CONDITION | 24484000:Observation | Z71:Condition | 1 | stage |con-id-1|con-id-1|
... ...
......