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

quality payment amountqlty_pmt_amt

Records the dollar amount paid for services associated with a quality measure or value-based care program. Used in payer and ACO financial systems to track reimbursement tied to quality performance incentives, pay-for-performance bonuses, or fee schedule payments for quality-linked clinical services.

quality payment statusqlty_pmt_sts

Indicates the current reimbursement processing state for claims or incentive payments associated with quality measures or value-based care programs, such as pending, issued, or withheld. Used in payer systems to track remittance activity for performance-based payments under STAR, HEDIS, or ACO contracts.

questionnaire adjustment amountqstn_adj_amt

Records the dollar value of a financial adjustment applied to a claim associated with a patient-administered or clinical questionnaire, such as PHQ-9 depression screening or HRA completion. Reflects contractual write-offs or coordination of benefits corrections for assessment-based billing transactions.

questionnaire claim dateqstn_clm_dt

Records the date a claim was submitted for reimbursement of services associated with a clinical or patient-reported questionnaire, such as a health risk assessment or standardized screening tool. Used to track submission timelines and enforce filing requirements for assessment-linked billing transactions.

questionnaire claim statusqstn_clm_sts

Captures the current adjudication state of a claim submitted for services associated with a clinical questionnaire or standardized screening tool, such as received, pending, approved, or denied. Supports claims management workflows for assessment-based billing including health risk assessments and behavioral health screenings.

questionnaire deductible amountqstn_ded_amt

The dollar amount applied toward a member's annual deductible that is associated with a health assessment or clinical questionnaire encounter. Used in claims adjudication to track cost-sharing obligations before insurance coverage activates for questionnaire-linked services.

questionnaire payment amountqstn_pmt_amt

The total dollar amount paid by the payer, member, or both for services tied to a health assessment or clinical questionnaire. Used in healthcare claims processing and remittance tracking to reconcile reimbursement for questionnaire-based clinical encounters.

questionnaire payment statusqstn_pmt_sts

Indicates the current payment processing state for a claim associated with a health assessment or clinical questionnaire, such as pending, paid, denied, or adjusted. Used in revenue cycle management to monitor reimbursement progress for questionnaire-linked service claims.

questionnaire review systemsqstn_ros

Documents the body systems reviewed through a standardized clinical questionnaire administered during a patient encounter. Supports Review of Systems documentation requirements for E/M level coding and ensures completeness of the clinical assessment in the medical record.

questionnaire service dateqstn_svc_dt

The calendar date on which a standardized health assessment or clinical questionnaire was administered to a patient. Used in clinical documentation and claims processing to establish the encounter timeline and ensure timely filing compliance for questionnaire-associated services.

queue adjustment amountque_adj_amt

The dollar value of a financial adjustment applied to a claim or transaction held within a claims processing or billing work queue. Captures contractual write-offs, payer adjustments, or corrections made during queue-based claim review and resolution workflows.

queue claim dateque_clm_dt

The date a claim was submitted or entered into a claims processing work queue awaiting review, adjudication, or correction. Used in revenue cycle management to monitor claim aging, identify delays, and measure queue throughput efficiency across billing workflows.

queue claim statusque_clm_sts

The current adjudication or processing state of a claim held in a billing or claims work queue, such as pending review, suspended, denied, or approved. Used in revenue cycle management to prioritize follow-up actions and track claim resolution progress.

queue deductible amountque_ded_amt

The dollar amount applied toward a member's annual deductible for a claim currently held in a claims processing or billing work queue. Captured during adjudication workflows to accurately reflect member cost-sharing obligations before the claim is finalized.

queue payment amountque_pmt_amt

The total dollar amount expected or remitted for a claim currently held in a billing or claims processing work queue. Used in revenue cycle management to project reimbursement, reconcile payments, and monitor financial outcomes of queued claim transactions.

queue payment statusque_pmt_sts

Indicates the current payment processing state for a claim held in a billing or claims work queue, such as pending, paid, denied, or in review. Used in revenue cycle management to track remittance activity and drive follow-up actions on unresolved queued claims.

queue review systemsque_ros

Identifies the body systems documented in a clinical note or encounter record associated with a case held in a clinical or administrative review queue. Supports quality review workflows by ensuring Review of Systems documentation meets coding and compliance requirements.

queue service dateque_svc_dt

The date of service associated with a claim or encounter record currently held in a billing or claims processing work queue. Used to determine claim age, assess timely filing deadlines, and prioritize queue resolution activities in revenue cycle workflows.

radiologist adjustment amountrad_adj_amt

The dollar value of a contractual or administrative adjustment applied to a claim submitted by a radiologist for diagnostic imaging or interventional radiology services. Reflects payer-negotiated write-offs, bundling edits, or corrections made during claims adjudication for imaging services.

radiologist claim daterad_clm_dt

The date a claim was submitted by a radiologist or radiology group for diagnostic imaging, interventional, or interpretive services rendered. Used in revenue cycle management to track filing timeliness, measure adjudication cycle time, and ensure compliance with payer submission deadlines.

PreviousPage 112 of 178Next