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,391 operations terms

charge datechrg_dt

The calendar date on which a billable healthcare service was rendered or a charge record was posted in an EHR or hospital billing system. Used in revenue cycle management, claims generation, and financial reporting to align service delivery with billing cycles and payer submission deadlines.

charge datetimechrg_dttm

The combined date and time value indicating when a charge event was recorded or a billable service was delivered in an EHR or hospital billing system. Used for precise charge sequencing, audit logging, charge lag measurement, and intraday revenue cycle analytics across clinical and financial data platforms.

charge dea numberchrg_dea_nbr

The Drug Enforcement Administration registration number associated with the prescribing clinician or dispensing entity recorded on a charge record. Used in pharmacy and controlled substance billing to validate prescriber authority, support regulatory compliance, and satisfy payer requirements for controlled substance claims.

charge death datechrg_death_dt

The recorded date of a patient's death as associated with a charge record in an EHR or hospital billing system. Used to terminate billing cycles, validate final claim submission dates, support mortality reporting, and ensure compliance with CMS regulations governing charges for deceased beneficiaries.

charge deleted datechrg_del_dt

The calendar date on which a charge record was marked as deleted or removed from active billing processing. Used in revenue cycle auditing to maintain a complete transaction history, support charge reconciliation, and identify trends in charge removals that may indicate documentation or workflow issues.

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 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.

PreviousPage 55 of 320Next