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

charge surgery datechrg_surg_dt

The calendar date on which a surgical procedure was performed, triggering associated operative charges. Used in charge capture and revenue cycle systems to link surgical billing records to the correct encounter date for claim submission, coding, and audit reconciliation.

chart active indicatorchrt_actv_ind

A binary flag indicating whether a patient medical record chart is currently active and accessible within the health information system. Used to distinguish open, in-use charts from closed, archived, or purged records during patient care, audits, and data retrieval operations.

chart active statuschrt_actv_sts

A categorical value describing the current operational state of a patient medical record chart, such as active, inactive, suspended, or archived. Used in health information management to control chart access, enforce retention policies, and support regulatory compliance reporting.

chart admission datechrt_admn_dt

The calendar date on which a patient was formally admitted to a facility, as recorded in the medical record chart. Used in inpatient documentation to establish the start of an episode of care, calculate length of stay, and support accurate UB-04 claim billing and discharge reporting.

chart agechrt_age

The patient's age in years at the time of a clinical encounter or as recorded within the medical record chart. Used in clinical documentation and analytics to support age-based clinical decision rules, risk stratification, pediatric dosing calculations, and population health reporting.

chart allowed amountchrt_alwd_amt

The maximum reimbursable dollar amount contractually permitted for services documented within a patient's medical record chart encounter. Used in revenue cycle reconciliation to compare billed charges against payer-approved amounts and calculate patient responsibility and write-off values.

chart amountchrt_amt

The total monetary value associated with charges documented within a patient medical record chart for a given encounter or episode of care. Used in revenue cycle and financial reporting to aggregate service-level costs and support billing reconciliation across payer and self-pay accounts.

chart approved bychrt_appr_by

The name or system identifier of the clinician or administrator who reviewed and authorized a patient medical record chart entry. Used in health information management to maintain documentation accountability, support compliance audits, and enforce signature requirements under regulatory standards.

chart arrival timechrt_arrv_tm

The recorded clock time at which a patient physically arrived at a care facility during an encounter documented in the medical record chart. Used in operational analytics, throughput reporting, and emergency department benchmarking to measure patient flow and wait time performance.

chart arrived datechrt_arrv_dt

The calendar date on which a patient arrived at a care facility for an encounter recorded in the medical record chart. Used in clinical documentation and operational reporting to establish encounter timelines, calculate visit duration, and support scheduling and capacity management analysis.

chart assessmentchrt_asmt

The clinician's documented clinical evaluation and diagnostic conclusions recorded within the patient medical record chart, typically as part of a SOAP note. Used to communicate the provider's interpretation of presenting symptoms, examination findings, and working diagnoses for treatment planning and continuity of care.

chart balancechrt_bal

The remaining unpaid dollar amount on a patient medical record account after applying all insurance payments, adjustments, and prior patient payments. Used in revenue cycle management to track outstanding patient financial liability and prioritize collection activity across billing cycles.

chart billed amountchrt_bill_amt

The total gross charges submitted to a payer or patient for services documented within a medical record chart encounter. Used in revenue cycle reporting to represent the initial invoice value before contractual adjustments, denials, or payments are applied during claims adjudication.

chart birth datechrt_birth_dt

The patient's date of birth as recorded in the medical record chart, used to verify patient identity, calculate age at time of service, and support demographic reporting. Critical for matching records across systems, fulfilling payer eligibility requirements, and ensuring accurate pediatric and geriatric care documentation.

chart blood pressurechrt_bp

The recorded systolic and diastolic arterial blood pressure measurement documented in a patient's medical record chart during a clinical encounter. Used in vital signs tracking, chronic disease management, risk assessment, and quality measure reporting for conditions such as hypertension and cardiovascular disease.

chart cancelled datechrt_cncl_dt

The calendar date on which a scheduled encounter, order, or chart activity was formally cancelled and recorded in the patient's medical record. Used in scheduling analytics, no-show reporting, and utilization management to track appointment cancellations and their impact on care continuity and resource planning.

chart categorychrt_cat

A classification label assigned to a patient medical record chart to indicate the encounter type, service line, or documentation category, such as inpatient, outpatient, or emergency. Used in health information management to organize records, apply retention schedules, and support reporting by care setting.

chart chief complaintchrt_cc

The patient's primary presenting symptom or reason for seeking care, as documented by the clinician at the start of a medical record chart encounter. Used in clinical documentation to guide the exam, establish medical necessity, support diagnosis coding, and meet evaluation and management documentation requirements.

chart childchrt_chld

Identifies a subordinate or nested medical record within a parent-child chart hierarchy in EHR systems. Used to link dependent documentation such as sub-encounters, follow-up notes, or ancillary records to a primary chart, enabling structured clinical data organization.

chart citychrt_city

The municipality or city name associated with the address recorded on a patient medical chart. Used in clinical and administrative workflows to capture geographic location details for patient demographics, correspondence, and care coordination across healthcare information systems.

PreviousPage 86 of 806Next