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.

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
  • 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 a single view
    • Eventual database schema
    • CWL workflows
    • Creating Federated Patient Summary
      • First step: Initial in-database data conditioning
      • Second step: Mapping to county FIPS codes
    • Creating Beneficiaries table
    • Creating Enrollments table
      • Enrollments overview
      • Enrollments Primary key (unique identifier)
      • Enrollments data cleansing
      • Enrollments columns definitions
    • Creating Federated Admissions view
    • Creating Inpatient Admissions table
  • 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
• Data dictionary and lineage for Medicare processing
  • Table Lineage Diagram
  • Alphabetic list of all tables
  • Alphabetic list of all columns in all tables
  • The Data Dictionary Generation tool
    • Generating data dictionary
    • Domain Dictionary Output
    • Usage
    • Details
• Medicaid: Building a Data Warehouse from ResDac Files
  • Introduction
  • Importing raw data
    • Parsing FTS files to generate schema
  • Processing data
  • Data Model
    • Beneficiaries
      • BENE_ID column
      • Deduplication and data cleansing
    • Enrollments
    • Eligibility
    • Inpatient Admissions
  • Pipeline
  • Sample user request:
• Querying Medicaid Data
  • Querying diagnoses
    • Listing patients
    • Problem: no wildcarding
    • Calculating numbers