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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

validation active statusvalid_actv_sts

The current operational state of a data validation process or rule set, indicating whether it is enabled, disabled, or suspended within a healthcare data pipeline. Supports data governance teams in managing rule lifecycles across claims, enrollment, and clinical data systems.

validation admission datevalid_admn_dt

The inpatient admission date submitted on a claim or encounter record that has undergone a data validation check to confirm accuracy, format compliance, and logical consistency against discharge date and service dates during claims adjudication or data quality review.

validation assessmentvalid_asmt

The documented outcome or narrative summary of a data validation review process, describing whether submitted healthcare data such as claims fields, member records, or clinical entries meet defined accuracy, completeness, and consistency standards within data quality workflows.

validation discharge datevalid_dsch_dt

The inpatient or observation discharge date on a claim or encounter record that has been subjected to data validation checks, confirming the date is logically consistent with admission date, service dates, and billing codes during claims processing or data quality audits.

validation durationvalid_dur

The total elapsed time from initiation to completion of a data validation process applied to healthcare records such as claims, enrollment files, or clinical data submissions, used to monitor data pipeline performance and identify bottlenecks in quality assurance workflows.

validation emergency indicatorvalid_emerg_ind

Flags whether a clinical data validation record is associated with an emergency encounter. Used in claims and clinical data quality workflows to distinguish urgent-care validations from routine ones, ensuring emergency records receive priority review and appropriate processing.

validation history present illnessvalid_hpi

Stores the narrative description of a patient's presenting condition as captured during a clinical data validation process. Used to verify that the history of present illness documented in a claim or clinical record accurately reflects the encounter details submitted for review.

validation instructionvalid_instr

Contains the specific guidance text governing how a clinical or claims data element should be validated. These instructions define business rules, acceptable formats, and review steps that data quality teams or automated systems must follow when performing accuracy verification checks.

validation labelvalid_lbl

The human-readable display text assigned to a specific validation rule or check within a clinical data quality or claims processing system. Used to identify and distinguish individual validation definitions in reporting dashboards, audit logs, and data governance documentation.

validation notevalid_nt

Free-text annotation recorded during or after a data validation review in clinical or claims processing systems. Captures reviewer observations, exception explanations, or follow-up actions needed when a data element fails or requires clarification during accuracy verification workflows.

validation procedure datevalid_proc_dt

Records the date on which a clinical or surgical procedure was performed, as captured and verified during a data validation process. Used in claims auditing and clinical data quality reviews to confirm that procedure dates align with encounter records, authorization periods, and billing submissions.

validation rangevalid_rng

Defines the acceptable minimum and maximum boundary values used to validate a clinical or claims data element. Applied in data quality checks to flag out-of-range results, such as implausible lab values, dosage amounts, or reimbursement figures that fall outside clinically or administratively defined thresholds.

validation resultvalid_rslt

Records the outcome of a data accuracy verification check applied to a clinical or claims data element. Indicates whether the reviewed record passed, failed, or requires further review, and is used in data quality reporting to track validation rates and remediation efforts across processing workflows.

validation routevalid_rte

Captures the medication administration pathway, such as oral, intravenous, or topical, as verified during a pharmacy or clinical data validation process. Used to confirm that the route documented in a prescription, claim, or clinical record is clinically appropriate and consistent with the prescribed treatment.

validation strengthvalid_str

Records the drug concentration or dosage strength of a medication as verified during pharmacy data validation. Used in pharmacy claims auditing and clinical data quality checks to confirm that the dispensed or prescribed strength matches the authorized order and formulary requirements.

validation surgery datevalid_surg_dt

Records the date of a surgical procedure as verified during a clinical or claims data validation review. Used in utilization management and claims auditing to confirm that operative dates documented on claims align with authorization records, operative reports, and facility encounter data.

value admission dateval_admn_dt

The date a patient was admitted to an inpatient facility, stored as a discrete data value in clinical or claims records. Used in inpatient claims processing, length-of-stay calculations, and utilization reporting to establish the start of an inpatient episode for billing and clinical analysis.

value discharge dateval_dsch_dt

The date a patient was released from an inpatient facility, stored as a discrete data value in clinical or claims records. Used in inpatient claims adjudication, length-of-stay reporting, and post-acute care coordination to mark the end of a facility-based episode of care.

value emergency indicatorval_emerg_ind

A discrete flag value indicating whether an encounter or claim record is associated with emergency care services. Used in claims adjudication and utilization reporting to apply appropriate benefit rules, reimbursement rates, and regulatory requirements specific to emergency department or urgent care visits.

value history present illnessval_hpi

The discrete stored text representing a patient's history of present illness narrative within a clinical or claims data record. Used in clinical documentation quality reviews and medical necessity determinations to assess whether the documented condition narrative supports the diagnoses and services reported on a claim.

PreviousPage 780 of 806Next