mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Population

Public health, prevention, epidemiology and wellness

410 population terms

health risk assessment completion flaghra_compl_flg

A flag indicating that a member completed a standardized health risk assessment during the measurement period, a key data collection tool used to identify social determinants of health, behavioral health risk factors, functional limitations, and health goals that may not be captured in claims data.

health risk assessment scorehra_scr

A composite score derived from a member's health risk assessment responses, summarizing overall health risk across physical, behavioral, and social domains. HRA scores are used to prioritize outreach efforts, assign members to appropriate care management programs, and track risk score changes over time as an intervention effectiveness indicator.

hemoglobin A1c poor control flaghba1c_poor_ctrl_flg

A flag identifying a diabetic member whose most recent hemoglobin A1c result exceeded a defined threshold indicating poor glycemic control, typically greater than 9 percent. This flag corresponds to the HEDIS Comprehensive Diabetes Care poor control measure and identifies members requiring intensified care management intervention to improve glycemic outcomes.

hemoglobin A1c test resulthba1c_rslt

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.

high-cost claimant flaghigh_cost_clmnt_flg

A flag identifying a member whose total paid claims exceeded a defined high-cost threshold during a measurement period, typically the top 1 to 5 percent of the population by cost. High-cost claimants represent a disproportionate share of total healthcare expenditures and are primary targets for complex care management programs aimed at reducing avoidable utilization.

hospice enrollment flaghospice_enrl_flg

A flag indicating that a member is enrolled in a Medicare or Medicaid hospice benefit, electing palliative comfort care in lieu of curative treatment for a terminal illness with a prognosis of six months or less. Hospice enrollment affects claims adjudication, care management program eligibility, and total cost of care calculations.

housing instability indicatorhous_instblty_ind

A flag identifying a member as experiencing housing instability, homelessness, or inadequate housing conditions based on ICD-10-CM Z codes, screening tool responses, or case manager assessments. Housing instability is strongly associated with higher ED utilization, medication non-adherence, and poor chronic disease management outcomes.

hypertension indicatorhtn_ind

A flag identifying a member with a hypertension diagnosis based on ICD-10-CM codes in the I10 through I16 range or pharmacy claims for antihypertensive medications. Hypertension is among the most common chronic conditions in managed care populations and is strongly associated with cardiovascular disease risk and total cost of care.

immunization active indicatorimmun_actv_ind

Binary flag indicating whether an immunization record is currently active in the patient's vaccination history. Used in immunization registries and EHR systems to distinguish valid administered vaccine records from voided, duplicate, or historically inactivated entries requiring exclusion from clinical reporting.

immunization active statusimmun_actv_sts

Categorical status value describing the current lifecycle state of a vaccination record within an immunization registry or clinical system. Identifies whether the record is active, inactive, pending, or voided, supporting accurate immunization history reporting and patient care coordination across clinical workflows.

immunization addressimmun_addr

The physical location associated with a vaccination record, capturing the site where the immunization was administered such as clinic, pharmacy, or school. Used in EHR and immunization registry systems to support geographic analysis, site-level reporting, and public health surveillance data submissions.

immunization adjustment amountimmun_adj_amt

Dollar value representing a financial modification applied to an immunization claim or billing transaction, such as a contractual write-off, payer discount, or correction. Used in claims adjudication systems to reconcile billed charges against allowable amounts for vaccine administration reimbursement.

immunization ageimmun_age

Patient's age at the time of vaccine administration, typically expressed in years, months, or days depending on pediatric context. Critical for validating age-appropriate vaccine scheduling against CDC immunization schedules and identifying patients eligible for specific age-dependent vaccination protocols.

immunization allowed amountimmun_alwd_amt

Maximum dollar amount a payer will reimburse for a vaccine administration event under the terms of a provider contract or fee schedule. Used in claims processing to establish payment limits for immunization services, with any amount exceeding this threshold typically becoming a patient or provider responsibility.

immunization amountimmun_amt

The monetary value associated with administering a vaccine, including vaccine acquisition cost and administration fees recorded in claims and EHR billing systems. Used in pharmacy, PBM, and revenue cycle pipelines to reconcile vaccine-related reimbursements against contracted rates and formulary cost-sharing rules.

immunization approval statusimmun_appr_sts

Authorization state indicating whether a vaccination administration has been reviewed and approved by a clinical authority, payer, or registry administrator. Used in workflow management systems to track whether immunization records or associated claims have cleared required review processes before finalization or payment.

immunization approved byimmun_appr_by

Identifier or name of the clinician, supervisor, or system user who authorized or approved the immunization administration record. Used in clinical audit trails and immunization registries to establish accountability and support quality assurance reviews of vaccine documentation and administration workflows.

immunization arrival timeimmun_arrv_tm

Timestamp recording when a patient arrived at the clinical site for a scheduled or walk-in immunization encounter. Used in immunization clinic workflow management to measure patient throughput, wait times, and operational efficiency during vaccination events, including mass immunization campaigns.

immunization arrived dateimmun_arrv_dt

Calendar date on which a patient presented at a clinical location for a vaccination encounter. Used in immunization registries and clinic management systems to track appointment adherence, calculate delays between scheduled and actual visit dates, and support outbreak response immunization event documentation.

immunization assessmentimmun_asmt

Clinician's documented evaluation of a patient's suitability for vaccine administration, including pre-vaccination screening findings such as contraindications, precautions, allergies, or current health status. Supports clinical decision-making and serves as evidence of informed vaccination practice in immunization records.

PreviousPage 4 of 21Next