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

unit payment statusunt_pmt_sts

Indicates the current state of payment processing for a claim associated with inpatient or specialty care unit services, tracking whether reimbursement has been issued, is pending, was denied, or requires follow-up. Supports revenue cycle oversight and accounts receivable management for facility billing.

urology adjustment amounturo_adj_amt

Represents the dollar amount added to or subtracted from the original billed charge for a urology specialty service during claims adjudication. Captures contractual allowances, payer-specific fee schedule variances, or correction amounts applied to urinary system procedure claims before final reimbursement.

urology claim dateuro_clm_dt

Records the date on which a claim for a urology specialty service was submitted to the payer for adjudication. Used in claims processing workflows to track timely filing compliance, manage payer response timelines, and monitor accounts receivable for urinary system and urological procedure billing.

urology claim statusuro_clm_sts

Reflects the current adjudication state of a claim submitted for urology specialty services, indicating whether the claim is received, in process, approved, denied, or pending additional clinical documentation. Supports billing workflow management and reimbursement tracking for urinary system procedures.

urology deductible amounturo_ded_amt

Specifies the dollar amount applied toward a member's annual deductible for a urology specialty service. Represents the patient's out-of-pocket responsibility before insurance coverage activates, as calculated during claims adjudication for urinary system procedures and urological treatments.

urology payment amounturo_pmt_amt

Records the actual dollar amount paid by the insurer or payer for a urology specialty service following claims adjudication. Reflects final reimbursement issued after applying contractual fee schedules, deductibles, copayments, and coordination of benefits for urinary system procedures.

urology payment statusuro_pmt_sts

Indicates the current reimbursement processing state for urology specialty claims, such as pending, paid, denied, or appealed. Tracks payer adjudication outcomes for procedures involving the urinary tract, kidneys, bladder, and male reproductive system submitted to insurance.

urology review systemsuro_ros

Documents the review of systems (ROS) findings specific to urology encounters, capturing patient-reported symptoms related to urinary frequency, hematuria, incontinence, renal function, and related genitourinary conditions as part of the clinical evaluation and medical record documentation.

urology service dateuro_svc_dt

Records the actual date on which a urology-related clinical service was rendered, including procedures such as cystoscopy, nephrectomy, or dialysis access. Used in claims processing and clinical records to establish the episode of care timeline for urinary system treatments.

vaccination claim datevacc_clm_dt

Captures the date a vaccination-related claim was submitted to the payer for reimbursement. Used in claims processing workflows to track filing timelines, ensure timely submission within payer deadlines, and support immunization program billing reconciliation across medical and pharmacy benefit channels.

vaccination claim statusvacc_clm_sts

Reflects the current adjudication state of a vaccination claim submitted to a health plan, such as received, pending, approved, denied, or adjusted. Supports billing team workflows for tracking immunization reimbursement outcomes and resolving claim exceptions tied to vaccine administration codes.

vaccination payment amountvacc_pmt_amt

Records the dollar amount paid by the health plan or payer for a vaccination claim, including both the vaccine product and administration fees. Used in revenue cycle management to reconcile expected reimbursement against actual payments for immunization services across benefit types.

vaccination payment statusvacc_pmt_sts

Indicates whether payment for a submitted vaccination claim has been processed, is pending, was denied, or has been partially reimbursed by the payer. Supports accounts receivable tracking for immunization billing and helps identify outstanding balances for vaccine administration services.

validation adjustment amountvalid_adj_amt

Represents the dollar value of a financial adjustment applied during a claims or data validation process, such as correcting billing errors, resolving duplicate submissions, or reconciling discrepancies between billed and allowed amounts identified through auditing or payer edit checks.

validation claim datevalid_clm_dt

Records the date a claim entered or completed a validation process, such as pre-submission edit checks or post-adjudication audit review. Used in claims management workflows to track when accuracy verification occurred and establish audit trail timestamps for compliance and reporting purposes.

validation claim statusvalid_clm_sts

Indicates the adjudication or audit state of a claim that has undergone a validation review process, such as passed, failed, pending correction, or resubmitted. Supports quality assurance workflows in claims processing by tracking claims requiring correction before or after payer submission.

validation deductible amountvalid_ded_amt

Captures the patient deductible amount identified or confirmed during a claim validation process, reflecting the portion of the allowed amount applied to the member's annual deductible. Used in financial reconciliation to ensure accurate cost-sharing calculations align with benefit plan design rules.

validation payment amountvalid_pmt_amt

Records the payment amount confirmed or corrected during a claim validation or audit review process. Used to verify that reimbursement amounts match contracted rates, fee schedules, or benefit plan allowances, supporting accurate financial settlement and revenue cycle integrity for validated claims.

validation payment statusvalid_pmt_sts

Indicates the payment processing state of a claim following completion of a validation or audit review, such as approved for payment, held pending correction, or returned for rebilling. Supports financial operations teams in tracking reimbursement outcomes for claims that underwent accuracy verification.

validation review systemsvalid_ros

Documents the clinical review of systems (ROS) data that has undergone a validation check for accuracy, completeness, or coding compliance. Used in clinical documentation improvement and audit workflows to confirm that reported symptoms and system findings are supported by the underlying medical record.

PreviousPage 167 of 178Next