2025Q1 Data Release

2025Q1 Data Release Notes

1. General Updates

Framework

• Add support of the multiple VALUE_AS_CONCEPT_ID
• Refactoring/bug fixes
• Performance improvements

2. Source Specific Updates

CCAE, MDCR and MDCD

• Death Changes: Death logic was removed as it is likely unrepresentative and incomplete

Premier

• Death Changes: Death logic was removed as it is likely unrepresentative and incomplete

SES

• Death Changes: Death logic was removed as it is likely unrepresentative and incomplete

DOD

• Death Changes:
  • Removed any death dates that occur prior to any observation_period_start_date or year_of_birth
  • Removed any records > 60 days after death
  • Remove any death dates where the associated observation_period_end_date >= 365 days after the death.

CPRD

• Death Changes:
  • Removed any death dates that occur prior to any observation_period_start_date or year_of_birth
  • Removed any records > 60 days after death

Health Verity Comprehensive Claims

• Race and Ethnicity Changes: Race was added to ETL
• Death Changes:
  • Removed any death dates that occur prior to any observation_period_start_date or year_of_birth
  • Removed any records > 60 days after death
  • Remove any death dates where the associated observation_period_end_date >= 365 days after the death

JMDC

• Mother-child linkage: Algorithm to link mothers and infants was added
• Annual_health_checkup: Update smoking_habit, drinking_habit and and eating_habit mappings
• Death Changes:
  • Removed any death dates that occur prior to any observation_period_start_date or year_of_birth
  • Removed any records > 60 days after death

2024Q3 Data Release

2024Q3 Data Release Notes

1. New Data Sources Available

Health Verity Comprehensive Claims

The HealthVerity Comprehensive Claims (Closed Claims Enrollment) derived data set contains de-identified linked patient information from select private data providers participating in the HealthVerity marketplace. This data extract includes 3 data sources across medical and pharmacy closed claims data, 9 sources providing open medical claims, 8 sources providing open pharmacy claims, and 1 source providing linked death data.

During the transformation to the OMOP CDM, only patients with enrollment in one of the two closed claims sources are included. The reasoning behind this is twofold. First, by using only patients with closed claims enrollment there is a high probability that any interaction with the health care system will be recorded. Data from the other linked sources, like laboratory data, becomes additional clinical context while retaining the low likelihood that adverse events would be missing from the record altogether. Second, the time during which a person is enrolled in a closed claims system provides more accurate person-time calculations.

2. General Updates

Mosunetuzumab

The drug mosunetuzumab recently came to market and it was given a HCPCS code that was used previously and discontinued in 2014 (J9350). Because of this reuse, mosunetuzumab was being incorrectly mapped to the drug topotecan. We introduced a vocabulary update that identifies this reuse and assigns the appropriate standard concept based on date.

Framework

Refactoring/bug fixes

3. Source Specific Updates

Optum Extended

• Race and Ethnicity Changes: Optum Extended recently updated their source of race and ethnicity data. It now uses self-reported data that splits these values into two variables. The mapping logic was updated to reflect this change and all details can be found here: https://ohdsi.github.io/ETL-LambdaBuilder/Optum%20Clinformatics/Optum_person.html#mapping-race

• Death Changes: A small number of patients in Optum Extended Date of Death (DOD) had a death date that occurred prior to their OBSERVATION_PERIOD_START_DATE. In consulting with the vendor we learned that this is likely an error in the death date linkage so those deaths were removed.

Optum EHR

• Future Dates: Some patient's OBSERVATION_PERIOD_END_DATE occur in the future. This is due to a data quatlity error in the native data. In these cases the OBSERVATION_PERIOD_END_DATE is set to the source release date.

CDM to CDM Builder

• The build logic was update to remove patients that do not have a valid gender. Only patients with a Male or Female value are kept.

v.1.0.1

• Optum Extended SES, added the SES table
• Added CDM to CDM builder
• Added logic for processing SOURCE_INVALID_REASON = 'R'
• Other source/documentation fixes and updates

v.1.0.0

Initial release