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

Quality

HEDIS, Stars ratings, measures, outcomes and accreditation

1,622 quality terms

value modified timeval_mod_tm

Timestamp recording when a clinical or administrative data value was last updated in the system. Used in audit trails and data lineage tracking to ensure data integrity, identify concurrent edits, and support change history analysis across EHR and clinical data warehouse environments.

value nameval_nm

Human-readable label assigned to a specific clinical or administrative data element, used to identify and display the value in user interfaces, reports, and data exchange transactions. Supports standardized naming conventions across EHR, HIS, and interoperability frameworks such as HL7 and FHIR.

value noteval_nt

Free-text annotation associated with a clinical or administrative data value, capturing supplemental context, clinician observations, or workflow remarks. Used in EHR documentation, care coordination, and clinical data warehouses to provide qualitative detail that structured fields cannot fully express.

value numberval_nbr

Numeric identifier or sequencing reference assigned to a specific clinical or administrative data value, enabling precise tracking, deduplication, and cross-system linkage. Commonly used in EHR, claims processing, and clinical data warehouses to maintain referential integrity across related records.

value onset dateval_onset_dt

Date on which a clinical condition, symptom, or observable event associated with a data value first occurred. Used in diagnosis tracking, chronic disease management, and clinical documentation workflows to establish clinical timelines and support accurate coding in EHR and claims systems.

value oxygen saturationval_o2sat

Recorded peripheral oxygen saturation (SpO2) measurement expressed as a percentage, captured during clinical assessments or continuous patient monitoring. Used in vital signs documentation, respiratory care management, and clinical decision support within EHR and inpatient clinical data systems.

value paid amountval_pd_amt

Monetary amount actually disbursed for a healthcare service or claim transaction, reflecting adjudicated payment after applying contractual adjustments, copays, and deductibles. Used in claims processing, remittance reconciliation, and financial reporting across payer and provider revenue cycle systems.

value paid dateval_pd_dt

Date on which payment was issued for a healthcare claim or financial transaction following adjudication. Used in revenue cycle management, remittance processing, and accounts receivable tracking to monitor payment cycles, identify delays, and reconcile transactions across payer and billing systems.

value parentval_prnt

Reference to the hierarchically superior data element or record to which a subordinate value belongs, enabling tree-structured data relationships. Used in clinical terminology hierarchies, organizational structures, and reference data management within EHR and healthcare information systems.

value percentageval_pct

Proportional value expressed as a percentage, representing a share, rate, or comparative measure within a clinical or financial context. Used in benefit calculations, lab result interpretation, quality metric reporting, and cost-sharing determinations across claims, enrollment, and clinical data systems.

value periodval_prd

Defined time interval during which a clinical measurement, benefit, authorization, or administrative data value is considered active or applicable. Used in eligibility verification, care plan management, benefit period tracking, and longitudinal clinical data analysis across EHR and payer systems.

value phoneval_ph

Telephone number associated with a patient, member, facility, or contact record within a healthcare data system. Used in care coordination, member outreach, appointment scheduling, and claims correspondence to enable direct communication across EHR, member enrollment, and claims platforms.

value preferred nameval_pref_nm

The preferred or chosen display label for a data element, code, or individual, used to personalize system interfaces and documentation. In patient contexts, reflects the name a patient uses in daily life. Supports patient-centered care and identity management across EHR and member systems.

value priceval_prc

Monetary amount representing the charged or contracted cost of a healthcare service, procedure, supply, or pharmaceutical item. Used in claims adjudication, fee schedule management, drug pricing, and provider contract analysis across revenue cycle, pharmacy, and payer data systems.

value primary indicatorval_prim_ind

Boolean or coded flag designating a specific data value as the primary or principal record among multiple related entries, such as a primary diagnosis, primary insurance, or primary care provider. Used to drive adjudication logic, reporting hierarchies, and clinical workflow prioritization.

value priorityval_prty

Ranked or coded designation indicating the relative urgency, importance, or processing order of a clinical task, diagnosis, authorization request, or administrative transaction. Used in care management workflows, utilization management, clinical decision support, and claims processing queue management.

value pulseval_pulse

Recorded heart rate measurement in beats per minute (BPM) captured as part of a patient vital signs assessment. Used in clinical monitoring, acute care documentation, chronic disease management, and clinical decision support within EHR systems and inpatient care settings.

value quantityval_qty

Numeric count or volume associated with a clinical or administrative transaction, such as units of medication dispensed, procedures performed, or supplies utilized. Used in pharmacy dispensing, claims line detail, inventory management, and clinical order documentation across healthcare data systems.

value raceval_race

Patient or member self-reported racial identity classification captured using standardized coding sets such as OMB or CDC race categories. Used in population health analytics, health equity reporting, care gap identification, and compliance with federal demographic data collection requirements.

value rateval_rt

Numeric value expressing a frequency, reimbursement rate, utilization measure, or per-unit cost within a clinical or financial context. Used in provider contract management, drug dosing schedules, actuarial modeling, and claims reimbursement calculations across payer and clinical data systems.

PreviousPage 79 of 82Next