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

Please contact Clair Blacketer (https://github.com/clairblacketer) if you have any questions