CDM Table: OBSERVATION_PERIOD
The information in the OBSERVATION_PERIOD table is sourced from the Member_Continuous_Enrollment table. This table can contain multiple records per person, each record representing a period of time the person was enrolled in a health benefit Plan. These records are consolidated using the logic below to create records in the OBSERVATION_PERIOD table.
OBSERVATION_PERIOD Table Logic
- Members not in OMOP PERSON table will be excluded.
- Periods of continuous enrollment are consolidated by combining records as long as the time between the end of one enrollment period and the start of the next is less than or equal to 32 days (<= 32 days).
- If the earliest ELIGEFF occurs prior to 05/01/2000 revise ELIGEFF to match the start date of data
MAX(ELIGEFF, '05-01-2000') - If the latest ELIGEND > Member_Continuous_Enrollment last date of Extract_Ym, then edit `ELIGEND = MAX(ELIGEND, Extract_Ym)
Mapping the OBSERVATION_PERIOD table
From the MEMBER_CONTINUOUS_ENROLLMENT table
| Destination Field | Source Field | Applied Rule | Comment |
|---|---|---|---|
| OBSERVATION_PERIOD_ID | System generated. | ||
| PERSON_ID | Member_Continuous_Enrollment PATID | ||
| OBSERVATION_PERIOD_START_DATE | Member_Continuous_Enrollment ELIGEFF | See logic | |
| OBSERVATION_PERIOD_END_DATE | Member_Continuous_Enrollment ELIGEND | See logic | |
| PERIOD_TYPE_CONCEPT_ID | Use concept_id 32813 (‘Claim enrolment record’) |
Common Data Model ETL Mapping Specification for Optum Extended SES & Extended DOD
CDM Version = 5.4.0, Clinformatics Version = v9.0
3-Nov-2023
- Clinformatics Version = v8.0 -> v9.0
- CDM v6.0 -> V5.4