Dorieh Data Platform

Contents

  • Introduction
  • What is Data Platform
  • Data Domains
    • Health
      • Health Data in Dorieh (Medicare and Medicaid)
      • Medicare: Building a Data Warehouse from ResDac Files
      • 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
      • Medicaid: Building a Data Warehouse from ResDac Files
      • Querying Medicaid Data
    • Climate
    • Exposure (from Atmospheric Composition Analysis Group of Washington University in St. Louis)
    • Environmental Protection Agency (EPA) data
    • Demographics
  • Data Processing Pipelines
  • Python Packages
  • Data Modelling for Dorieh Data Platform
  • Examples
  • Dorieh Tutorials
  • Data Platform Internals
  • Database Testing Framework
  • Adding more data
  • Executing containerized apps
  • Terms and Acronyms
  • Indices
Dorieh Data Platform
  • Data Domains
  • Dorieh CMS Package (manipulating ResDac Health Data)
  • Medicare: Building a Data Warehouse from ResDac Files
  • Data dictionary and lineage for Medicare processing
  • Table Lineage Diagram
  • View medicare.qc_enrl_bene
  • Column medicare.qc_enrl_bene.dual_cvg_count
  • Column medicare.qc_enrl_bene.dual_cvg_count Lineage SVG
  • View page source

Column medicare.qc_enrl_bene.dual_cvg_count Lineage SVG

medicare.qc_enrl_bene.dual_cvg_count medicare.qc_enrl_bene.dual_cvg_count (CASE   WHEN EXISTS (SELECT * FROM medicare.mbsf_d AS d WHERE medicare._ps.year = d.year and medicare._ps.bene_id = d.bene_id)   THEN       COALESCE((SELECT MAX(dual_mo) FROM medicare.mbsf_d AS d WHERE medicare._ps.year = d.year and medicare._ps.bene_id = d.bene_id), 0)   ELSE NULLEND) medicare.enrollments.dual_cvg_count medicare.enrollments.dual_cvg_count (CASE   WHEN EXISTS (SELECT * FROM medicare.mbsf_d AS d WHERE medicare._ps.year = d.year and medicare._ps.bene_id = d.bene_id)   THEN       COALESCE((SELECT MAX(dual_mo) FROM medicare.mbsf_d AS d WHERE medicare._ps.year = d.year and medicare._ps.bene_id = d.bene_id), 0)   ELSE NULLEND) medicare.enrollments.dual_cvg_count->medicare.qc_enrl_bene.dual_cvg_count join natural medicare._enrollments.dual_cvg_count medicare._enrollments.dual_cvg_count (CASE   WHEN EXISTS (SELECT * FROM medicare.mbsf_d AS d WHERE medicare._ps.year = d.year and medicare._ps.bene_id = d.bene_id)   THEN       COALESCE((SELECT MAX(dual_mo) FROM medicare.mbsf_d AS d WHERE medicare._ps.year = d.year and medicare._ps.bene_id = d.bene_id), 0)   ELSE NULLEND) medicare._enrollments.dual_cvg_count->medicare.enrollments.dual_cvg_count Copied
Previous Next

© Copyright 2021-2024, Harvard University.

Built with Sphinx using a theme provided by Read the Docs.