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

policy claim statuspol_clm_sts

Indicates the current adjudication state of a claim filed under a specific insurance policy, including statuses such as submitted, under review, approved, denied, or appealed. Supports insurance operations teams in managing claim lifecycles and policy-level performance metrics.

policy deductible amountpol_ded_amt

Records the dollar amount credited toward the deductible defined within a specific insurance policy for a given claim. Reflects the member's out-of-pocket obligation as specified by policy terms before the insurer's coverage share applies to eligible medical expenses.

policy payment amountpol_pmt_amt

The dollar amount remitted for an insurance policy premium or coverage agreement. Captured in billing and enrollment systems to reconcile premium payments against policy obligations, track payment history, and support financial reporting across member accounts.

policy payment statuspol_pmt_sts

Indicates the current processing state of a payment transaction against an insurance policy, such as pending, posted, reversed, or failed. Used in premium billing systems to manage policy lapse risk, reconcile accounts receivable, and trigger member notifications for delinquent accounts.

policy review systemspol_ros

Documents the organ systems reviewed during a clinical assessment associated with an insurance policy event, such as a life or disability underwriting exam. Captures findings across cardiovascular, respiratory, musculoskeletal, and other systems to support risk evaluation and policy issuance decisions.

policy service datepol_svc_dt

The specific calendar date on which a covered healthcare service was rendered under an active insurance policy. Used in EHR, claims, and PBM systems to validate coverage eligibility at the time of service, enforce policy period constraints, and support accurate claim adjudication and revenue cycle processing.

practitioner claim dateprac_clm_dt

The date on which a professional claim was submitted by or on behalf of a licensed practitioner for services rendered to a patient. Used in claims processing systems to calculate timely filing compliance, adjudication turnaround, and provider reimbursement cycle metrics.

practitioner claim statusprac_clm_sts

The current adjudication state of a professional claim submitted by a licensed practitioner, such as received, pended, adjudicated, denied, or appealed. Used in claims management workflows to prioritize follow-up, track resolution timelines, and report on practitioner-level claim outcomes.

practitioner payment amountprac_pmt_amt

The reimbursement amount issued to a licensed practitioner for professional services rendered, as determined after claim adjudication and application of contractual adjustments, member cost-sharing, and coordination of benefits. Used in remittance processing and provider payment reconciliation.

practitioner payment statusprac_pmt_sts

Indicates the current state of a reimbursement transaction issued to a licensed practitioner, such as pending, issued, voided, or returned. Used in accounts payable and provider relations systems to confirm payment delivery, resolve discrepancies, and manage electronic remittance advice reconciliation.

precertification adjustment amountprecert_adj_amt

The dollar value of a financial modification applied to a precertification transaction, reflecting changes such as approved service quantity revisions, rate corrections, or benefit plan adjustments. Used in utilization management systems to align authorized amounts with final claims adjudication.

precertification claim dateprecert_clm_dt

The date a claim was submitted that references or requires a precertification authorization. Used in utilization management and claims processing systems to verify that services were rendered within approved authorization windows and to enforce timely filing rules tied to prior approval.

precertification claim statusprecert_clm_sts

The adjudication state of a claim linked to a prior authorization or precertification request, such as approved, denied, pended for auth verification, or appealed. Used to track whether claim payment aligns with the terms and scope of the precertification decision recorded in utilization management systems.

precertification deductible amountprecert_ded_amt

The portion of costs applied to a member's deductible accumulator for services that were subject to precertification. Captured in utilization management and benefits administration systems to ensure cost-sharing calculations reflect authorized service approvals and member plan year accumulators.

precertification payment amountprecert_pmt_amt

The dollar amount paid on a claim for services that required and received precertification approval. Used in utilization management and claims systems to confirm reimbursement aligns with authorized service scope and to audit payment accuracy against prior authorization terms and negotiated rates.

precertification payment statusprecert_pmt_sts

Indicates the processing state of a payment for services that required precertification, such as pending, issued, or denied. Used to reconcile payment outcomes against utilization management decisions and ensure that only appropriately authorized services receive reimbursement within payer claims systems.

precertification review systemsprecert_ros

Documents the body systems assessed during a clinical review conducted as part of the precertification or prior authorization process. Used by utilization management clinicians to evaluate medical necessity, applying criteria across relevant organ systems such as cardiac, neurological, or musculoskeletal to support authorization decisions.

precertification service dateprecert_svc_dt

The specific date on which the authorized clinical service, procedure, or treatment is scheduled or delivered. Used in payer, EHR, and claims systems to validate that services rendered fall within the approved authorization window, supporting accurate adjudication and utilization management reporting.

prescription claim daterx_clm_dt

The date on which a pharmacy claim was submitted for a dispensed medication. Used in pharmacy benefit management systems to enforce timely filing requirements, calculate days supply timelines, reconcile adjudication cycles, and support drug utilization reporting at the member and prescriber level.

prescription claim statusrx_clm_sts

The current adjudication state of a pharmacy claim for a dispensed medication, such as submitted, adjudicated, rejected, reversed, or reprocessed. Used in pharmacy benefit management systems to manage claim resolution workflows, track rejection reasons, and report on prescription claim outcomes by drug, member, or pharmacy.

PreviousPage 109 of 178Next