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 active indicatordoc_actv_ind

Boolean flag identifying whether a clinical document is currently active and valid for use within the health record. Distinguishes active documents from those that have been superseded, cancelled, or archived, ensuring clinicians and downstream systems reference only current, clinically relevant documentation.

document active statusdoc_actv_sts

Categorical status value describing the current activity state of a clinical document within the health record system. Tracks whether a document is active, inactive, superseded, or archived, supporting document lifecycle management, audit compliance, and accurate retrieval of current clinical information.

document admission datedoc_admn_dt

The date a patient was admitted to a hospital or inpatient facility as recorded within a clinical document record. Used in EHR and claims systems to anchor document context to an encounter timeline, supporting clinical coding, length-of-stay calculations, and retrospective data analysis across inpatient document repositories.

document agedoc_age

Patient age recorded at the time a clinical document was created or the encounter was initiated. Captured in years within clinical documentation to provide demographic context, support age-specific clinical decision rules, and enable population health analysis across document-based datasets.

document allowed amountdoc_alwd_amt

Maximum reimbursable dollar amount associated with a clinical document, representing the contractually permitted payment for services documented. Used in claims and revenue cycle workflows to determine payer liability, calculate patient cost-sharing obligations, and reconcile billed charges against negotiated rates.

document amountdoc_amt

The monetary value associated with a clinical or administrative document record, such as a claim, invoice, or remittance advice. Used in healthcare billing and revenue cycle systems to capture financial figures at the document level, supporting payment reconciliation, audit workflows, and financial reporting across EHR and claims platforms.

document approved bydoc_appr_by

Identifier or name of the authorized user, clinician, or supervisor who reviewed and approved a clinical document for inclusion in the health record. Supports document authentication, regulatory compliance, co-signature workflows, and audit trail requirements within clinical documentation systems.

document arrival timedoc_arrv_tm

Time of day at which a patient physically arrived at a care facility and was registered in association with a clinical document. Used to measure patient flow metrics, calculate door-to-treatment intervals, support triage prioritization, and meet regulatory reporting requirements for emergency and outpatient settings.

document arrived datedoc_arrv_dt

Calendar date on which a patient physically arrived at a care facility and was registered in association with a clinical document. Used to establish encounter timelines, calculate length-of-stay metrics, support triage documentation, and meet regulatory reporting requirements across inpatient and outpatient settings.

document assessmentdoc_asmt

Clinician-authored evaluation text recorded within a clinical document summarizing the patient's condition, diagnosis, and clinical reasoning at a given point of care. Forms the evaluative component of structured clinical notes such as SOAP documentation, supporting care planning and continuity of treatment.

document balancedoc_bal

The outstanding unpaid monetary amount remaining on a clinical or financial document record after partial payments or adjustments are applied. Used in revenue cycle management and claims systems to track accounts receivable status, drive follow-up workflows, and support financial reconciliation reporting across EHR and billing platforms.

document billed amountdoc_bill_amt

Total dollar amount invoiced to a payer or patient for services captured within a clinical document. Represents the gross charge before contractual adjustments, denials, or patient cost-sharing calculations are applied during claims adjudication and revenue cycle management processing.

document birth datedoc_birth_dt

The patient date of birth captured within a clinical or administrative document record, used for identity verification and data linkage in EHR and claims systems. Critical for patient matching algorithms, eligibility validation, and deduplication processes across member enrollment, pharmacy, and clinical document management platforms.

document blood pressuredoc_bp

Systolic and diastolic arterial pressure values recorded within a clinical document as part of vital sign assessment. Measured in millimeters of mercury and used to monitor cardiovascular status, support hypertension management, inform clinical decision-making, and meet documentation standards for encounter records.

document cancelled datedoc_cncl_dt

Calendar date on which a clinical document was formally cancelled, voided, or withdrawn from the active health record. Used to maintain an accurate document lifecycle audit trail, prevent use of invalid clinical records in care decisions, and support compliance with health information management policies.

document categorydoc_cat

A high-level classification grouping assigned to a clinical or administrative document record, such as clinical notes, lab reports, or claims attachments. Used in EHR and document management systems to organize, filter, and route records through clinical and administrative workflows, supporting metadata indexing and downstream reporting pipelines.

document chief complaintdoc_cc

Primary symptom, concern, or reason for the encounter as reported by the patient and recorded within the clinical document. Serves as the initiating clinical context for the visit, guiding diagnostic workup and treatment planning, and is a required element of structured clinical encounter documentation standards.

document childdoc_chld

A subordinate document record linked to a parent document within a hierarchical clinical or administrative document management structure. Used in EHR and healthcare data platforms to represent addenda, attachments, or nested records, enabling relational document traversal, version control, and parent-child lineage tracking across document repositories.

document citydoc_city

The city or municipality associated with a clinical document record, typically capturing the location of the authoring facility, patient address, or service site. Used in clinical data systems to support document routing, geographic reporting, and care coordination workflows.

document classdoc_cls

A classification tier assigned to a clinical or administrative document record that defines its structural type and processing rules within a healthcare data system. Used in EHR, HIE, and claims platforms to enforce document handling logic, schema validation, and routing rules, often aligned with HL7 or LOINC document type standards.

PreviousPage 192 of 806Next