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

copay unitcpay_unt

The unit of measure associated with a patient cost-sharing calculation, such as per visit, per prescription, or per day, within claims and PBM adjudication systems. Ensures accurate benefit rule application, reporting normalization, and downstream financial analytics across service types.

counselor addresscnsl_addr

Stores the full mailing or practice address for a licensed counselor or behavioral health professional. Used in provider directory, credentialing, and referral management systems to support patient access, network validation, and regulatory compliance for mental health services.

counselor approval statuscnsl_appr_sts

Indicates the current credentialing or privileging authorization state of a licensed counselor, such as pending, approved, suspended, or revoked. Used in provider enrollment and credentialing systems to ensure only qualified behavioral health professionals deliver covered services within a network.

counselor charge amountcnsl_chrg_amt

Records the billed dollar amount charged by a licensed counselor for a behavioral health service rendered. Used in claims processing and revenue cycle systems to support adjudication, fee schedule validation, and reimbursement calculations for mental health encounters.

counselor effective datecnsl_eff_dt

Identifies the date on which a licensed counselor's enrollment, contract, or credentialing status becomes active within a health plan or provider network. Used in credentialing and claims systems to validate service eligibility and ensure accurate reimbursement for behavioral health encounters.

counselor group numbercnsl_grp_nbr

Stores the insurance group identifier associated with a licensed counselor's practice or employer health plan affiliation. Used in enrollment and claims systems to link the counselor to the correct benefit group, supporting accurate billing and network participation verification.

counselor medical record numbercnsl_mrn

Captures the unique medical record number assigned when a licensed counselor is also a patient within the same health system. Used to distinguish clinical and administrative records, prevent data conflicts, and maintain accurate longitudinal health histories in EHR systems.

counselor scheduled datecnsl_sched_dt

Records the calendar date on which a patient appointment with a licensed counselor or behavioral health professional is planned. Used in scheduling and care management systems to coordinate mental health services, track appointment adherence, and manage referral workflows.

counselor scheduled timecnsl_sched_tm

Captures the specific time of day at which a patient session with a licensed counselor is planned to begin. Used in behavioral health scheduling systems to manage appointment slots, prevent double-booking, and support timely delivery of mental health services.

counselor street addresscnsl_st_addr

Records the street-level address of a licensed counselor's primary practice location. Used in provider directory and credentialing systems to support patient referrals, network mapping, and regulatory reporting for behavioral health services within a health plan or care network.

counselor unitcnsl_unt

Specifies the billing or service unit associated with a licensed counselor's rendered session, such as a 15-minute increment or single therapy session. Used in claims and revenue cycle systems to calculate reimbursement amounts and validate service quantities against payer fee schedules.

coverage addresscov_addr

Stores the mailing or primary address associated with a member's insurance coverage record. Used in enrollment and eligibility systems to determine geographic service area, assign regional plan benefits, route correspondence, and validate coverage applicability for specific provider networks.

coverage effective datecov_eff_dt

The calendar date on which a member's insurance coverage becomes active and claims become eligible for adjudication under a given plan. Stored in member enrollment and eligibility systems, this date is critical for claim validation, coordination of benefits, and retroactive eligibility processing in payer and EHR platforms.

coverage scheduled datecov_sched_dt

Records the planned date on which an insurance coverage action is scheduled to take effect, such as a renewal, termination, or benefit change. Used in member enrollment systems to manage plan transitions, coordinate eligibility updates, and ensure continuity of benefits without coverage gaps.

coverage scheduled timecov_sched_tm

The specific time of day when a member's insurance coverage event or transaction is scheduled to occur. Used in enrollment and benefits administration systems to record precise timing of coverage-related actions such as policy activations, terminations, or plan changes.

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.

PreviousPage 70 of 320Next