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 arrival timecpt_arrv_tm

The recorded timestamp of a patient's arrival at a facility when associated with a CPT-coded encounter or procedure. Used in operational reporting to measure throughput, calculate wait times, assess care delivery efficiency, and validate time-sensitive procedure billing requirements.

cpt arrived datecpt_arrv_dt

The calendar date on which a patient arrived at a care facility in association with a CPT-coded service or procedure. Used in encounter-level reporting to establish service timelines, support visit reconciliation, and validate date-of-service accuracy on submitted medical claims.

cpt birth datecpt_birth_dt

The date of birth of the patient associated with a CPT-coded procedure encounter. Used to calculate patient age at time of service, validate age-specific procedure eligibility criteria, and support demographic analysis in claims and clinical procedure utilization reporting.

cpt blood pressurecpt_bp

The arterial pressure value for a current procedural terminology code. 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 cpt management and reporting.

cpt cancelled datecpt_cncl_dt

The calendar date on which a scheduled CPT-coded procedure was cancelled before completion. Used in operational and revenue cycle reporting to track procedure cancellation rates, analyze scheduling efficiency, and identify impacts on claim submission and reimbursement timelines.

cpt categorycpt_cat

The high-level classification grouping assigned to a CPT code, such as Evaluation and Management, Surgery, Radiology, Pathology, or Medicine. Used to organize procedure codes for utilization analysis, reimbursement benchmarking, and clinical reporting across service lines and specialties.

cpt chief complaintcpt_cc

The primary symptom, condition, or reason for the clinical encounter as documented in association with a billed CPT procedure code. Supports medical necessity validation, clinical coding accuracy review, and links patient-reported presenting problems to procedure-level billing data in claims analysis.

cpt childcpt_chld

A subordinate CPT code that is hierarchically linked to a parent procedure code, representing a component or add-on service within a bundled procedure set. Used in claims adjudication and coding logic to manage bundling rules, prevent duplicate billing, and apply correct reimbursement.

cpt citycpt_city

The city name of the facility or service location where a CPT-coded procedure was performed. Used in geographic analysis of procedure utilization, provider network mapping, claims data validation, and regional cost benchmarking across healthcare delivery sites and payer populations.

cpt claim datecpt_clm_dt

The date on which a medical claim containing a CPT-coded procedure was submitted to a payer for adjudication. Used in revenue cycle management to track filing timeliness, monitor payer turnaround times, calculate days in accounts receivable, and identify late submission trends.

cpt claim statuscpt_clm_sts

The current adjudication state of a medical claim line associated with a CPT-coded procedure, such as pending, paid, denied, or appealed. Used in revenue cycle workflows to monitor reimbursement progress, prioritize follow-up actions, and measure payer performance against contractual timelines.

cpt classcpt_cls

The classification tier assigned to a CPT-coded procedure, such as major, minor, inpatient, or outpatient. Used to stratify procedures by complexity and care setting for reimbursement modeling, utilization management, quality reporting, and cost analysis across payer contracts and service categories.

cpt codecpt_cd

A five-character alphanumeric code from the AMA Current Procedural Terminology code set used in EHR, claims, and clearinghouse systems to standardize reporting of medical, surgical, and diagnostic procedures. Required on CMS-1500 and UB-04 claim forms for provider reimbursement and used in utilization analysis across payer and EHR platforms.

cpt commentcpt_cmt

Free-text narrative documentation associated with a CPT-coded procedure, capturing supplemental clinical or administrative context not represented in structured fields. Used to support coding decisions, document exceptions, record payer communications, and provide audit evidence in claims review workflows.

cpt completed datecpt_cmpl_dt

The calendar date on which a CPT-coded procedure was fully performed and documented as complete. Used in revenue cycle reporting to confirm service delivery prior to claim submission, calculate procedure duration metrics, and validate date-of-service accuracy for billing and quality measure purposes.

cpt countcpt_cnt

The total number of times a specific CPT code appears within a defined dataset, claim, encounter, or reporting period. Used in utilization analysis, provider profiling, cost benchmarking, and quality reporting to measure procedure frequency and identify outliers across patient populations and care settings.

cpt countrycpt_ctry

The country where a CPT-coded procedure was performed, relevant for international claims, medical tourism scenarios, or cross-border care coordination. Used in claims data to ensure appropriate reimbursement rules are applied and to support geographic utilization analysis across international service locations.

cpt created bycpt_crtd_by

Identifies the user or system that added a CPT code record to the healthcare data system. Used in claims processing and clinical data management to maintain audit trails, ensuring accountability for CPT code entries across billing and coding workflows.

cpt created datecpt_crtd_dt

The calendar date on which a CPT code record was initially entered into the healthcare data system. Used in claims and coding audit trails to track when procedural terminology codes were added, supporting compliance reviews and data lineage in billing systems.

cpt created timecpt_crtd_tm

The timestamp recording the exact time a CPT code record was created in the healthcare data system. Combined with the created date, this supports precise audit trails in claims processing and coding workflows, enabling accurate sequencing of procedural code entries.

PreviousPage 38 of 178Next