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

coverage street addresscov_st_addr

The physical street address associated with an insurance coverage record, typically representing the policyholder's or subscriber's mailing or residential address. Used in member enrollment systems to determine eligibility, assign plan territories, and route correspondence related to the coverage policy.

coverage unitcov_unt

The unit of measure used to quantify the scope or increment of an insurance coverage benefit, such as days of inpatient care, number of visits, or dollar thresholds. Used in benefits configuration and claims adjudication to track utilization against coverage limits.

cpt addresscpt_addr

The physical location address linked to a Current Procedural Terminology code record, typically identifying the facility or service site where the coded procedure was performed. Used in claims processing and billing systems to associate CPT codes with place-of-service information for reimbursement purposes.

cpt approval statuscpt_appr_sts

The authorization or approval state of a Current Procedural Terminology code on a claim or prior authorization request, indicating whether the procedure has been approved, denied, or is pending review. Used in claims adjudication and utilization management workflows to track CPT-level decisions.

cpt charge amountcpt_chrg_amt

The billed charge amount associated with a specific Current Procedural Terminology code on a medical claim, representing the provider's submitted fee for the coded procedure or service. Used in claims processing and revenue cycle management to calculate reimbursement, adjustments, and patient cost-sharing obligations.

cpt effective datecpt_eff_dt

The date on which a Current Procedural Terminology code becomes active and valid for use in medical billing and claims submission. Used in claims processing systems to validate that a CPT code was current and billable on the date of service, ensuring accurate and compliant reimbursement.

cpt group numbercpt_grp_nbr

The insurance group number associated with a Current Procedural Terminology code record on a claim, linking the billed procedure to the member's group health plan. Used in claims adjudication to apply the correct benefit rules, fee schedules, and contractual agreements for the relevant employer group or plan.

cpt medical record numbercpt_mrn

The patient's medical record number linked to a Current Procedural Terminology code entry, identifying the specific patient for whom the procedure was performed and documented. Used to reconcile clinical records with billing data and ensure accurate patient attribution during claims processing and coding audits.

cpt scheduled datecpt_sched_dt

The date on which a procedure identified by a Current Procedural Terminology code is scheduled to be performed. Used in scheduling and pre-authorization workflows to coordinate clinical services, verify eligibility, and ensure prior authorization is obtained before the procedure date.

cpt scheduled timecpt_sched_tm

The specific time of day at which a procedure identified by a Current Procedural Terminology code is scheduled to be performed. Used in clinical scheduling systems to coordinate resources, staff, and patient appointments for procedures requiring CPT-based billing and authorization.

cpt street addresscpt_st_addr

The street-level address of the facility or location where a procedure corresponding to a Current Procedural Terminology code is performed or billed from. Used in claims and billing systems to establish the place of service, support geographic reimbursement rules, and comply with payer requirements.

cpt unitcpt_unt

The number of units billed for a specific Current Procedural Terminology code on a medical claim, indicating the quantity of times a procedure or service was rendered. Used in claims adjudication to calculate total reimbursement, identify billing anomalies, and validate units against payer-defined maximum allowable quantities.

credentialing expiration datecred_exp_dt

The date on which a provider medical staff privileges or payer network credentialing expires and must be renewed through re-credentialing, typically every two to three years. Tracking credentialing expiration dates is essential for compliance — claims submitted after credentialing expiration are denied, and providers with expired privileges create significant liability exposure.

credit addresscr_addr

The physical address associated with a credit transaction in healthcare billing, identifying the entity—such as a patient, payer, or facility—to which an overpayment credit or financial reduction is applied. Used in accounts receivable and revenue cycle systems to route credit adjustments and correspondence accurately.

credit approval statuscr_appr_sts

The current authorization state of a credit transaction in healthcare billing, indicating whether an overpayment recovery, payment reduction, or balance credit has been approved, denied, or is pending review. Used in revenue cycle management to track the workflow status of financial credits applied to accounts or claims.

credit charge amountcr_chrg_amt

The monetary value of a credit applied to a healthcare billing account, representing an overpayment recovery, contractual adjustment, or financial reduction against a previously billed charge. Used in revenue cycle and accounts receivable systems to reconcile outstanding balances and adjust claim-level financials accordingly.

credit effective datecr_eff_dt

The date on which a credit transaction becomes active and is applied to a healthcare billing account or claim, marking when an overpayment, adjustment, or financial reduction takes effect. Used in revenue cycle management to ensure accurate period-based financial reporting and timely reconciliation of account balances.

credit group numbercr_grp_nbr

The insurance group number associated with a credit transaction in healthcare billing, linking the overpayment or financial adjustment to a specific employer group health plan. Used in accounts receivable systems to correctly attribute credit amounts to the appropriate payer contract and group-level financial records.

credit medical record numbercr_mrn

The patient medical record number associated with a credit transaction in healthcare billing, linking a financial credit, overpayment recovery, or charge reduction to a specific patient's account. Used in revenue cycle systems to ensure credits are accurately posted to the correct patient record and claim history.

credit scheduled datecr_sched_dt

The date on which a healthcare billing credit transaction is scheduled to be processed or applied to a patient or payer account, such as an overpayment refund or balance adjustment. Used in revenue cycle management to plan and track the timing of financial credit postings and account reconciliations.

PreviousPage 72 of 325Next