advance directive value
advdir_valDefinition
The measured data point for a end-of-life care wishes. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for advance directive management and reporting.
Standard Abbreviation
advdir_val
Category
quality
Database Usage
-- Example column naming
CREATE TABLE claims (
clm_id VARCHAR(50),
advdir_val VARCHAR(100), -- advance directive value (max 100 chars)
...
);
-- Example in SELECT
SELECT
clm_id,
advdir_val as advance_directive_value
FROM claims;Example database column name
ISO-11179 snake_case standard
-- Recommended column name
advdir_val
-- Example DDL
CREATE TABLE healthcare_data (
record_id VARCHAR(50) NOT NULL,
advdir_val VARCHAR(100), -- advance directive value (max 100 chars)
created_dt TIMESTAMP NOT NULL DEFAULT NOW()
);Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.
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.
Common uses in healthcare data
- HEDIS measure rate calculation and reporting
- CMS Stars rating program performance tracking
- Quality improvement initiative monitoring
- Pay-for-performance (P4P) contract analytics
- CAHPS survey data integration and scoring
- HEDIS measure calculation in Snowflake using claims, lab, and pharmacy fact tables
- Epic and Cerner quality data extract (QDE) parsing for hybrid measure reporting
- Databricks measure rate calculation pipelines with year-over-year trend analysis
Related Healthcare Standards
HEDIS (NCQA)
The Healthcare Effectiveness Data and Information Set — the primary quality measure framework used by commercial, Medicare, and Medicaid payers for plan performance reporting.
CMS Stars Quality Rating System
CMS's rating system for Medicare Advantage and Part D plans, based on HEDIS, CAHPS, and HOS measures that directly affect plan bids and bonuses.
HL7 QRDA (Quality Reporting Document Architecture)
The HL7 standard for electronic quality measure data submission to CMS, used for Promoting Interoperability and eCQM reporting.
Data Quality Considerations
- Denominator exclusions are the most common source of HEDIS rate calculation errors — model exclusion flags as explicit boolean columns and audit them against current NCQA technical specifications before submission.
- Hybrid measure data (combining claims and medical record data) requires strict source-of-truth rules — document which data source takes precedence in your Snowflake quality pipeline and enforce it in your transformation logic.
- Measure compliance logic is rate-year specific: a qualifying service for one Stars year may not qualify the next due to specification changes — version your measure logic by measurement year and store the version tag on each calculated rate.
Related Content
Related Definitions
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms