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 engineers & architects.

Back to Glossary

Domain

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

3,542 claims terms

adjustment medical record numberadj_mrn

The patient medical record number for a financial modification. Used as a unique reference to identify and track the adjustment across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment middle nameadj_mid_nm

The middle name or initial for a financial modification. Used to display and describe the adjustment in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment minimumadj_min

The lower limit value for a financial modification. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment mobileadj_mob

The mobile phone number for a financial modification. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment modified byadj_mod_by

The updating user identifier for a financial modification. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment modified dateadj_mod_dt

The timestamp recording the most recent update to a financial modification record in claims, EHR, or enrollment systems. Critical for audit trail maintenance, change data capture in ETL pipelines, and identifying late adjustments that affect period-close reporting in revenue cycle platforms.

adjustment modified timeadj_mod_tm

The record update time for a financial modification. Used to track temporal information related to adjustment modified time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment nameadj_nm

A descriptive label assigned to a financial modification type within payer, PBM, or provider billing systems. Used to categorize adjustments such as coordination of benefits, sequencing corrections, or contractual write-offs in claims reporting dashboards and revenue cycle management workflows.

adjustment noteadj_nt

Free-text or structured annotation attached to a financial modification record in claims, EHR, or PBM systems. Captures the clinical, administrative, or contractual rationale for the adjustment, supporting audit documentation, provider dispute resolution, and compliance review in revenue cycle platforms.

adjustment numberadj_nbr

A system-generated or manually assigned reference number uniquely identifying a financial modification within claims processing, PBM, or billing platforms. Used for cross-referencing adjustments in remittance advice, 835 transaction sets, and provider reconciliation reports across payer and EHR systems.

adjustment onset dateadj_onset_dt

The symptom start date for a financial modification. Used to track temporal information related to adjustment onset date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment oxygen saturationadj_o2sat

The blood oxygen level for a financial modification. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment paid amountadj_pd_amt

The payment received value for a financial modification. Used to capture financial data associated with adjustment transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment paid dateadj_pd_dt

The payment date for a financial modification. Used to track temporal information related to adjustment paid date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment parentadj_prnt

A relational field linking a financial modification record to its originating or higher-level transaction within claims, EHR, or PBM systems. Establishes parent-child hierarchies for nested adjustments, enabling accurate lineage tracking in adjudication engines and financial reconciliation pipelines.

adjustment payment amountadj_pmt_amt

The payment transaction value for a financial modification. Used to capture financial data associated with adjustment transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment payment statusadj_pmt_sts

The payment processing state for a financial modification. Used to capture financial data associated with adjustment transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for adjustment management and reporting.

adjustment percentageadj_pct

The numeric ratio applied to a claim amount or benefit value as part of a financial modification in payer, PBM, or provider systems. Used to calculate contractual discounts, coordination of benefits reductions, capitation rate changes, or penalty assessments within adjudication and payment calculation engines.

adjustment periodadj_prd

The defined time span during which a financial modification is applicable within claims, enrollment, or PBM systems. Governs retroactive billing corrections, benefit recalculations, and capitation reconciliations, aligning adjustment scope with contract terms and regulatory reporting windows in payer platforms.

adjustment phoneadj_ph

The telephone number associated with a financial modification record or responsible party in payer, provider billing, or revenue cycle systems. Used to facilitate outreach for adjustment disputes, claim correction follow-ups, and remittance inquiries within provider relations and claims operations workflows.

PreviousPage 8 of 178Next