Dorieh CMS Package (manipulating ResDac Health Data)

Dorieh CMS package provides a number of standalone command line (CLI) utilities to handle health data provided by ResDac and modules that are used in ETL pipelines that build Health Data Warehouse and Feature Store.

The canonical landing page for the Medicare case study is Medicare: Building a Data Warehouse from ResDac Files; the generated data dictionary and lineage documents every table and column of the Medicare warehouse.

Health Data Processing

• Health Data in Dorieh (Medicare and Medicaid)
  • Overview of Health Data Processing
  • Project Structure
    • CWL Workflows
    • Python Utilities
    • Data Model for health data
      • Medicare Tables
      • Medicaid Tables
    • SQL Utilities
      • Stored Procedures
      • Date Parsing Functions
  • Documentation Indices
• Medicare: Building a Data Warehouse from ResDac Files
  • Medallion architecture of the Medicare warehouse
  • Processing pipeline
    • Medicare Pipeline Steps
    • Ingestion of raw data
    • Processing Data in the Database
    • Medicare Pipeline References
  • Ingesting Raw Files
    • Overview of Ingesting Raw Medicare Files
    • Storing raw data in the Database
    • Files for 1999 to 2010
    • Files for Years 2011 and later
      • Metadata Extraction
      • Ingestion process
      • Directory Layout Expectation
  • Combining raw files into unified views
    • Eventual database schema
    • CWL workflows
    • Creating Federated Patient Summary
      • First step: Initial in-database data conditioning
      • Second step: Mapping to county FIPS codes
    • Creating the mbsf_d dual-eligibility view
    • Creating Beneficiaries table
      • Beneficiary enrollment-span columns
    • Creating Enrollments table
      • Enrollments overview
      • Enrollments Primary key (unique identifier)
      • Enrollments data cleansing
      • Enrollments columns definitions
    • Entitlement reason codes: OREC and CUREC
    • Creating Federated Admissions view
    • Creating Inpatient Admissions table
      • Additional admissions columns
  • Creating QC Tables
    • Medicare QC approach
    • Enrollments QC Table
      • Enrollments QC Table Definition
      • Enrollments QC Table Dimensions
      • Enrollments QC Table Measures
    • Admissions QC Table
      • Admissions QC Table Definition
      • Admissions QC Table Dimensions
      • Admissions QC Table Measures
• Medicaid: Building a Data Warehouse from ResDac Files
  • Introduction
  • Importing raw data
    • Parsing FTS files to generate schema
  • Data Model
    • Beneficiaries
      • BENE_ID column
      • Deduplication and data cleansing
    • Enrollments
    • Eligibility
    • Inpatient Admissions
  • Pipeline
  • Sample user request:
• See also

Related pages that live in other sections of this documentation:

• Querying Medicaid Data — under Platform Capabilities