risk stratification
rsk_strat_cdDefinition
ISO-11179 Definition
The process of segmenting a patient population into risk tiers based on predicted healthcare utilization, cost, and clinical complexity to enable targeted deployment of care management resources where they will generate the greatest health and financial return. Risk stratification models combine claims history, diagnosis burden, pharmacy utilization, functional status, social determinants, and prior utilization patterns to calculate composite risk scores that predict which members are likely to require intensive care management, which are rising in risk and could benefit from preventive intervention, and which are stable and low risk requiring only routine preventive care. High-risk members receive intensive case management with dedicated nurse case managers while rising-risk members receive targeted disease management outreach to prevent deterioration.
Healthcare data teams build risk stratification pipelines that apply predictive risk models to member data monthly, assign risk tier codes with supporting clinical rationale, feed stratification outputs to care management platforms for outreach queue prioritization, and measure care management program effectiveness by comparing outcomes for members who received interventions against similar members who did not.
Standard Abbreviation
rsk_strat_cd
Category
Production DDL — FACT_QUALITY_MEASURE
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
Related Definitions
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms