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

diagnosis active statusdiag_actv_sts

A categorical status field indicating the current activity state of a patient diagnosis, such as active, inactive, resolved, or chronic. Used in longitudinal care management, problem list maintenance, and population health reporting to reflect clinical relevance over time.

diagnosis addressdiag_addr

The physical location associated with where a diagnosis was rendered or recorded, such as a clinic or hospital address. Used in EHR and claims systems to support provider network validation, geographic analysis of disease prevalence, and audit workflows that require linking diagnoses to specific care delivery sites.

diagnosis adjustment amountdiag_adj_amt

The monetary adjustment applied to a diagnosis-related charge or claim, representing contractual write-offs, payer discounts, or correction amounts. Used in revenue cycle management to reconcile billed charges with actual reimbursement on diagnosis-linked encounters.

diagnosis admission datediag_admn_dt

The date a patient was admitted to a facility in relation to a specific diagnosis, used to establish inpatient encounter timelines. Captured in EHR and claims systems to support length-of-stay calculations, DRG assignment, readmission analysis, and coordination of benefits logic in healthcare data pipelines.

diagnosis agediag_age

The patient's age in years at the time a diagnosis was recorded or confirmed. Used in clinical analytics, risk stratification, age-appropriate care guidelines, and epidemiological reporting to contextualize diagnoses within patient demographic data.

diagnosis allowed amountdiag_alwd_amt

The maximum dollar amount a payer will reimburse for services associated with a specific diagnosis, as defined by the payer's fee schedule or contract terms. Used in claims adjudication, remittance processing, and patient cost-sharing calculations.

diagnosis amountdiag_amt

The monetary value associated with a diagnosis within a member or claims process, representing allowed, billed, or paid amounts tied to a specific condition. Used in claims adjudication, EHR charge capture, and healthcare analytics platforms to support cost-of-care reporting, risk stratification, and financial reconciliation workflows.

diagnosis approval statusdiag_appr_sts

The current authorization or review state of a diagnosis record, indicating whether it has been approved, pending review, or rejected by a clinician or coding reviewer. Used in clinical documentation integrity workflows and diagnosis validation processes.

diagnosis approved bydiag_appr_by

The name or identifier of the clinician, coder, or authorized user who reviewed and approved a diagnosis record. Used in clinical documentation integrity, audit trails, and quality review workflows to attribute accountability for confirmed diagnostic entries.

diagnosis arrival timediag_arrv_tm

The recorded time at which a patient arrived at a care setting during an encounter associated with a specific diagnosis. Used in emergency department throughput analysis, triage workflows, and time-to-treatment reporting for diagnosis-related quality metrics.

diagnosis arrived datediag_arrv_dt

The calendar date on which a patient arrived at a care facility for an encounter linked to a specific diagnosis. Used in encounter management, length-of-stay calculations, and care coordination timelines for diagnosis-associated inpatient or outpatient visits.

diagnosis assessmentdiag_asmt

The clinician's narrative or structured evaluation documenting the clinical reasoning and findings supporting a recorded diagnosis. Captures the subjective and objective basis for the diagnostic conclusion within the patient's clinical encounter documentation.

diagnosis averagediag_avg

The mean value calculated across a set of diagnosis-related metrics, such as average cost, frequency, or severity score for a given condition within a population. Used in healthcare analytics, claims reporting, and EHR data warehouses to benchmark clinical performance, identify cost trends, and support actuarial and quality improvement analyses.

diagnosis balancediag_bal

The outstanding financial amount remaining after payments and adjustments have been applied to a diagnosis-linked claim or encounter. Used in healthcare billing, claims adjudication, and EHR revenue cycle systems to track patient responsibility, coordinate benefits, and reconcile accounts receivable in payer and provider data platforms.

diagnosis billed amountdiag_bill_amt

The total dollar amount invoiced to a payer or patient for services associated with a specific diagnosis on a claim. Represents the provider's full charge before contractual adjustments, payer allowances, or patient cost-sharing amounts are applied.

diagnosis birth datediag_birth_dt

The patient date of birth recorded in association with a specific diagnosis record, used to validate member identity and calculate age at time of diagnosis. Critical in EHR, claims, and enrollment systems for age-based eligibility rules, pediatric versus adult condition classification, and longitudinal patient data matching across data sources.

diagnosis blood pressurediag_bp

The systolic and diastolic blood pressure reading recorded during an encounter associated with a specific diagnosis. Used as a clinical vital sign to support diagnostic assessment, chronic disease management, and hypertension-related condition monitoring in patient records.

diagnosis cancelled datediag_cncl_dt

The calendar date on which a previously recorded diagnosis was formally cancelled or removed from the patient's record, indicating it was entered in error or determined to be clinically invalid. Used in audit trails and clinical documentation correction workflows.

diagnosis categorydiag_cat

Categorization label for diagnosis within Provider processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

diagnosis charge amountdiag_chrg_amt

The total billed charge associated with a specific diagnosis on a medical claim. Represents the provider's submitted amount before insurance adjustments, used in claims adjudication to determine allowed amounts, patient cost-sharing responsibilities, and reimbursement calculations.

PreviousPage 160 of 806Next