Back to search

wellness program

wllns_prog_ind
quality·Updated Jun 23, 2026

Definition

ISO-11179 Definition

A health plan or employer-sponsored initiative designed to support member health and wellbeing through preventive care promotion, healthy lifestyle incentives, biometric screening, smoking cessation support, weight management programs, and mental health resources that reduce health risks and prevent the onset of chronic conditions. Wellness programs operate on a population health philosophy that investing in prevention and health promotion generates better long-term outcomes and lower healthcare costs than waiting to treat illness after it develops. ACA provisions allow employers to offer premium discounts of up to 30 percent for employees who participate in wellness programs and meet health status goals.

HEDIS preventive care measures including breast cancer screening, colorectal cancer screening, and childhood immunizations reflect the outcomes of wellness and preventive care program effectiveness. Healthcare data teams measure wellness program impact by tracking preventive service completion rates before and after program implementation, calculating cost trends for program participants versus non-participants with similar risk profiles, and measuring health risk assessment completion rates and biometric screening results to document population health status changes attributed to wellness investments.

Standard Abbreviation

wllns_prog_ind

Category

quality

Production DDL — FACT_QUALITY_MEASURE

FACT_QUALITY_MEASURE.sql
CREATE OR REPLACE TABLE FACT_QUALITY_MEASURE (
    qlty_key        INTEGER        NOT NULL  -- surrogate key,
    mbr_key         INTEGER        NOT NULL  -- FK to DIM_MEMBER,
    plan_key        INTEGER        NOT NULL  -- FK to DIM_PLAN,
    meas_yr         SMALLINT                 -- measurement year,
    hedis_meas_cd   VARCHAR(20)              -- HEDIS measure code,
    denom_ind       CHAR(1)                  -- denominator eligible,
    numer_ind       CHAR(1)                  -- numerator met,
    excl_ind        CHAR(1)                  -- exclusion indicator,
    gap_open_ind    CHAR(1)                  -- care gap open,
    star_rtg_nbr    DECIMAL(3,1)             -- star rating,
    qlty_scr        DECIMAL(5,2)             -- quality score,
    perf_thrsh_pct  DECIMAL(5,2)             -- performance threshold,
    raf_scr         DECIMAL(10,3)            -- risk adjustment factor,
    outreach_cnt    SMALLINT                 -- outreach attempts,
    load_dt         TIMESTAMP_NTZ  NOT NULL  -- load timestamp
);

Standard Snowflake DDL for the canonical quality table. Convert to BigQuery or Databricks →

Why This Term Matters

Quality measure data determines how payers and providers are rated and reimbursed under CMS Stars, HEDIS, and value-based care contracts. Data engineers who understand quality terminology build measure calculation pipelines that correctly attribute patients, apply denominator exclusions, and flag documentation gaps before submission deadlines. Incorrect quality data directly affects star ratings, pay-for-performance bonuses, and Medicare Advantage plan bids.

Related Content

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms