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

record claim statusrec_clm_sts

The current adjudication state of a claim linked to a specific patient health record, indicating whether processing is pending, completed, denied, or appealed. Used in revenue cycle and claims management systems to track billing outcomes and drive follow-up workflows.

record deductible amountrec_ded_amt

The portion of a claim associated with a patient health record that is applied toward the member's annual deductible before plan benefits take effect. Captured in claims adjudication systems to accurately calculate member cost-sharing liability and update accumulator balances.

record payment amountrec_pmt_amt

The total reimbursement amount paid by a payer for services associated with a specific patient health record or encounter claim. Captured in claims payment and revenue cycle systems to reconcile expected versus actual reimbursement and support financial reporting.

record payment statusrec_pmt_sts

The current payment processing state for a claim tied to a specific patient health record, indicating whether remittance has been issued, is pending, or has been denied. Used in revenue cycle management to drive payment reconciliation workflows and identify outstanding accounts receivable.

record review systemsrec_ros

Documents the organ and body systems reviewed during a clinical encounter as part of the history and physical documented in a patient health record. Used in EHR documentation to support evaluation and management coding, medical necessity determination, and clinical completeness auditing.

record service daterec_svc_dt

The date associated with a healthcare information document such as a clinical note, lab report, or imaging record in EHR and HIM systems. Data engineers rely on this field to sequence records chronologically, support release-of-information workflows, and align documentation with corresponding claim service dates.

reference claim statusref_clm_sts

A code or value indicating the current processing state of a reference or cross-referenced claim in a payers adjudication system. Reference claim status values indicate whether a related claim is pending, processed, denied, or paid. Used in coordination of benefits processing and claims investigation workflows to track relationships between primary and secondary claims.

referral adjustment amountref_adj_amt

Dollar amount applied to modify the original payment on a referral claim, reflecting contractual adjustments, coordination of benefits, or payer-specific payment rules. Captures the net difference between billed charges and allowed amounts after payer adjudication.

referral ageref_age

Patient's age in years at the time a referral was initiated or processed. Used in utilization management and care coordination analytics to assess age-appropriate specialist referral patterns, authorization requirements, and population health stratification across referral workflows.

referral allowed amountref_alwd_amt

Maximum dollar amount a payer will reimburse for services rendered under a specialist referral, based on contracted fee schedules or benefit plan limits. Determines the ceiling for claim payment after applying deductibles, copays, and coordination of benefits rules.

referral amountref_amt

Represents the monetary value associated with a specialist referral request, including authorized amounts or expected reimbursements within claims and utilization management systems. Used in care management and PBM platforms to track financial authorization limits and support referral cost analysis and reporting.

referral approved byref_appr_by

Identifier of the clinician, care manager, or utilization reviewer who granted authorization for a specialist referral. Captured in referral management systems to maintain an auditable approval chain for prior authorization compliance and claims adjudication validation.

referral arrival timeref_arrv_tm

Timestamp recording when a referred patient physically arrived at the receiving specialist's facility or clinic. Used in care coordination and access metrics to calculate referral-to-arrival intervals and measure timeliness of specialist care delivery following referral initiation.

referral arrived dateref_arrv_dt

Calendar date on which a referred patient presented at the receiving specialist's location for the referred service. Used in referral tracking and access-to-care reporting to measure elapsed time between referral authorization and actual patient appearance at the specialist site.

referral assessmentref_asmt

Free-text or structured clinical evaluation documented by the referring clinician summarizing the patient's condition, diagnostic findings, and clinical rationale supporting the referral. Communicates relevant medical context to the receiving specialist to inform evaluation and treatment planning.

referral balanceref_bal

Captures the remaining outstanding monetary amount on a specialist service referral after partial payments or utilization has been applied. Used in care management and claims systems to monitor authorized versus consumed referral funds, supporting financial reconciliation and utilization management reporting workflows.

referral billed amountref_bill_amt

Total gross charges submitted by the specialist or facility on a referral-associated claim before payer adjustments, contractual discounts, or benefit plan reductions are applied. Represents the provider's standard fee schedule amount for services rendered under the referral authorization.

referral birth dateref_birth_dt

Records the date of birth associated with the patient or member linked to a specialist referral request within care management and claims systems. Used to verify member eligibility, enforce age-based referral rules, and match referral records to enrollment data during data integration and validation processes.

referral blood pressureref_bp

Systolic and diastolic arterial pressure reading documented at the time of referral initiation or during the referred visit. Captured as a clinical vital sign to support specialist evaluation, triage prioritization, and longitudinal cardiovascular monitoring across the referral care episode.

referral cancelled dateref_cncl_dt

Calendar date on which a previously authorized or submitted referral was voided or withdrawn by the patient, referring clinician, or care coordinator. Used in referral workflow tracking to measure cancellation rates, identify access barriers, and manage outstanding authorization records.

PreviousPage 114 of 178Next