... | @@ -4,18 +4,18 @@ |
... | @@ -4,18 +4,18 @@ |
|
|
|
|
|
## Example: Discharge reason
|
|
## Example: Discharge reason
|
|
### POST_PROCESS_MAP to OBSERVATION
|
|
### POST_PROCESS_MAP to OBSERVATION
|
|
| Source | Target | Comments |
|
|
| OMOP (source) | OMOP (target) | OMOP (target) - required | Comments |
|
|
| :---------------- | :---------------------- | :------------------------------------------------- |
|
|
| :----------------: | :----------------: | :----------------: | :----------------: |
|
|
||observation_id|This id is generated automatically.|
|
|
||observation_id| :heavy_check_mark: | This id is generated automatically.|
|
|
|omop_id|person_id|This id represents the person_id of the person table.|
|
|
|omop_id|person_id| :heavy_check_mark: |This id represents the person_id of the person table.|
|
|
| |observation_concept_id| The observation_source_value is used to search in source_to_concept_map table for the corresponding concept_id.|
|
|
| |observation_concept_id| :heavy_check_mark: | The observation_source_value is used to search in source_to_concept_map table for the corresponding concept_id.|
|
|
| data_one |observation_date| |
|
|
| data_one |observation_date| :heavy_check_mark: | |
|
|
| data_one |observation_datetime| |
|
|
| data_one |observation_datetime| | |
|
|
| |observation_type_concept_id| default value: 44813951 (Discharge details)|
|
|
| |observation_type_concept_id| :heavy_check_mark: | default value: 44813951 (Discharge details)|
|
|
| data_two |value_as_string| |
|
|
| data_two |value_as_string| | |
|
|
| data_one |visit_occurrence_id| This id represents the visit_occurrence_id of the visit_occurrence table. |
|
|
| data_one |visit_occurrence_id| | This id represents the visit_occurrence_id of the visit_occurrence table. |
|
|
| |visit_detail_id| See post processing for visit_detail_id |
|
|
| |visit_detail_id| | See post processing for visit_detail_id |
|
|
| data_two |observation_source_value| |
|
|
| data_two |observation_source_value| | |
|
|
|
|
|
|
### Input POST_PROCESS_MAP
|
|
### Input POST_PROCESS_MAP
|
|
| id| type | data_one | data_two | omop_id | omop_table |
|
|
| id| type | data_one | data_two | omop_id | omop_table |
|
... | | ... | |