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

Pharmacy

NDC codes, dispensing, PBM, RxNorm and formulary management

1,921 pharmacy terms

consumable copay amountcons_cpay_amt

The patient cost-sharing dollar amount applied to single-use medical supply items dispensed during a clinical encounter or through a durable medical equipment benefit. Used in claims and pharmacy billing systems to capture member responsibility for consumable supplies covered under the health plan.

copay active indicatorcpay_actv_ind

A binary flag indicating whether a specific copayment rule, amount, or record is currently in effect within the health plan's benefit configuration. Used in enrollment and claims systems to determine whether a copay definition should be applied during adjudication of member claims.

copay active statuscpay_actv_sts

A categorical status value describing the current operational state of a copayment record within a health plan benefit structure, such as active, suspended, or terminated. Used in benefit administration systems to control whether a copay rule is eligible for application during claims adjudication.

copay addresscpay_addr

The physical mailing or service location associated with a copay transaction or copay collection entity, stored in claims and member enrollment systems. Used by data engineers to route copay correspondence, validate provider billing addresses, and support geographic analysis of patient cost-sharing data across healthcare platforms.

copay adjustment amountcpay_adj_amt

The dollar value representing a modification made to an original copayment amount after initial adjudication, reflecting corrections, appeals, contract updates, or coordination of benefits recalculations. Used in claims processing to document and reconcile changes to member out-of-pocket cost-sharing obligations.

copay agecpay_age

The age of a member at the time a copayment obligation is established or applied, used to support age-tiered benefit structures where cost-sharing amounts vary by member age band. Relevant in health plan benefit configuration and claims adjudication for pediatric, adult, and senior plan designs.

copay allowed amountcpay_alwd_amt

The maximum dollar amount a health plan permits as a copayment for a specific service category or benefit tier, as defined in the plan's fee schedule or member benefit contract. Used during claims adjudication to cap member cost-sharing and ensure copay collection does not exceed contractual limits.

copay amountcpay_amt

The fixed monetary value representing a member's required cost-sharing payment at point of service or claim adjudication, stored in member benefit plan tables, claims detail records, and PBM transaction files. Used in downstream analytics, remittance reporting, accumulator updates, and member financial liability calculations across healthcare data systems.

copay approval statuscpay_appr_sts

The authorization state of a copayment transaction or waiver request, indicating whether the copay has been approved, denied, pending review, or escalated. Used in claims and billing workflows to track administrative decisions affecting member out-of-pocket cost-sharing obligations for a given service.

copay approved bycpay_appr_by

The identifier or name of the user, role, or system that authorized a copayment amount, waiver, or adjustment within the health plan's billing or benefit administration workflow. Used in audit trails to establish accountability for changes or approvals applied to member cost-sharing records.

copay arrival timecpay_arrv_tm

The timestamp recording when a copayment transaction, remittance, or associated patient encounter arrived in the billing or claims processing system. Used in revenue cycle management to track processing timelines, identify delays in payment posting, and support copay reconciliation workflows.

copay arrived datecpay_arrv_dt

The calendar date on which a copayment transaction, payment, or associated claim record was received by the billing system or clearinghouse. Used in revenue cycle and accounts receivable workflows to monitor payment timelines, calculate aging, and reconcile member out-of-pocket collections.

copay assessmentcpay_asmt

A structured or free-text evaluation of a member's copayment obligation, which may include financial hardship reviews, benefit verification notes, or billing staff assessments used to determine eligibility for copay waivers or adjustments within the health plan's financial assistance programs.

copay balancecpay_bal

The remaining unpaid portion of a member's copay obligation after partial payments are applied, tracked in accounts receivable modules, claims adjudication systems, and patient financial services platforms. Used by data engineers to reconcile member payment records, support collections workflows, and report outstanding cost-sharing liabilities in healthcare finance systems.

copay billed amountcpay_bill_amt

The total dollar amount invoiced to a member for their copayment obligation on a specific service or claim, as reflected on the explanation of benefits or patient statement. Used in accounts receivable and member billing systems to track what was charged versus what was collected for cost-sharing.

copay birth datecpay_birth_dt

The date of birth associated with the member or patient linked to a copay record, stored in eligibility files, member enrollment systems, and claims detail tables. Used by data engineers to validate member identity, apply age-based benefit rules, and ensure accurate copay assignment during claims adjudication and PBM transaction processing.

copay blood pressurecpay_bp

The arterial pressure value for a patient responsibility amount. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for copay management and reporting.

copay cancelled datecpay_cncl_dt

The calendar date on which a previously established copayment obligation or copay record was voided or cancelled, due to claim reversal, benefit correction, or administrative action. Used in claims and billing systems to maintain accurate audit histories of member cost-sharing transactions.

copay categorycpay_cat

A classification label grouping copay records by type, benefit tier, or drug class within pharmacy and PBM systems. Copay category fields appear in benefit plan configuration tables and formulary management systems, enabling data engineers to segment cost-sharing data for reporting, plan design analysis, and downstream integration with member-facing healthcare applications.

copay charge amountcpay_chrg_amt

The dollar amount assessed as a copayment charge to a member at the point of service or upon claims adjudication, reflecting the plan-defined cost-sharing requirement for a specific service type or benefit tier. Used in revenue cycle systems to initiate member billing and reconcile collected payments.

PreviousPage 21 of 97Next