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 start timediag_start_tm

The time at which a diagnosis was first documented or the associated clinical event began within an encounter. Used in inpatient and emergency care records to establish precise onset timing for conditions, supporting clinical documentation, quality metrics, and time-sensitive treatment protocols.

diagnosis statediag_st

The U.S. state or territory associated with where a diagnosis was rendered or where the patient resides at the time of diagnosis. Used in geographic health reporting, state-level disease surveillance, and regulatory compliance tracking across regional health information systems.

diagnosis statusdiag_sts

Coded field indicating the current lifecycle state of a diagnosis record in EHR or member management systems, such as active, resolved, inactive, or ruled out. Used in member health summary pipelines, care management integrations, and clinical data quality reporting to filter relevant conditions for downstream analytics.

diagnosis street addressdiag_st_addr

The street-level address associated with the location where a diagnosis was rendered, such as a clinic, hospital, or outpatient facility. Used in geographic analysis, facility-level reporting, and public health surveillance to map diagnosis locations and support population health planning.

diagnosis strengthdiag_str

The clinical severity or intensity level attributed to a diagnosed condition, or in medication-related diagnoses, the drug concentration associated with treatment. Used in clinical documentation and pharmacy data to contextualize the diagnosed condition within the patient's treatment regimen.

diagnosis subtotaldiag_subtot

A partial aggregated count or cost value representing a subset of diagnoses within a patient encounter, claim, or reporting period. Used in financial and utilization reporting to break down diagnosis-level costs or volumes before applying adjustments or combining with other service categories.

diagnosis surgery datediag_surg_dt

The date on which a surgical procedure directly related to a confirmed diagnosis was performed. Used in clinical and claims data to link operative procedures to their corresponding diagnoses, supporting episode-of-care analysis, surgical outcomes reporting, and inpatient DRG assignment.

diagnosis system identifierdiag_sys_id

A unique system-generated key assigned to a diagnosis record within a healthcare information system or data warehouse. Used to uniquely identify and cross-reference diagnosis entries across clinical, claims, and administrative platforms, enabling consistent data linkage and longitudinal patient record tracking.

diagnosis targetdiag_tgt

Reference identifier linking a diagnosis code to a specific clinical target entity such as a body site, organ system, or treatment goal within EHR and clinical documentation systems. Used by data engineers to support structured clinical data mapping, procedure-to-diagnosis linkage, and interoperability with FHIR-based data pipelines.

diagnosis taxonomy codediag_tax_cd

Classifies a diagnosis record using a standardized coding taxonomy such as ICD-10-CM, SNOMED CT, or a payer-specific scheme. Enables consistent categorization of medical conditions across clinical, claims, and reporting systems to support interoperability, reimbursement accuracy, and population health analytics.

diagnosis temperaturediag_temp

Records the patient's body temperature measurement at the time a diagnosis was established or evaluated. Typically captured in Fahrenheit or Celsius during a clinical encounter, this vital sign supports diagnostic reasoning for conditions such as infections, sepsis, or inflammatory disorders in EHR clinical data.

diagnosis termination datediag_term_dt

Identifies the date on which a diagnosed medical condition was resolved, ruled out, or removed from a patient's active problem list. Used in longitudinal patient records to track condition duration, inform care transitions, and support accurate chronic disease management reporting across clinical systems.

diagnosis timediag_tm

The time-of-day value recorded at the moment a diagnosis was documented or confirmed in an EHR or hospital information system. Used by data engineers in emergency department workflows, inpatient event sequencing, and timestamp reconciliation when building encounter-level analytical datasets.

diagnosis timestampdiag_ts

System-generated datetime value capturing when a diagnosis record was created, updated, or processed within billing or EHR platforms. Used by data engineers for incremental data loads, audit trail construction, change data capture in ETL pipelines, and reconciliation between source systems and data warehouse layers.

diagnosis titlediag_ttl

Contains the formal human-readable name or label assigned to a diagnosed medical condition, such as 'Type 2 Diabetes Mellitus' or 'Essential Hypertension.' Used alongside diagnosis codes in clinical documentation, patient summaries, and reporting systems to ensure clear communication of conditions across care settings.

diagnosis totaldiag_tot

Aggregate count or sum of diagnosis codes or diagnosis-related values associated with a claim, encounter, or member record in claims processing and EHR systems. Used by data engineers to validate claim completeness, enforce diagnosis code limits per payer rules, and generate encounter-level summary metrics in analytics platforms.

diagnosis total countdiag_tot_cnt

Represents the aggregate number of diagnosis records, occurrences, or coded conditions within a defined scope such as an encounter, member record, or reporting period. Used in clinical analytics, quality measure calculation, and claims auditing to assess diagnostic complexity and patient condition burden.

diagnosis typediag_typ

Classification type for diagnosis within Clinical processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

diagnosis unitdiag_unt

The unit of measure associated with a diagnosis-related metric or clinical finding in EHR and clinical data systems, such as days, episodes, or occurrences. Used by data engineers to normalize diagnosis-based measurements across disparate source systems and ensure dimensional consistency in healthcare data warehouses.

diagnosis updated datediag_upd_dt

Captures the most recent date on which a diagnosis record was modified, amended, or clinically reviewed. Supports audit trail integrity, version control of problem lists, and regulatory compliance by providing a timestamp reflecting the latest change to a patient's documented condition in clinical or claims systems.

PreviousPage 167 of 806Next