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

chart statechrt_st

Indicates the processing or workflow state of a patient medical record at a given point in its lifecycle, such as draft, pending review, complete, or archived. Used to manage chart progression through clinical documentation workflows and quality review stages in EHR systems.

chart statuschrt_sts

Captures the current operational condition of a patient medical record, such as active, incomplete, closed, or suspended. Drives workflow routing, clinician alerts, and compliance tracking in EHR systems to ensure documentation is completed accurately and within required timeframes.

chart strengthchrt_str

Records the concentration or dosage strength of a medication as documented within a patient medical record or medication administration chart. Used in clinical documentation to ensure accurate medication reconciliation, dosing verification, and pharmacy coordination across care settings.

chart subtotalchrt_subtot

A partial aggregated value calculated across a subset of line items or entries within a patient medical record, such as subtotaled charges, observations, or procedure counts. Used in clinical and billing workflows to support itemized summaries before final chart totals are computed.

chart surgery datechrt_surg_dt

The calendar date on which a surgical procedure documented within a patient medical record was performed. Critical for operative documentation, post-surgical care planning, quality reporting, and tracking outcomes relative to procedure timing in clinical data systems.

chart targetchrt_tgt

Identifies the intended destination, goal, or reference point associated with a patient medical record entry, such as a target clinical value, care goal, or routing destination within a clinical workflow. Supports care coordination and outcome measurement in EHR environments.

chart taxonomy codechrt_tax_cd

A standardized classification code, such as a NUCC taxonomy code, assigned within a patient medical record to identify the clinical specialty or provider type associated with the documented care. Supports care categorization, specialty routing, and reporting in clinical data systems.

chart temperaturechrt_temp

The recorded body temperature of a patient as documented in a medical record or clinical chart, typically measured in Fahrenheit or Celsius. Used as a vital sign to monitor patient health status, detect fever or hypothermia, and track clinical trends across care encounters.

chart termination datechrt_term_dt

The calendar date on which a patient medical record or chart documentation period is officially closed or deactivated. Marks the end of an active chart episode, supporting records management, audit trail maintenance, and longitudinal care analysis in clinical data systems.

chart timechrt_tm

The specific time of day associated with a clinical event, observation, or documentation entry recorded in a patient medical record. Enables precise temporal sequencing of care activities, medication administration, and clinical observations within a patient encounter or episode of care.

chart timestampchrt_ts

The combined date and time value recorded when a clinical entry is created, modified, or finalized within a patient medical record. Provides an auditable point-in-time reference for documentation accuracy, regulatory compliance, and chronological sequencing of patient care events.

chart titlechrt_ttl

The formal name or heading assigned to a patient medical record, document section, or clinical note within an EHR system. Identifies the nature and purpose of the documentation, such as discharge summary, progress note, or operative report, supporting retrieval and clinical workflow management.

chart totalchrt_tot

The cumulative aggregated value across all entries or line items within a patient medical record segment, such as total charges, total medications, or total observations recorded. Used in clinical and administrative reporting to summarize care activity or financial data for a chart episode.

chart total countchrt_tot_cnt

The total number of discrete entries, occurrences, or records documented within a patient medical record or chart segment. Used in clinical data analytics and reporting to measure documentation volume, encounter frequency, or the number of clinical events captured over a defined period.

chart typechrt_typ

Classifies a patient medical record by its documentation category, such as inpatient, outpatient, emergency, surgical, or behavioral health chart. Determines applicable documentation requirements, workflow routing, and reporting standards applied to the record in clinical and administrative systems.

chart updated datechrt_upd_dt

The calendar date on which a patient medical record was most recently modified, amended, or supplemented. Used to track documentation currency, support audit trails, identify records requiring review, and ensure clinical data integrity across EHR and clinical data warehouse environments.

chart urgencychrt_urg

Indicates the time-sensitivity or clinical priority level assigned to a patient medical record or documentation task, such as routine, urgent, or emergent. Drives workflow prioritization, clinician notification, and response time expectations within clinical documentation and care coordination systems.

chart versionchrt_ver

Identifies the iteration number of a patient medical record or clinical document, incrementing each time the record is amended or updated. Supports audit trail management, version control, and retrieval of prior documentation states to maintain an accurate history of clinical record changes.

chart zipchrt_zip

The postal ZIP code associated with a patient medical record, typically reflecting the practice or facility location where the chart was created. Used in clinical data warehouses to support geographic analysis, regional reporting, and patient population segmentation across care settings.

chemistry active indicatorchem_actv_ind

A binary flag indicating whether a laboratory chemistry test, panel, or result record is currently active within the clinical system. Used in lab information systems to filter valid chemistry records from discontinued, voided, or historical entries during result retrieval and clinical reporting workflows.

PreviousPage 92 of 806Next