Condition-Mapping.md

@@ -43,6 +43,23 @@
 | | :x: unit_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
 | Source | Target | Comments |
 | :--------------- | :-------------------- | :---------------------------------------- |
@@ -63,23 +80,15 @@
 | | :x: unit_source_value | |
 | | :x: qualifier_source_value | |
 
-## Condition to PROCEDURE_OCCURRENCE
+## Condition to DATA_PERSISTANT_MAP
 | 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 | |
-
+| ------ | ------ | ------ |
+|  | data_id | This id is generated for each encounter resource automatically. |
+|  | type | default value: "ENCOUNTER" |
+|  | data_one | It represents the visit_start_date of the visit_occurrence. |
+|  | data_two | It represents the visit_end_date of the visit_occurrence. |
+|  | omop_id | This id represents the person_id of the person table. |
+|  | omop_table | default value: "observation_period" |
 
 ## Example
 
@@ -132,9 +141,8 @@
 |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|
 
-+ FACT_RELATIONSHIP
++ DATA_PERSISTANT_MAP
 
-|domain_concept_id_1|fact_id_1|domain_concept_id_2|fact_id_2|relationship_concept_id|
-|:----:|:----:|:----:|:----:|:----:|
-|10|1|27|2|44818770|
-|27|2|10|1|44818868|
\ No newline at end of file
+|data_id|type|data_one|data_two|omop_id|omop_table|
+|:----:|:----:|:----:|:----:|:----:|:----:|
+| 1 | ENCOUNTER | 2018-02-13 | 2018-02-23 | 1 | observation_period |
\ No newline at end of file