Optum Clinformatics (Optum) ETL Documentation

These materials are meant to serve as documentation and reference for how the Optum Clinformatics database was converted to the OMOP Common Data Model (CDM).

Change Log

February 14, 2025

• As of the 2025Q1 release, we are no longer imputing DEATH logic for Optum SES as it is likely unrepresentative and incomplete. For prior releases, refer to the imputation logic that was used here.

---

Table of contents

• Person
• Observation Period
• Payer Plan Period
• Care Site
• Location
• Provider
• Visit_Detail
• Visit_Occurrence
• Optum Clinformatics to STEM
• Death