2.2 Healthcare Datasets, Benchmarks & Population Health

Healthcare Datasets, Benchmarks & Population Health

Healthcare data analysts frequently leverage external datasets and national benchmarks to contextualize institutional performance, evaluate market share, design risk-adjustment models, and address population health disparities. Understanding the architectural structure, clinical granularity, financial validity, and inherent limitations of secondary datasets is a core competency tested on the CHDA examination.

---

Administrative Claims Datasets

Administrative claims data is generated during the healthcare revenue cycle when providers bill third-party payers for services rendered. Claims are formatted according to HIPAA Electronic Data Interchange (EDI) standards, specifically the ASC X12 837I (Institutional) and ASC X12 837P (Professional) transaction formats.

                               ADMINISTRATIVE CLAIMS ATTRIBUTES
 ┌──────────────────────────────────────────────┬──────────────────────────────────────────────┐
 │               CORE ADVANTAGES                │              CORE LIMITATIONS                │
 ├──────────────────────────────────────────────┼──────────────────────────────────────────────┤
 │ • Standardized formats across all providers  │ • Lack of clinical nuance & lab values       │
 │ • Complete longitudinal utilization tracking │ • Adjudication lag (often 60 to 180+ days)   │
 │ • Accurate adjudicated financial data        │ • Coding driven by reimbursement rules       │
 │ • Massive population-level sample sizes      │ • Inability to capture unbilled care         │
 └──────────────────────────────────────────────┴──────────────────────────────────────────────┘

1. Medicare Standard Analytical Files (SAF)

CMS produces the Standard Analytical Files (SAF), which contain 100% of all adjudicated Medicare Fee-for-Service (FFS) claims. SAFs are segmented by care setting:

• Inpatient SAF: Inpatient hospital claims (UB-04 / 837I).
• Outpatient SAF: Hospital outpatient department, ambulatory surgery center, and clinic claims.
• Carrier (Physician/Supplier) SAF: Professional services billed by physicians and practitioners (CMS-1500 / 837P).
• Skilled Nursing Facility (SNF), Home Health Agency (HHA), Hospice, and Durable Medical Equipment (DME) SAFs.
• Analytic Utility: SAF files provide complete line-item detail, revenue codes, modifier codes, National Drug Codes (NDC), allowed charges, and Medicare payment amounts.

2. Medicare Provider Analysis and Review (MedPAR) File

The MedPAR file aggregates Medicare inpatient hospital and skilled nursing facility claim records into a single consolidated record per beneficiary stay / admission.

• Structure: Rather than presenting multiple interim claim line items, MedPAR condenses the entire hospitalization into one record containing the Medicare Severity Diagnosis-Related Group (MS-DRG), principal and secondary ICD-10-CM/PCS codes, admission/discharge dates, length of stay (LOS), total charges, covered charges, and Medicare reimbursement amounts.
• Analytic Utility: MedPAR is the industry standard benchmark for hospital market share analysis, inpatient utilization tracking, geographic variation studies, and hospital Case Mix Index (CMI) benchmarking.

3. Healthcare Cost and Utilization Project (HCUP)

Sponsored by the Agency for Healthcare Research and Quality (AHRQ), HCUP is the largest collection of longitudinal, all-payer hospital care data in the United States, linking state data organizations, hospital associations, and private data organizations with the federal government.

• National (Nationwide) Inpatient Sample (NIS): The largest publicly available all-payer inpatient database in the US. The NIS represents a 20% stratified sample of discharges from all US community hospitals (excluding rehabilitation and long-term acute care facilities). When weighted using HCUP discharge weights (DISCWT), it produces unbiased national estimates representing ~35 million hospitalizations annually.
• Nationwide Emergency Department Sample (NEDS): Captures emergency department visits from over 950 hospitals, enabling national analyses of emergency care regardless of whether the visit resulted in an admission or discharge.
• Kids' Inpatient Database (KID): Specifically sampled to analyze pediatric hospitalizations and rare childhood conditions.
• State Databases (SID, SEDD, SASD): State Inpatient Databases (SID), State Emergency Department Databases (SEDD), and State Ambulatory Surgery and Services Databases (SASD) capture 100% of discharges within participating states, enabling comprehensive regional and state-level analyses.

4. All-Payer Claims Databases (APCDs)

APCDs are state-mandated or voluntary data repositories that collect medical, pharmacy, and dental claims from commercial health plans, Medicare Advantage, Medicaid managed care, and public programs.

• Analytic Utility: APCDs provide comprehensive insight into commercial pricing variations, total cost of care across diverse payer types, and out-of-pocket patient liability across entire geographic populations.

---

Clinical Registries

Unlike administrative claims, clinical registries capture granular physiological, anatomical, procedural, and longitudinal outcome data directly from clinical records and specialized clinical workflows.

  Claims Data:   [ICD-10: I21.09] ──> "ST-elevation myocardial infarction" (Billing Category)
  Registry Data: [NCDR CathPCI]   ──> Door-to-balloon time = 52 min, 99% LAD occlusion, 3.5x18mm drug-eluting stent

1. Cardiovascular Registries (NCDR)

The National Cardiovascular Data Registry (NCDR), managed by the American College of Cardiology (ACC), comprises specialized clinical registries:

