Tomorrow we have a CDM workgroup meeting at 1pm eastern. We will be finishing our discussion of the PERSON table and (hopefully) move on to the OBSERVATION_PERIOD table. The Skype meeting link can be found on our homepage https://ohdsi.github.io/CommonDataModel/index.html and the straw-man description of the OBSERVATION_PERIOD table is below. Please review and come ready to discuss.
|Field Name||User Guide||ETL Conventions|
|observation_period_id||A Person can have multiple discrete Observation Periods which are identified by the Observation_Period_Id.||Assign a unique observation_period_id to each discrete Observation Period for a Person.|
|person_id||The Person ID of the PERSON record for which the Observation Period is recorded.|
|observation_period_start_date||Use this date to determine the start date of the Observation Period||It is often the case that the idea of Observation Periods does not exist in source data. In those cases, the observation_period_start_date can be inferred as the earliest Event date available for the Person. In insurance claim data, the Observation Period can be considered as the time period the Person is enrolled with a payer. If a Person switches plans but stays with the same payer, and therefore capturing of data continues, that change would be captured in PAYER_PLAN_PERIOD.|
|observation_period_end_date||Use this date to determine the end date of the period for which we can assume that all events for a Person are recorded and any absense of records indicates an absence of events.||It is often the case that the idea of Observation Periods does not exist in source data. In those cases, the observation_period_end_date can be inferred as the last Event date available for the Person. In insurance claim data, the Observation Period can be considered as the time period the Person is enrolled with a payer.|
|period_type_concept_id||This field can be used to determine the provenance of the Observation Period as in whether the period was determined from an insurance enrollment file, EHR healthcare encounters, or other sources.||Choose the observation_period_type_concept_id that best represents how the period was determined.|