CDM Table name: OBSERVATION_PERIOD
Reading from OPTUM_EHR.Encounter
The OBSERVATION_PERIOD table should be built by setting the OBSERVATION_PERIOD_START_DATE as the date of the earliest encounter available in the data and the OBSERVATION_PERIOD_END_DATE should the the date of the latest encounter in the data, data from the oncology module (type_concept_id=32882) should not be used in the OBSERVATION_PERIOD table creation. If the latest encounter has a year greater than the current year, truncate the date to the current date.
| Destination Field | Source Field | Logic | Comment |
|---|---|---|---|
| observation_period_id | |||
| person_id | ptid | ||
| observation_period_start_date | min(interaction_date) | if date<01-Jan-2007, set to ‘01-Jan-2007’ | |
| observation_period_end_date | max(interaction_date) interaction_date is an event_start_date or event_end_date, except of drug_exposure.drug_exposure_end_date | if date<01-Jan-2007, do not create an entry | |
| period_type_concept_id | 32827 | EHR encounter record |
Change Log
- Removed the use of first_month_active and last_month_active and changed to using the encounter dates instead
19-Apr-2024
- Added logic for how to handle dates greater than the current date
04-Dec-2023
- Oncology event dates excluded from the OBSERVATION PERIOD table
07-Aug-2023
- Cut of dates before 01-Jan-2007 rule added