Skip to content

Changes

Page history
Update Observation_Period Mapping authored by Henke, Elisa's avatar Henke, Elisa
Hide whitespace changes
Inline Side-by-side
Observation_Period-Mapping.md
View page @ 319a7f67
......@@ -5,13 +5,13 @@
:information_source: The original data is written in the `cds_etl_helper.POST_PROCESS_MAP` table, which was read from Encounter FHIR resource.
## POST_PROCESS_MAP to OBSERVATION_PERIOD
| Source | Target | Comments |
| :---------------- | :---------------------- | :------------------------------------------------- |
||observation_period_id|This id is generated automatically.|
|omop_id|person_id|This id represents the person_id of the person table.|
|data_one|observation_period_start_date |the very first visit|
|data_two|observation_period_end_date| the very last visit |
||period_type_concept_id|default value: 44814724 (Period covering healthcare encounters)|
| OMOP (source) | OMOP (target) | OMOP (target) - required | Comments |
| :----------------: | :----------------: | :----------------: | :----------------: |
||observation_period_id| :heavy_check_mark: |This id is generated automatically.|
|omop_id|person_id| :heavy_check_mark: |This id represents the person_id of the person table.|
|data_one|observation_period_start_date | :heavy_check_mark: |the very first visit|
|data_two|observation_period_end_date| :heavy_check_mark: | the very last visit |
||period_type_concept_id| :heavy_check_mark: |default value: 44814724 (Period covering healthcare encounters)|
## Example
|observation_period_id|person_id|observation_period_start_date|observation_period_end_date|period_type_concept_id|
......