immunization status
immun_stsDefinition
ISO-11179 Definition
Coded value representing the current state of a vaccination record, such as completed, not done, entered-in-error, or contraindicated, as defined by HL7 FHIR Immunization status codes or EHR-specific enumerations. Data engineers use this field to filter valid vaccination events from administrative voids and to drive HEDIS numerator inclusion or exclusion logic in quality reporting pipelines.
Standard Abbreviation
immun_sts
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
Related Definitions
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms