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,621 quality terms

audit middle nameaud_mid_nm

The middle name or initial of the individual associated with an audited record, captured at the time of the audit event. Used to confirm patient or user identity during record reviews, supporting accurate matching when first and last names alone may be insufficient.

audit minimumaud_min

The lower boundary value captured in an audit trail record, used to validate that clinical measurements, claim amounts, or data entries meet minimum acceptable thresholds. Supports range-based data integrity checks and flags anomalies during compliance or quality reviews.

audit mobileaud_mob

The mobile phone number of the patient, member, or user associated with an audited record at the time the audit event was captured. Preserved in the audit log to reflect contact information as it existed when the record was reviewed or modified.

audit modified byaud_mod_by

The unique identifier of the user or system that last updated the audited record. Captured in the audit trail to support accountability, traceability, and compliance reporting by establishing who made changes to clinical, administrative, or claims data.

audit modified dateaud_mod_dt

Timestamp capturing the most recent modification to an audit record in healthcare claims, EHR, or PBM systems. Critical for data engineers tracking record version history, reconciling incremental data loads, and ensuring change data capture processes reflect the latest audit state.

audit modified timeaud_mod_tm

The timestamp recording when an audited record was last updated. Captured in the audit trail to establish a chronological history of changes to clinical, administrative, or claims data, supporting compliance reviews, dispute resolution, and forensic analysis.

audit nameaud_nm

Descriptive label identifying a specific audit process or review initiative in healthcare claims, compliance, or EHR systems. Used by data engineers to categorize and join audit records across datasets, populate reporting dashboards, and maintain consistent naming conventions in audit management platforms.

audit noteaud_nt

Free-text annotation field associated with a healthcare audit record in claims, EHR, or compliance systems. Captures reviewer comments, findings, or follow-up actions. Data engineers use this field for text parsing, audit trail documentation, and populating case management or compliance reporting systems.

audit numberaud_nbr

Unique numeric identifier assigned to a specific audit record or review event in healthcare claims, EHR, or PBM systems. Used by data engineers as a primary or foreign key to join audit records across tables, track individual review cases, and support reconciliation in compliance reporting pipelines.

audit onset dateaud_onset_dt

The date a condition, symptom, or clinical event began, as recorded in the audited clinical record. Captured in the audit trail to preserve the original onset information at the time of review, supporting retrospective clinical analysis and coding compliance audits.

audit oxygen saturationaud_o2sat

The blood oxygen saturation level recorded in the audited clinical record, expressed as a percentage. Captured in the audit trail to preserve the vital sign value at the time of documentation review, supporting clinical quality audits and patient safety assessments.

audit paid amountaud_pd_amt

The dollar amount paid on a claim or transaction as recorded in the audited financial record. Captured in the audit trail to preserve payment data at the time of review, supporting claims accuracy audits, overpayment recovery, and financial compliance investigations.

audit paid dateaud_pd_dt

The date on which payment was issued for a claim or financial transaction, as recorded in the audited record. Preserved in the audit trail to support claims adjudication reviews, timely payment compliance checks, and financial reconciliation across payer systems.

audit parentaud_prnt

Reference identifier linking an audit record to its superior or originating audit entity within hierarchical healthcare compliance or claims systems. Used by data engineers to traverse parent-child audit relationships, aggregate results at higher organizational levels, and support recursive queries in audit data models.

audit percentageaud_pct

Calculated ratio value representing a proportional metric within a healthcare audit process, such as claim error rate or compliance pass rate in claims or EHR systems. Used by data engineers to populate performance scorecards, trigger threshold-based alerts, and support trend analysis in audit reporting pipelines.

audit periodaud_prd

Defined time span during which a healthcare audit review is conducted, applicable across claims, EHR, pharmacy, and member enrollment systems. Used by data engineers to partition audit datasets, apply date range filters during ETL processing, and align audit records with reporting cycles or regulatory review windows.

audit phoneaud_ph

Telephone contact number associated with an audit record or reviewing entity in healthcare compliance, claims, or provider management systems. Used by data engineers to populate contact directories, support outreach workflows, and validate contact data quality during audit record integration and transformation processes.

audit planaud_pln

The clinical treatment plan or care strategy documented in the audited clinical record. Captured in the audit trail to preserve the plan as it existed at the time of review, supporting clinical documentation audits, coding accuracy reviews, and care quality assessments.

audit policy numberaud_pol_nbr

The insurance policy identifier associated with the audited member or claim record. Captured in the audit trail to link audit findings to a specific coverage policy, supporting eligibility verification audits, claims accuracy reviews, and payer compliance investigations.

audit preferred nameaud_pref_nm

The preferred or chosen display name of the patient or member as recorded in the audited record at the time of the audit event. Preserved in the audit trail to reflect patient identity preferences and support accurate record matching during compliance and quality reviews.

PreviousPage 7 of 82Next