... | ... | @@ -11,12 +11,12 @@ |
|
|
|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)|
|
|
|
||period_type_concept_id| :heavy_check_mark: |default value: 32817 (EHR)|
|
|
|
|
|
|
## Example
|
|
|
|observation_period_id|person_id|observation_period_start_date|observation_period_end_date|period_type_concept_id|
|
|
|
|-----|-----|-----|-----|-----|
|
|
|
|1|1|2018-09-17|2018-09-26|44814724|
|
|
|
|1|1|2018-09-17|2018-09-26|32817|
|
|
|
|
|
|
## SQL Script
|
|
|
```sql
|
... | ... | @@ -30,7 +30,7 @@ WITH post_process AS |
|
|
omop_id
|
|
|
, TO_DATE(min(data_one), 'YYYY-MM-DD') AS startDate
|
|
|
, TO_DATE(max(data_two), 'YYYY-MM-DD') AS endDate
|
|
|
, 44814724 AS period_type_concept_id
|
|
|
, 32817 AS period_type_concept_id
|
|
|
FROM cds_etl_helper.post_process_map
|
|
|
WHERE type = 'ENCOUNTER'
|
|
|
AND omop_table = 'observation_period'
|
... | ... | |