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

adjustment timeadj_tm

The specific time of day at which a financial modification was applied or recorded within a claims or remittance processing system. Used in EHR billing platforms, payer adjudication engines, and clearinghouse transaction logs to provide precise temporal context for adjustment events, supporting audit trails and system reconciliation workflows.

adjustment timestampadj_ts

The combined date and time value recording when a financial modification was created, submitted, or processed within a healthcare data system. Used in EHR billing platforms, 835 EDI remittance workflows, and payer adjudication engines to establish audit trail records, support compliance reporting, and resolve payment timing disputes.

adjustment titleadj_ttl

The formal name or descriptive label assigned to a claims adjustment record, identifying its type or purpose such as coordination of benefits correction, duplicate claim reversal, or coding amendment. Used to categorize and report adjustment transactions within payer claims management and financial systems.

adjustment totaladj_tot

The aggregate monetary sum of all financial modifications applied to a claim, remittance advice, or payment batch. Used in 835 EDI transaction reconciliation, EHR revenue cycle reporting, and PBM payment processing to calculate net reimbursement after all adjustments, contractual discounts, and denial amounts have been applied and summed.

adjustment total countadj_tot_cnt

The total number of financial adjustment transactions processed within a given period on a claim or account. Used in claims reconciliation and payment integrity workflows to identify high-volume adjustment activity, detect anomalies, and support audit reporting across payers and providers.

adjustment typeadj_typ

A categorical classification defining the nature of a financial modification applied to a claim or remittance record, such as contractual obligation, patient responsibility, or coordination of benefits. Used in 835 EDI Group Codes, EHR billing systems, and PBM adjudication platforms to route adjustments to appropriate accounting and reporting categories.

adjustment updated dateadj_upd_dt

The most recent date on which a financial adjustment record was modified in the claims processing system. Used in payment reconciliation workflows to track when adjustments were last revised, supporting audit trails, dispute resolution, and downstream financial reporting accuracy.

adjustment urgencyadj_urg

A coded indicator representing the priority level assigned to a financial adjustment on a claim, such as routine, urgent, or expedited. Used in claims operations to triage and sequence adjustment processing, ensuring time-sensitive corrections to payments or denials are handled within required turnaround times.

adjustment valueadj_val

Numeric monetary or percentage amount applied to a claim during adjudication, representing contractual allowances, coordination of benefits, or payer-specific reductions. Used in claims processing, remittance reconciliation, and financial reporting within EHR and PBM billing systems.

adjustment versionadj_ver

A sequential version number assigned to each iteration of a financial adjustment record, used to track changes made during claims reprocessing or appeals. Supports audit and compliance workflows by identifying the most current adjustment and preserving a history of prior modifications.

adjustment zipadj_zip

The postal ZIP code associated with the location relevant to a financial adjustment, such as the billing address or service location. Used in claims processing and payment integrity workflows to validate geographic information, apply correct fee schedules, and support fraud detection analytics.

admission claim dateadmn_clm_dt

The date on which an inpatient admission claim was submitted to the payer for adjudication. Used in hospital billing and revenue cycle management to track claim submission timelines, measure payer turnaround times, and ensure compliance with timely filing requirements for inpatient encounters.

admission claim statusadmn_clm_sts

The current adjudication state of a claim associated with a hospital inpatient admission, such as received, pending, approved, denied, or appealed. Used in revenue cycle management to monitor claim progress, prioritize follow-up actions, and measure denial rates across inpatient admissions.

admission payment amountadmn_pmt_amt

The dollar amount paid by the payer for a hospital inpatient admission claim following adjudication. Used in revenue cycle and cost accounting workflows to reconcile expected versus actual reimbursement, analyze payment variances, and support financial reporting for inpatient services.

admission payment statusadmn_pmt_sts

The current processing state of a payment associated with a hospital inpatient admission claim, such as pending, issued, posted, or denied. Used in revenue cycle management to track remittance activity, identify delayed or missing payments, and support cash posting and reconciliation workflows.

advance directive adjustment amountadvdir_adj_amt

The dollar value of a financial adjustment applied to a claim or service line associated with documenting or reviewing a patient's advance directive. Used in claims processing to capture corrections to billed or paid amounts for advance care planning services under applicable billing codes.

advance directive claim dateadvdir_clm_dt

The date on which a claim for advance care planning services, including documentation or discussion of a patient's end-of-life care wishes, was submitted to the payer. Used in billing workflows to monitor timely filing compliance and track submission timelines for advance directive-related services.

advance directive claim statusadvdir_clm_sts

The current adjudication state of a claim submitted for advance care planning services, such as pending, approved, denied, or appealed. Used in revenue cycle workflows to track processing progress and identify claim issues related to billing for advance directive documentation and counseling services.

advance directive deductible amountadvdir_ded_amt

The portion of the allowed amount for advance care planning services applied to the patient's insurance deductible before payer coverage begins. Used in member cost-sharing calculations and explanation of benefits generation to accurately reflect patient financial responsibility for advance directive-related services.

advance directive payment amountadvdir_pmt_amt

The dollar amount paid by the payer for services related to documenting or discussing a patient's advance directive and end-of-life care preferences. Used in revenue cycle reporting to reconcile reimbursement for advance care planning services billed under codes such as CPT 99497 and 99498.

PreviousPage 11 of 178Next