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

cardiology valuecard_val

A discrete numeric or coded data point representing a measured clinical observation, test result, or assessment finding specific to cardiology care as stored in EHR or diagnostic systems. Data engineers use this field to populate cardiac quality metrics, risk model inputs, and outcomes reporting tables in analytics environments.

cardiology versioncard_ver

The sequential version number assigned to a cardiology record to track revisions over time, such as updates to a cardiac care plan, authorization request, or clinical documentation. Used in data governance and audit processes to identify the current authoritative version and maintain a complete revision history.

cardiology zipcard_zip

The five or nine-digit postal code associated with a cardiology service location, a cardiologist's practice address, or a cardiac patient's residence. Used in geographic analysis of cardiac care access, network adequacy assessments, and claims processing to validate service area and coordinate benefits.

carrier admission datecarr_admn_dt

The inpatient hospital admission date as recorded or transmitted by the insurance carrier on a claim or coordination of benefits transaction. Used in claims adjudication to validate inpatient length of stay, apply correct reimbursement logic, and coordinate benefits when multiple carriers are involved in coverage.

carrier discharge datecarr_dsch_dt

The inpatient hospital discharge date as reported by the insurance carrier on a claim or coordination of benefits record. Used in claims processing to calculate covered length of stay, apply DRG-based reimbursement, and reconcile benefit payments when the carrier is secondary or tertiary in a multi-payer scenario.

carrier emergency indicatorcarr_emerg_ind

A flag on a carrier claim or transaction record indicating whether the associated service was rendered as an emergency, affecting how benefits are applied and cost-sharing is calculated. Used in claims adjudication to waive prior authorization requirements and apply emergency benefit provisions under the carrier's plan.

carrier history present illnesscarr_hpi

The narrative description of a member's presenting condition as included in clinical documentation submitted to or maintained by an insurance carrier in support of a claim, prior authorization, or appeal. Used by carrier medical reviewers to assess medical necessity and determine appropriate coverage under the member's benefit plan.

carrier labelcarr_lbl

The display name or descriptive text assigned to an insurance carrier within a health plan's administrative system, used to identify the payer in member eligibility records, claims transactions, and coordination of benefits workflows. Ensures accurate carrier identification across enrollment, billing, and remittance processes.

carrier procedure datecarr_proc_dt

The date on which a medical procedure was performed, as recorded on a claim submitted to or processed by an insurance carrier. Used in claims adjudication to verify timely filing compliance, apply correct fee schedules, and coordinate benefits with other carriers covering the same member.

carrier rangecarr_rng

The defined span of values, dates, or benefit limits associated with an insurance carrier's coverage parameters, such as allowable charge ranges or covered service date windows. Used in claims adjudication and coordination of benefits to validate whether submitted charges and services fall within the carrier's applicable coverage boundaries.

carrier resultcarr_rslt

The outcome of a carrier-level transaction or claims adjudication process, such as a payment determination, denial reason, or authorization decision. Used in remittance processing, appeals management, and coordination of benefits to communicate the carrier's final disposition on a submitted claim or coverage inquiry.

carrier surgery datecarr_surg_dt

The date on which a surgical procedure was performed, as reported on a claim submitted to an insurance carrier. Used in claims adjudication to confirm medical necessity timing, apply surgical fee schedule rules, coordinate benefits with other carriers, and validate that the service date aligns with active coverage periods.

charge admission datechrg_admn_dt

The date a patient was admitted to a hospital or inpatient facility as recorded on a charge record. Used in UB-04 institutional claims, EHR billing modules, and revenue cycle systems to calculate length of stay, DRG assignment, and inpatient charge aggregation.

charge discharge datechrg_dsch_dt

The date a patient was released from an inpatient or outpatient facility as recorded on a charge record. Used in UB-04 institutional claims, EHR billing systems, and revenue cycle platforms to finalize encounter billing, calculate length of stay, and trigger post-discharge charge reconciliation workflows.

charge emergency indicatorchrg_emerg_ind

A flag on a charge record indicating whether the billed service was rendered in an emergency context, which affects how the charge is coded, billed, and reimbursed. Used in revenue cycle management to apply emergency facility fees, bypass prior authorization edits, and ensure correct claim submission under applicable emergency benefit provisions.

charge history present illnesschrg_hpi

The clinical narrative describing the patient's presenting condition associated with a specific charge, captured to support medical necessity documentation in the revenue cycle. Used in charge capture and billing workflows to ensure that the documented clinical history aligns with the billed diagnosis codes and justifies the charges submitted on the claim.

charge labelchrg_lbl

The descriptive display text assigned to a specific service fee in billing and charge capture systems. Used to present human-readable charge descriptions on patient statements, remittance advice, and internal billing reports to identify the nature of a billed service or procedure.

charge procedure datechrg_proc_dt

The calendar date on which a clinical procedure was performed and associated charges were incurred. Used in charge capture and revenue cycle management to align billed services with the correct service date, ensuring accurate claim submission and timely filing compliance.

charge rangechrg_rng

Minimum and maximum value boundaries defined for a service fee in hospital pricing, payer contract, or EHR systems, used to validate charge amounts during charge capture, detect outliers in pricing analytics, and enforce fee schedule compliance across billing workflows.

charge resultchrg_rslt

The outcome or disposition of a charge transaction after processing through billing edits, payer adjudication, or revenue cycle workflows in healthcare systems. Used in EHR and claims platforms to capture whether a charge was accepted, denied, adjusted, or pended for review.

PreviousPage 85 of 806Next