Changes

Page history
Update Condition Mapping authored by Henke, Elisa's avatar Henke, Elisa
Hide whitespace changes
Inline Side-by-side
Condition-Mapping.md
View page @ 3ee57b17
...@@ -43,6 +43,23 @@ ...@@ -43,6 +43,23 @@
| | :x: unit_source_value | | | | :x: unit_source_value | |
| | :x: value_source_value | | | | :x: value_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| _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 | |
## Condition to OBSERVATION ## Condition to OBSERVATION
| Source | Target | Comments | | Source | Target | Comments |
| :--------------- | :-------------------- | :---------------------------------------- | | :--------------- | :-------------------- | :---------------------------------------- |
...@@ -63,23 +80,15 @@ ...@@ -63,23 +80,15 @@
| | :x: unit_source_value | | | | :x: unit_source_value | |
| | :x: qualifier_source_value | | | | :x: qualifier_source_value | |
## Condition to PROCEDURE_OCCURRENCE ## Condition to DATA_PERSISTANT_MAP
| Source | Target | Comments | | Source| Target | Comments |
| :--------------- | :-------------------- | :---------------------------------------- | | ------ | ------ | ------ |
| | procedure_occurrence_id|this id is automatic generated in database | | | data_id | This id is generated for each encounter resource automatically. |
|subject.reference | person_id | the `person_id` from PERSON | | | type | default value: "ENCOUNTER" |
| code.coding.code |procedure_concept_id| _Analogous to CONDITION_OCCURRENCE_ | | | data_one | It represents the visit_start_date of the visit_occurrence. |
|recordedDate <br> onsetPeriod.start <br> onsetDateTimeType |procedure_date <br> procedure_datetime|_Analogous to CONDITION_OCCURRENCE_| | | data_two | It represents the visit_end_date of the visit_occurrence. |
| |procedure_type_concept_id|_Analogous to CONDITION_OCCURRENCE_| | | omop_id | This id represents the person_id of the person table. |
| | :x: modifier_concept_id | | | | omop_table | default value: "observation_period" |
| | :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 ## Example
...@@ -132,9 +141,8 @@ ...@@ -132,9 +141,8 @@
|1|1|2000001173|2018-02-15|2018-02-15 17:25:00|44786627|1|Z71|4254477| |1|1|2000001173|2018-02-15|2018-02-15 17:25:00|44786627|1|Z71|4254477|
|2|1|2000001425|2018-02-15|2018-02-15 17:25:00|44786627|1|Z50.1|4238738| |2|1|2000001425|2018-02-15|2018-02-15 17:25:00|44786627|1|Z50.1|4238738|
+ FACT_RELATIONSHIP + DATA_PERSISTANT_MAP
|domain_concept_id_1|fact_id_1|domain_concept_id_2|fact_id_2|relationship_concept_id| |data_id|type|data_one|data_two|omop_id|omop_table|
|:----:|:----:|:----:|:----:|:----:| |:----:|:----:|:----:|:----:|:----:|:----:|
|10|1|27|2|44818770| | 1 | ENCOUNTER | 2018-02-13 | 2018-02-23 | 1 | observation_period |
|27|2|10|1|44818868| \ No newline at end of file
\ No newline at end of file