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

vital commentvtl_cmt

Contains free-text clinician notes or annotations associated with a vital sign observation in EHR documentation systems. Data engineers must handle this unstructured field carefully during ETL processing, applying NLP techniques or exclusion logic to prevent interference with structured clinical analytics pipelines.

vital completed datevtl_cmpl_dt

The calendar date on which a vital signs assessment or associated clinical encounter was fully completed and documented. Used in clinical workflow management to confirm that all required measurements were captured, reviewed, and finalized in the patient's health record.

vital confidential indicatorvtl_conf_ind

A flag designating that a vital signs record or associated encounter contains sensitive information requiring restricted access controls. Supports HIPAA privacy compliance by limiting visibility of certain clinical observations, such as those related to behavioral health or substance use treatment encounters.

vital contactvtl_cntct

Stores the contact information associated with a vital signs record, such as the ordering provider or responsible clinical staff, within EHR and care coordination systems. Data engineers use this field to establish provider attribution linkages and support accountability reporting in clinical data warehouses.

vital copay amountvtl_cpay_amt

The fixed out-of-pocket dollar amount a patient is required to pay at the time of a clinical encounter where vital signs are collected and documented. Determined by the patient's health plan benefit design and applied per visit as part of the cost-sharing structure during claims adjudication.

vital costvtl_cst

The total expense incurred by a healthcare organization for delivering vital sign monitoring services during a clinical encounter. Used in cost accounting and financial analytics to assess resource utilization, support budgeting decisions, and evaluate the cost-effectiveness of clinical monitoring workflows.

vital countvtl_cnt

Represents the total number of vital sign observations recorded within a defined period or encounter in EHR and clinical analytics systems. Data engineers use this metric to assess documentation frequency, detect gaps in monitoring compliance, and support patient acuity scoring models in population health platforms.

vital countryvtl_ctry

The name or code of the country associated with the location where vital signs were collected, or the patient's country of residence as recorded at the time of the encounter. Used in international health data reporting, population health analytics, and cross-border care coordination workflows.

vital created byvtl_crtd_by

The unique identifier of the clinical user or system that initially created the vital signs record in the EHR or clinical data system. Supports audit trail requirements by documenting data entry accountability and enabling review of who originated the patient's physiological measurement documentation.

vital created datevtl_crtd_dt

Captures the timestamp when a vital signs record was first created in the EHR or clinical data system. Data engineers use this field to establish record provenance, support audit trail requirements, and differentiate between documentation time and actual observation time in clinical data warehouse ingestion pipelines.

vital created timevtl_crtd_tm

The precise timestamp at which a vital signs record was first entered or generated in the clinical data system. Used for audit trail purposes, workflow sequencing, and data integrity validation to distinguish the time of record creation from the actual time vital sign measurements were clinically observed.

vital creatininevtl_cr

Serum or plasma creatinine value recorded as part of a patient vital signs or lab panel encounter. Used to assess kidney filtration function, monitor chronic kidney disease progression, and calculate eGFR in clinical data systems and EHR flowsheets.

vital datevtl_dt

Records the calendar date on which a vital sign measurement was taken or documented in EHR and clinical systems. Data engineers rely on this field for time-series analysis, encounter alignment, trend reporting, and ensuring chronological accuracy when joining vitals data to claims or pharmacy records.

vital datetimevtl_dttm

Stores the combined date and timestamp of a vital sign observation in EHR and clinical data systems. Data engineers use this precise temporal value for event sequencing, ICU monitoring analytics, intraoperative data correlation, and resolving same-day duplicate records during clinical data warehouse ingestion.

vital dea numbervtl_dea_nbr

Drug Enforcement Administration registration number associated with a clinician authorized to prescribe controlled substances during a vital signs or clinical encounter. Links prescribing authority to the specific encounter record in clinical and pharmacy data systems.

vital death datevtl_death_dt

Records the date of patient death as associated with or documented alongside a vital signs record in EHR and member enrollment systems. Data engineers use this field to flag deceased patients in population cohorts, terminate active records in longitudinal datasets, and support mortality outcome analyses.

vital deductible amountvtl_ded_amt

Dollar amount applied toward a patient deductible for services associated with a vital signs or clinical encounter. Captures cost-sharing liability relevant to the encounter in claims adjudication and healthcare financial reporting systems.

vital deleted datevtl_del_dt

Calendar date on which a vital signs record was marked as deleted or voided in the clinical data system. Used in data governance and audit tracking to identify when erroneous, duplicate, or retracted vital measurements were removed from active records.

vital deleted indicatorvtl_del_ind

Boolean or coded flag denoting whether a vital signs record has been logically deleted or voided in the clinical data system. Enables downstream reporting and data pipelines to exclude retracted measurements while preserving the full audit history of the encounter.

vital descriptionvtl_desc

Contains the human-readable textual label or explanation for a vital sign observation type, such as Heart Rate or Oxygen Saturation, within EHR and clinical data warehouse systems. Data engineers use this field for display mapping, terminology reconciliation, and validation against standard clinical coding references like LOINC.

PreviousPage 790 of 806Next