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 deleted indicatorchrg_del_ind

A flag on a charge record indicating that the charge has been voided, removed, or excluded from active billing and claims processing. Used in revenue cycle systems to logically suppress deleted charges from reporting and claim submission while preserving the record for audit trail and reconciliation purposes.

charge descriptionchrg_desc

The textual label or narrative explaining a billable service or item within a hospital charge master or EHR billing system. Linked to charge codes, this field drives patient-facing billing statements, EOB descriptions, claims documentation, and charge master maintenance in revenue cycle management workflows.

charge description master codecdm_cd

A unique code from a facility charge description master identifying a specific billable item, service, supply, or procedure along with its associated charge amount. The CDM is the authoritative source linking clinical activities to revenue charges in hospital billing systems, and CDM maintenance is critical for charge capture accuracy and compliance with billing regulations.

charge detailchrg_dtl

Granular line-item information associated with a charge record in EHR, hospital billing, or revenue cycle systems, including service type, units, modifiers, and pricing. Used by claims processors, coders, and financial analysts to validate billing accuracy, support adjudication, and drive itemized patient statement generation.

charge due datechrg_due_dt

The date by which payment for a billed service charge is expected from the payer or patient. Used in accounts receivable management to trigger follow-up activities, calculate aging buckets, and measure collection timeliness against contractual or regulatory timely payment requirements.

charge durationchrg_dur

The length of time associated with a billable service as recorded on the charge record, such as minutes of therapy, hours of infusion, or days of rental. Used in revenue cycle processing to calculate time-based billing units, validate quantity billed, and support medical necessity documentation for time-dependent procedures.

charge effective datechrg_eff_dt

The date on which a charge record, charge master rate, or billing rule becomes active within an EHR or hospital billing system. Used in revenue cycle management to apply correct pricing schedules, payer contract rates, and fee schedule updates to claims generated within a specified billing period.

charge emailchrg_eml

Stores the electronic mail address associated with charge-related communications in claims, revenue cycle, or billing systems. Used to route charge dispute notifications, explanation of benefits correspondence, and billing inquiries to the appropriate payer, provider, or member contact within healthcare financial data workflows.

charge end datechrg_end_dt

Captures the date on which a charge record, fee schedule entry, or billing period concludes in claims, revenue cycle, or PBM systems. Used in temporal filtering during ETL processing to distinguish active from expired charge records, supporting accurate fee schedule application and claims adjudication across payer platforms.

charge end timechrg_end_tm

The timestamp marking when a billable service or procedure was completed, used in hospital charge capture systems to establish the precise end boundary of a timed service, supporting accurate billing for time-based CPT codes and anesthesia charges.

charge entered bychrg_ent_by

The user ID or name of the clinical or billing staff member who posted the charge record into the charge capture or hospital billing system, providing an audit trail for charge entry accountability, corrections, and compliance review workflows.

charge ethnicitychrg_ethn

The ethnic identity of the patient associated with a billable charge encounter, captured at the time of service to support demographic reporting, health equity analytics, and federal reporting requirements such as UDS and CMS quality measures.

charge expiration datechrg_exp_dt

Records the date after which a charge amount, fee schedule rate, or billing record is no longer valid in claims, revenue cycle, or provider contract systems. Used in adjudication logic and contract management workflows to ensure expired charge rates are not applied to new claims, maintaining billing accuracy and compliance.

charge external identifierchrg_ext_id

A unique reference number assigned by an external system, such as a practice management platform or third-party billing vendor, used to cross-reference and reconcile charge records across disparate healthcare billing and revenue cycle management systems.

charge faxchrg_fax

The facsimile number associated with the billing entity, department, or ordering party linked to a charge record, used in revenue cycle workflows to route billing correspondence, authorizations, or claim-related documentation during the adjudication process.

charge feechrg_fee

The gross billed amount assigned to a specific healthcare service or procedure at the time of charge capture, representing the facility or professional fee before insurance adjustments, contractual write-offs, or patient responsibility calculations are applied.

charge first namechrg_first_nm

The given name of the patient or responsible party associated with a charge record, used in hospital billing and revenue cycle systems to match charge transactions to the correct account and verify patient identity during claim submission and payment posting.

charge flagchrg_flg

Binary status marker (0/1 or Y/N) applied to a service fee record in EHR, claims, or hospital billing systems to indicate whether a specific charge condition applies, such as taxability, bundling eligibility, or denial status requiring downstream adjudication logic.

charge frequencychrg_freq

The interval or recurrence pattern at which a billable service or treatment is administered, such as daily or weekly, used in charge capture systems to validate recurring service billing and ensure appropriate charge quantities are posted per billing period.

charge full namechrg_full_nm

The complete name, including given and family name, of the patient or responsible party linked to a charge transaction, used in billing and revenue cycle systems to confirm account identity during claim preparation, statement generation, and collections processing.

PreviousPage 56 of 325Next