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

pharmacist payment amountphrm_pmt_amt

The total dollar amount reimbursed to a pharmacist or pharmacy for dispensed medications or clinical pharmacist services on an adjudicated pharmacy claim. Calculated based on contracted drug pricing, dispensing fees, and applicable plan-level adjustments or member cost-sharing.

pharmacist payment statusphrm_pmt_sts

The current disbursement state of a payment owed to a pharmacist or pharmacy for adjudicated drug claims or clinical services, such as pending, paid, or reversed. Used in pharmacy financial systems to reconcile remittance data and confirm that reimbursements have been correctly issued.

physical adjustment amountpe_adj_amt

Records the dollar amount applied to modify the original billed charge on a claim associated with a preventive physical examination, including contractual write-offs, coordination of benefits adjustments, or payer-initiated corrections during claims adjudication processing.

physical claim datepe_clm_dt

Captures the date on which a claim for a preventive physical examination service was submitted to the payer for adjudication. Used in claims processing workflows to track submission timelines, measure filing compliance, and support appeals and audit functions.

physical claim statuspe_clm_sts

Indicates the current adjudication state of a claim submitted for a preventive physical examination, such as pending, approved, denied, or paid. Used in claims management to monitor processing stages and identify claims requiring follow-up or resubmission.

physical deductible amountpe_ded_amt

Records the dollar amount applied toward a member's annual deductible for a preventive physical examination claim. Reflects the portion of the allowed amount the member is responsible for before insurance coverage applies, per the terms of their benefit plan.

physical payment amountpe_pmt_amt

Records the actual dollar amount paid by the health plan or payer to the rendering clinician or facility for a preventive physical examination service after adjudication, reflecting any contractual fee schedule rates, adjustments, and applied cost-sharing amounts.

physical payment statuspe_pmt_sts

Indicates the current state of payment processing for a preventive physical examination claim, such as payment issued, payment pending, or payment denied. Used in revenue cycle management to track remittance activity and identify outstanding or disputed payments.

physical review systemspe_ros

Documents the structured body systems review completed during a preventive physical examination encounter, recording patient-reported and clinician-assessed findings across relevant organ systems to support evaluation, medical decision-making, and clinical documentation requirements.

physical service datepe_svc_dt

Captures the calendar date on which a preventive physical examination was rendered to the patient. Used in claims processing, clinical records, and quality reporting to establish the encounter timeline, validate billing eligibility, and support care gap analysis.

plan adjustment amountpln_adj_amt

Records the dollar amount used to modify a claim payment associated with a specific health benefit plan, reflecting contractual discounts, plan-level coordination of benefits, or post-adjudication corrections applied during the claims settlement process for that plan.

plan claim datepln_clm_dt

Captures the date a claim was submitted under a specific health benefit plan for adjudication. Used in claims administration to enforce timely filing requirements, track plan-level claim volumes, and support trend analysis across benefit plan populations.

plan claim statuspln_clm_sts

Indicates the adjudication state of a claim processed under a specific health benefit plan, such as received, in review, approved, denied, or closed. Supports plan-level claims monitoring, reporting, and identification of processing backlogs or denial patterns.

plan deductible amountpln_ded_amt

Records the dollar amount applied toward the annual deductible under a specific health benefit plan for a given claim. Reflects plan-defined cost-sharing rules and accumulates against the member's deductible threshold as defined in their enrollment benefit structure.

plan payment amountpln_pmt_amt

Records the dollar amount paid by the health plan to a provider or facility for covered services under a specific benefit plan after adjudication, net of member cost-sharing obligations, contractual adjustments, and any applicable coordination of benefits amounts.

plan payment statuspln_pmt_sts

Indicates the current state of payment for a claim adjudicated under a specific health benefit plan, such as payment issued, pending, withheld, or reversed. Used in plan financial reporting and reconciliation workflows to track remittance accuracy and completeness.

plan review systemspln_ros

Documents body systems review findings associated with clinical encounters tied to a specific health benefit plan. Used in population health and utilization management reporting to analyze the clinical complexity and care patterns of members enrolled under a given benefit plan.

plan service datepln_svc_dt

The date on which a healthcare service was rendered under a specific benefit plan structure, captured in enrollment, claims, and EHR systems. Data engineers use this field to align services with active coverage periods, validate plan eligibility, and support accurate adjudication and benefit utilization reporting.

policy adjustment amountpol_adj_amt

Records the dollar amount applied to modify a claim payment under a specific insurance policy, capturing contractual write-offs, policy-level benefit reductions, or correction entries made during adjudication based on the terms and conditions of that coverage agreement.

policy claim datepol_clm_dt

Captures the date a claim was submitted under a specific insurance policy for adjudication review. Used in insurance operations to enforce policy-specific timely filing rules, track claim volumes by policy, and support actuarial and compliance reporting functions.

PreviousPage 108 of 178Next