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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

charge valuechrg_val

The specific monetary or numeric data point associated with a charge record in healthcare billing systems, representing the billed amount, allowed amount, or calculated fee for a service. Used in EHR, claims, and revenue cycle analytics platforms to support financial reporting, variance analysis, and payer contract performance evaluation.

charge versionchrg_ver

The sequential version number assigned to a charge record to track its lifecycle through creation, modification, and finalization in the revenue cycle system. Enables auditability of charge changes over time, supporting compliance reviews and dispute resolution in clinical billing environments.

charge zipchrg_zip

The postal ZIP code associated with the location where a healthcare service charge was incurred. Used in claims processing and revenue cycle management to route billing, validate service area, and support geographic analysis of charges across facilities.

charity care amountchrty_care_wrtoff_amt

The dollar amount of healthcare services provided to patients who qualify for charity care under a facility financial assistance policy, written off at cost rather than charged amounts. Charity care amounts are reported in IRS Form 990 Schedule H community benefit reporting and are a key component of hospital tax-exempt status justification and state uncompensated care pool calculations.

chart addresschrt_addr

The full mailing or physical address recorded on a patient's medical chart, typically reflecting the patient's residence or contact location at the time of documentation. Used in care coordination, correspondence, and demographic verification within clinical records management.

chart approval statuschrt_appr_sts

Indicates the current review and sign-off state of a patient medical chart, such as pending, approved, or rejected. Used in clinical documentation workflows to enforce completion requirements, support compliance audits, and ensure provider attestation before chart finalization or billing.

chart charge amountchrt_chrg_amt

The gross billed dollar amount associated with services documented on a patient's medical chart. Captured during charge entry in the revenue cycle to reflect the cost of clinical encounters before contractual adjustments, insurance payments, or patient liability calculations are applied.

chart effective datechrt_eff_dt

The date on which the clinical information recorded in a patient's medical chart becomes active or applicable. Used in longitudinal patient records to establish the valid start date for documented diagnoses, treatments, or care plans within a given episode of care.

chart medical record numberchrt_mrn

The unique patient identifier assigned by a healthcare facility and linked to a specific medical chart. Serves as the primary key for locating, matching, and tracking all clinical documentation associated with a patient across departments, visits, and care settings within the facility.

chart scheduled datechrt_sched_dt

The calendar date on which a patient encounter, procedure, or clinical review associated with a medical chart is scheduled to occur. Used in appointment management and clinical operations to coordinate care delivery, staff resources, and pre-visit documentation preparation.

chart scheduled timechrt_sched_tm

The specific time of day at which a patient encounter or clinical activity associated with a medical chart is planned to begin. Used alongside the scheduled date in appointment scheduling systems to manage clinical workflow, reduce patient wait times, and optimize provider capacity.

chart street addresschrt_st_addr

The street-level component of the address recorded on a patient's medical chart, including house number and street name. Used in patient demographic records to support mailing, care coordination, eligibility verification, and geographic population health reporting.

chart unitchrt_unt

The clinical unit, ward, or department within a facility to which a patient's medical chart is assigned or associated during a care episode. Used in hospital information systems to route documentation, assign clinical staff accountability, and support unit-level reporting and quality monitoring.

checksumchksum

A computed hash value used to detect changes in a healthcare data record between source system extracts. Compared against the stored checksum to identify updated records without scanning all columns. Used in Data Vault satellite tables and CDC-based ETL pipelines to efficiently track record changes.

chemistry addresschem_addr

The mailing or physical address associated with a patient or ordering entity linked to a clinical chemistry laboratory order or result. Used in lab information systems to direct specimen collection logistics, result reporting, and correspondence related to chemistry panel workflows.

chemistry approval statuschem_appr_sts

Indicates the review and authorization state of a clinical chemistry test order or result, such as pending review, verified, or rejected. Used in laboratory information systems to enforce result validation protocols, support clinician sign-off, and ensure quality control before results are released to care teams.

chemistry charge amountchem_chrg_amt

The billed dollar amount for clinical chemistry laboratory tests performed on a patient specimen. Captured in revenue cycle and lab billing systems to reflect the cost of chemical analyses such as metabolic panels, lipid profiles, or enzyme assays prior to payer adjudication or patient billing.

chemistry effective datechem_eff_dt

The date on which a clinical chemistry test order, result, or associated record becomes active and clinically applicable. Used in laboratory information systems to establish the valid start date for chemistry data, supporting longitudinal trending of lab values across patient encounters.

chemistry group numberchem_grp_nbr

An identifier that groups related clinical chemistry tests or orders together within a laboratory information system. Used to associate panels such as comprehensive metabolic panels or arterial blood gas sets, enabling batch processing, result reporting, and charge capture for grouped chemistry analyses.

chemistry medical record numberchem_mrn

The unique patient medical record number linked to a clinical chemistry laboratory order or result. Serves as the key identifier for associating chemistry test data with the correct patient record, ensuring accurate result routing, longitudinal lab history, and charge attribution in laboratory systems.

PreviousPage 61 of 325Next