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 codedoc_cd

A standardized coded value assigned to a clinical or administrative document record, often mapped to code systems such as LOINC, CPT, or proprietary payer classifications. Used in EHR, claims, and HIE systems to enable consistent document identification, automated processing, and cross-system interoperability in document exchange workflows.

document commentdoc_cmt

An unstructured free-text notation appended to a clinical or administrative document record to provide supplementary context or clarification. Used in EHR, claims, and document management systems to capture reviewer notes, coding flags, or workflow annotations, stored in text fields and supporting audit trail and quality review processes.

document completed datedoc_cmpl_dt

The date on which a clinical document was finalized and marked complete within the health information system. Used to track documentation turnaround times, support compliance auditing, and measure clinical workflow efficiency across departments or care settings.

document confidential indicatordoc_conf_ind

A flag indicating whether a clinical document contains sensitive or restricted content requiring elevated privacy protections, such as behavioral health, substance use, or HIV-related records. Controls access permissions and governs disclosure rules under applicable regulations including 42 CFR Part 2.

document contactdoc_cntct

The designated communication reference point, such as a provider, facility, or responsible party, associated with a clinical or administrative document record. Used in EHR and healthcare data systems to route correspondence, support follow-up workflows, and link document records to accountable entities within provider and member management platforms.

document countdoc_cnt

The total number of document records associated with a patient encounter, claim, or administrative workflow within a healthcare data system. Used in EHR, claims, and document management platforms as a quantitative metric for volume tracking, completeness validation, audit reporting, and workload distribution across document processing pipelines.

document countrydoc_ctry

The country associated with a clinical document record, typically reflecting the nation of the authoring facility, patient address, or service location. Supports international patient data management, cross-border care coordination, and geographic classification in health information systems.

document created bydoc_crtd_by

The unique identifier of the user or system account responsible for initiating and saving a clinical document record. Used in audit trails, accountability tracking, and workflow management to establish authorship and support compliance reviews within health information systems.

document created datedoc_crtd_dt

The timestamp recording when a clinical document was first generated in EHR or document management systems such as Epic or Cerner. Used by data engineers to establish document lineage, audit trails, and chronological ordering of clinical records in data pipelines.

document created timedoc_crtd_tm

The precise timestamp recording when a clinical document was first created and saved in the health information system. Used to establish the document origination point, support audit logging, measure documentation lag time, and sequence records in clinical workflows.

document creatininedoc_cr

The creatinine laboratory value recorded within a clinical document, used as a key biomarker for assessing renal function. Captured in clinical documentation to support medication dosing decisions, chronic kidney disease staging, and monitoring of patients with conditions affecting kidney health.

document datedoc_dt

The calendar date associated with a clinical document in EHR, claims, or health information management systems. Represents the official service or authorship date, distinct from system entry date, and is critical for clinical timeline analysis and claims adjudication workflows.

document datetimedoc_dttm

The combined date and time value stamped on a clinical document within EHR or health information systems such as Epic or Meditech. Enables precise chronological sequencing of clinical events, supporting data engineers in building accurate patient encounter timelines and audit logs.

document dea numberdoc_dea_nbr

The Drug Enforcement Administration registration number associated with a clinical document, typically identifying the prescribing clinician authorized to prescribe controlled substances. Used in controlled substance documentation, prescription verification, and regulatory compliance reporting within clinical systems.

document death datedoc_death_dt

The recorded date of patient death as captured within a clinical document in EHR or vital records systems. Used by data engineers to reconcile mortality data across member enrollment, claims, and clinical datasets for population health analytics and eligibility termination workflows.

document deleted datedoc_del_dt

The date on which a clinical document record was marked as deleted within the health information system. Used to maintain a soft-delete audit trail, support data retention compliance, and enable recovery or forensic review of removed documentation without permanent data loss.

document deleted indicatordoc_del_ind

A flag denoting whether a clinical document has been logically deleted from the active record set within the health information system. Enables soft-delete functionality so records are retained for audit and compliance purposes while being excluded from standard clinical views and reporting.

document descriptiondoc_desc

The free-text or structured narrative field describing the content and purpose of a clinical document in EHR or health information management systems. Used by data engineers to classify, filter, and route documents during ingestion pipelines and document management integration workflows.

document detaildoc_dtl

Granular clinical or administrative information contained within a specific document record in EHR, claims, or pharmacy systems. Data engineers reference this field to extract structured data elements from unstructured or semi-structured clinical documents during ETL and normalization processes.

document discharge datedoc_dsch_dt

The date on which a patient was formally released from an inpatient facility, as recorded in a clinical document within EHR or claims systems. Critical for calculating length of stay, triggering post-discharge workflows, and aligning institutional claims with UB-04 billing records.

PreviousPage 193 of 806Next