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

document statedoc_st

The workflow status of a clinical document within the healthcare system, such as draft, pending, authenticated, or amended. Tracks the document's progression through authoring, review, and approval stages in EHR and HIS platforms to ensure proper clinical documentation governance.

document statusdoc_sts

The current state of a clinical document within an EHR or health information system, such as draft, finalized, amended, or cancelled. Used by data engineers to filter active versus inactive records in ETL pipelines and ensure only authoritative document versions are included in clinical analytics and reporting datasets.

document strengthdoc_str

The recorded drug concentration or potency associated with a medication-related clinical document, such as a prescription or medication administration record. Captures the active ingredient amount per unit dose, expressed in standard pharmaceutical units like mg, mcg, or mEq.

document subtotaldoc_subtot

An intermediate sum within a clinical document prior to final totaling, used in billing records, itemized statements, or cost summaries. Represents a partial aggregate of charges, units, or services before additional adjustments, taxes, or fees are applied to produce a final document total.

document surgery datedoc_surg_dt

The calendar date on which an operative or surgical procedure was performed, as recorded within a clinical document such as an operative report or surgical consent form. Used to sequence surgical events within a patient's care timeline and support perioperative documentation compliance.

document targetdoc_tgt

The intended destination system, provider, or patient record to which a clinical document is directed within EHR and health information exchange workflows. Used in interoperability pipelines to route clinical documents such as referrals, discharge summaries, or care plans to the appropriate receiving system or care team member.

document taxonomy codedoc_tax_cd

The NUCC Health Care Provider Taxonomy code associated with a clinical document, identifying the specialty or provider type responsible for the document's content. Used in claims processing and clinical data exchange to classify the care context and support appropriate reimbursement routing.

document temperaturedoc_temp

A recorded body temperature measurement captured within a clinical document such as a nursing assessment, vital signs record, or emergency triage note. Expressed in Fahrenheit or Celsius and used to track physiological status, monitor febrile conditions, and support clinical decision-making.

document termination datedoc_term_dt

The date on which a clinical document's effective period ends or the document is officially closed, retired, or superseded. Used in EHR document lifecycle management to indicate expiration of orders, care plans, or authorizations and to maintain accurate historical records.

document timedoc_tm

The time-of-day component (HH:MM:SS) recorded for a clinical documentation entry in EHR systems such as Epic or Cerner. Used by data engineers to sequence clinical events, resolve duplicate records, and support audit trail requirements in HL7 and FHIR data pipelines.

document timestampdoc_ts

The combined date and time value (DATETIME or TIMESTAMP data type) captured when a clinical record is authored or finalized in EHR systems. Critical for event ordering, SLA tracking, and reconciling documentation across Epic, Cerner, and downstream clinical data warehouses.

document titledoc_ttl

The official name or heading assigned to a clinical document, such as 'Discharge Summary,' 'History and Physical,' or 'Radiology Report.' Used in EHR and HIS systems to classify, index, and retrieve documents, and to support standardized document naming conventions like HL7 LOINC coding.

document totaldoc_tot

The aggregated sum value associated with a clinical information record, such as total units administered or total line items within a clinical document in EHR or claims systems. Used by data engineers to validate record completeness and support financial reconciliation workflows.

document total countdoc_tot_cnt

The aggregated number of items, entries, or instances recorded within or associated with a clinical document. Used in clinical data warehouses and reporting systems to quantify document volume metrics, such as total diagnoses coded, procedures listed, or medications referenced within an encounter record.

document typedoc_typ

The categorical classification identifying the nature of a clinical record, such as discharge summary, progress note, operative report, or referral letter, within EHR systems like Epic or Cerner. Used in data pipelines to route, filter, and apply NLP processing rules to clinical documentation.

document updated datedoc_upd_dt

The most recent date on which a clinical document was modified, amended, or addended after initial creation. Used in EHR audit logs and data governance processes to track document revision history, ensure content accuracy, and support compliance with medical records retention standards.

document urgencydoc_urg

The priority or time-sensitivity classification assigned to a clinical document, indicating how quickly it must be completed, reviewed, or acted upon. Common values include routine, urgent, and stat. Used in clinical workflow management to drive task prioritization for documentation completion and clinician review.

document versiondoc_ver

The sequential revision number assigned to a clinical document each time it is updated, amended, or corrected. Used in EHR version control systems to distinguish between iterations of the same document, preserve prior content for audit purposes, and ensure clinicians are referencing the most current information.

document zipdoc_zip

The five- or nine-digit US postal code associated with the location recorded within a clinical document, such as a patient's residence, service facility, or mailing address. Used in healthcare data systems to support geographic analysis, care coordination, and population health reporting by region.

dosage account numberdos_acct_nbr

A unique identifier linking a medication dosage record to a specific patient account or billing encounter within a pharmacy or clinical system. Used in pharmacy management and claims processing to associate dispensed medication quantities with the correct financial account for adjudication and reconciliation.

PreviousPage 198 of 806Next