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

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

3,545 claims terms

cpt statuscpt_sts

Indicates the current processing or lifecycle state of a CPT procedure code within a claim or clinical record, such as active, pending, denied, paid, or voided. Used in claims adjudication and coding workflows to track transaction progress, manage edit queues, and monitor reimbursement outcomes.

cpt subtotalcpt_subtot

The partial monetary sum calculated for a subset of CPT procedure codes within a claim or encounter before final adjustments, modifiers, or bundling rules are applied. Used in claims pricing workflows to support line-level cost transparency, remittance reconciliation, and fee schedule validation.

cpt targetcpt_tgt

A reference to the destination system, record, or entity to which a CPT procedure code is being routed or mapped, such as a payer system, code crosswalk, or clinical registry. Used in data integration and claims routing workflows to ensure accurate procedure code transmission and processing.

cpt taxonomy codecpt_tax_cd

The NUCC Health Care Provider Taxonomy code associated with the rendering provider of a CPT-coded service, identifying their specialty and classification. Used in claims adjudication to validate that the performing provider's specialty is appropriate for the billed CPT procedure under payer credentialing and coverage policies.

cpt temperaturecpt_temp

The body temperature measurement recorded in association with a CPT procedure code, typically captured during clinical encounters to document patient vitals linked to a specific procedural service for clinical and billing documentation purposes.

cpt termination datecpt_term_dt

The date on which a CPT procedure code becomes inactive or invalid for billing purposes. Used in claims processing and fee schedule management to ensure only currently active CPT codes are accepted during claim adjudication within the applicable contract period.

cpt timecpt_tm

The specific time of day at which a CPT-coded procedure or service was performed during a clinical encounter. Used in claims and clinical documentation to establish service sequencing, anesthesia duration billing, and intraoperative procedure timing records.

cpt timestampcpt_ts

The combined date and time value recording when a CPT-coded procedure was performed or documented. Supports audit trails, claim sequencing, and concurrent procedure analysis in claims adjudication systems and clinical data warehouses.

cpt titlecpt_ttl

The official AMA-published descriptive title associated with a CPT procedure code, used to communicate the clinical meaning of the code in remittance advice, EOBs, clinical documentation, and provider-facing reporting within claims and EHR systems.

cpt totalcpt_tot

The aggregate financial or unit value associated with a CPT procedure code on a claim, representing the sum of charges, allowed amounts, or units billed for that specific procedure across one or more service lines in claims adjudication systems.

cpt total countcpt_tot_cnt

The total number of times a specific CPT procedure code appears across claims, encounters, or service lines within a defined population or time period. Used in utilization management, quality reporting, and cost analysis within healthcare analytics systems.

cpt typecpt_typ

The classification category of a CPT code indicating whether it belongs to Category I (standard procedures), Category II (performance measures), or Category III (emerging technologies), used to govern billing rules and reimbursement eligibility in claims processing.

cpt updated datecpt_upd_dt

The date on which a CPT procedure code record was most recently modified in a fee schedule, claims system, or clinical reference database. Supports version control and ensures current code descriptions, pricing, and billing rules are applied accurately.

cpt urgencycpt_urg

The clinical urgency or priority level assigned to a CPT-coded procedure, distinguishing elective, urgent, or emergent services. Influences authorization workflows, scheduling prioritization, and may affect reimbursement classification in claims processing systems.

cpt versioncpt_ver

The version number identifying which annual AMA CPT code set edition applies to a specific procedure code record. Ensures accurate claims adjudication by tracking code definition changes, deletions, and additions across yearly CPT publication cycles.

cpt zipcpt_zip

The postal ZIP code associated with the location where a CPT-coded procedure was performed. Used in claims processing for geographic reimbursement adjustments, Medicare locality determination, and provider service area analytics within billing systems.

credit adjustment amountcr_adj_amt

The dollar value of a credit adjustment applied to a healthcare claim, representing a reduction in the amount owed due to overpayment recovery, contractual write-off, or payer-initiated correction during claim reconciliation and accounts receivable processing.

credit claim datecr_clm_dt

The date on which a credit-related claim or overpayment recovery request was submitted to the payer. Used in accounts receivable and claims reconciliation workflows to track timely filing, payment offsets, and credit resolution timelines.

credit claim statuscr_clm_sts

The current adjudication state of a credit claim or overpayment recovery request, indicating whether it is pending, approved, denied, or offset. Tracks the lifecycle of credit transactions within payer claims management and accounts receivable systems.

credit deductible amountcr_ded_amt

The portion of a credit transaction attributable to the member deductible, representing amounts previously applied toward the patient's annual deductible that are being reversed or refunded due to claim adjustment or overpayment correction in claims processing.

PreviousPage 43 of 178Next