• CathPCI Registry: Assesses characteristics, treatments, and outcomes for cardiac catheterization and percutaneous coronary intervention (PCI) procedures (e.g., door-to-balloon times, stent types, fluoroscopy duration, vessel anatomy).
• ACTION Registry (Chest Pain-MI): Tracks acute myocardial infarction clinical management and adherence to ACC/AHA guideline-directed medical therapy.
• STS/ACC TVT Registry: Monitors transcatheter valve therapies (TAVR/TEER) in partnership with the Society of Thoracic Surgeons.

2. Cancer Registries (SEER & NCDB)

• Surveillance, Epidemiology, and End Results (SEER) Program: Administered by the National Cancer Institute (NCI), SEER collects population-based cancer incidence, stage at diagnosis (AJCC TNM classification), tumor histology, primary treatment modalities, and longitudinal survival data from central cancer registries covering ~48% of the US population.
• National Cancer Database (NCDB): A joint clinical registry operated by the Commission on Cancer (CoC) of the American College of Surgeons and the American Cancer Society, capturing ~70% of all newly diagnosed cancer cases from accredited hospital cancer programs.

3. Trauma & Public Health Registries

• National Trauma Data Bank (NTDB): Operated by the American College of Surgeons (ACS), aggregating standardized trauma metrics including Injury Severity Score (ISS), Revised Trauma Score (RTS), Glasgow Coma Scale (GCS), mechanism of injury, and emergency surgical intervention intervals.
• Immunization Information Systems (IIS): Confidential, population-based, computer-based databases that record all vaccine doses administered by participating providers within a geographic jurisdiction, essential for calculating immunization coverage rates and tracking vaccine series completion.

---

Public Health & Epidemiological Datasets

Public health datasets provide population-level baselines and epidemiologic benchmarks essential for health status assessment, health services research, and community health needs assessments (CHNA).

---

Social Determinants of Health (SDOH) Data & Indices

Social Determinants of Health (SDOH) are the non-medical conditions in which people are born, grow, live, work, and age. Research demonstrates that clinical medical care accounts for only ~20% of modifiable health outcomes, while SDOH factors, physical environments, and behavioral factors drive the remaining ~80%.

                         DRIVERS OF HEALTH OUTCOMES
 ┌───────────────────────────────────────────────┬─────────────────────────────┐
 │ SDOH, Socioeconomic & Environmental Factors   │  Clinical Medical Care      │
 │ (Income, Housing, Food Security, Education)   │  (Inpatient, Outpatient, Rx)│
 │                 ~80% Impact                   │         ~20% Impact         │
 └───────────────────────────────────────────────┴─────────────────────────────┘

1. ICD-10-CM SDOH Z-Codes (Z55–Z65)

ICD-10-CM provides discrete diagnosis codes to capture patient-level social, economic, and environmental risk factors:

• Z55: Problems related to education and literacy (e.g., illiteracy, underachievement).
• Z56: Problems related to employment and unemployment (e.g., job loss, stressful working conditions).
• Z57: Occupational exposure to risk factors (e.g., toxic substances, noise, extreme temperatures).
• Z59: Problems related to housing and economic circumstances (e.g., Z59.0 Homelessness, Z59.4 Lack of adequate food/food insecurity, Z59.1 Inadequate housing).
• Z60: Problems related to social environment (e.g., living alone, acculturation difficulty).
• Z62: Problems related to upbringing (e.g., parent-child conflict, history of abuse).
• Z63: Other problems related to primary support group, including family circumstances.
• Z65: Problems related to other psychosocial circumstances (e.g., incarceration).

CHDA Coding Rule: Official ICD-10-CM Coding Guidelines allow SDOH Z-codes (Z55–Z65) to be assigned based on documentation from any healthcare team member (e.g., social workers, case managers, discharge planners, nurses, community health workers), not solely the treating physician.

2. Composite SDOH Indices

When patient-level Z-codes are under-documented, analysts use geographic composite indices linked via patient residential ZIP codes or 12-digit Census Block Group Federal Information Processing Standards (FIPS) codes.

                               COMPOSITE SDOH INDICES
 ┌──────────────────────────────────────────────┬──────────────────────────────────────────────┐
 │        AREA DEPRIVATION INDEX (ADI)          │       SOCIAL VULNERABILITY INDEX (SVI)       │
 ├──────────────────────────────────────────────┼──────────────────────────────────────────────┤
 │ • Developed by HRSA / Univ. of Wisconsin     │ • Developed by CDC / ATSDR                   │
 │ • 17 US Census / ACS indicators              │ • 16 US Census / ACS indicators              │
 │ • Granularity: Census Block Group level      │ • Granularity: Census Tract level            │
 │ • Metrics: Income, education, housing, car   │ • 4 Themes: Socioeconomic, Household,        │
 │ • Output: National percentiles (1–100) or    │   Minority/Language, Housing/Transportation  │
 │   State deciles (1–10; 10 = most deprived)   │ • Output: Percentile rank (0.000 to 1.000)   │
 └──────────────────────────────────────────────┴──────────────────────────────────────────────┘

---

Cross-Dataset Comparison Matrix