audit created date
aud_crtd_dtDefinition
The timestamp recording when an audit record was initially generated within EHR, claims adjudication, or member enrollment systems, used by data engineers to establish record lineage, support compliance timelines, and enable chronological sorting of audit trail data.
Standard Abbreviation
aud_crtd_dt
Category
quality
Database Usage
-- Example column naming
CREATE TABLE claims (
clm_id VARCHAR(50),
aud_crtd_dt DATE, -- audit created date (date only, no time)
...
);
-- Example in SELECT
SELECT
clm_id,
aud_crtd_dt as audit_created_date
FROM claims;Example database column name
ISO-11179 snake_case standard
-- Recommended column name
aud_crtd_dt
-- Example DDL
CREATE TABLE healthcare_data (
record_id VARCHAR(50) NOT NULL,
aud_crtd_dt DATE, -- audit created date (date only, no time)
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