hemoglobin A1c test result
hba1c_rsltDefinition
ISO-11179 Definition
The numeric value of the most recent hemoglobin A1c laboratory test result for a member with diabetes mellitus, expressed as a percentage reflecting average blood glucose control over the preceding two to three months. A1c values are a primary outcome metric in diabetic population management and are required for multiple HEDIS diabetes quality measures.
Standard Abbreviation
hba1c_rslt
Category
Production DDL — FACT_POPULATION_RISK
CREATE OR REPLACE TABLE FACT_POPULATION_RISK (
pop_risk_key INTEGER NOT NULL -- surrogate key,
mbr_id VARCHAR(20) NOT NULL -- member identifier,
msrmt_prd_dt DATE NOT NULL -- measurement period date,
risk_score DECIMAL(8,4) -- risk score,
risk_tier_cd VARCHAR(10) -- risk tier code,
raf_score DECIMAL(8,4) -- RAF score,
hcc_cnt INTEGER -- HCC condition count,
chrnc_cond_cnt INTEGER -- chronic condition count,
ed_visit_cnt INTEGER -- ED visit count,
admit_cnt INTEGER -- admission count,
gap_in_care_cnt INTEGER -- gaps in care count,
care_mgmt_flg BOOLEAN -- care management flag,
outreach_sts_cd VARCHAR(20) -- outreach status code,
model_vrsn VARCHAR(20) -- risk model version,
rec_creat_dt TIMESTAMP NOT NULL -- record created date
);
Standard Snowflake DDL for the canonical population table. Convert to BigQuery or Databricks →
Why This Term Matters
Healthcare data terminology is foundational for any data engineer working in this industry. Precise understanding of standard terms enables accurate schema design, reduces downstream data quality issues, and ensures pipelines meet the regulatory and interoperability requirements imposed by HIPAA, HL7 FHIR, and CMS reporting frameworks. Without this foundation, even technically well-built pipelines produce data that fails validation when it reaches payers or regulators.
Related Content
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms