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

authorization master identifierauth_mstr_id

Stores the enterprise-level master person or entity identifier linked to a prior authorization record, enabling consistent identification across multiple health plan systems. Used in utilization management data integration to reconcile authorization records across claims, enrollment, and clinical platforms.

authorization maximumauth_max

Defines the upper limit of approved units, visits, days, or dollar amounts permitted under a prior authorization. Used in utilization management and claims adjudication to enforce approval boundaries and deny claims that exceed the quantity or value approved during the pre-authorization review process.

authorization middle nameauth_mid_nm

Captures the middle name or initial of the member associated with a prior authorization request. Used in utilization management systems to disambiguate members with similar first and last names, ensuring accurate matching to enrollment records and preventing authorization assignment errors.

authorization minimumauth_min

Defines the lower threshold of units, visits, days, or dollar amounts required to satisfy a prior authorization requirement. Used in utilization management workflows to establish baseline service expectations and flag claims that fall below the clinically approved service quantity during adjudication.

authorization mobileauth_mob

Records the mobile phone number of the member or contact person associated with a prior authorization request. Used by utilization management staff to communicate authorization decisions, request additional clinical documentation, and send real-time status notifications directly to the member or care coordinator.

authorization modified byauth_mod_by

Identifies the user ID or system account responsible for the most recent update to a prior authorization record. Used in utilization management audit trails to track accountability, support compliance reviews, and investigate changes to authorization decisions or clinical criteria applied during review.

authorization modified dateauth_mod_dt

The timestamp recording the most recent update to a prior authorization record in payer, EHR, and utilization management systems, including changes to status, approved units, or clinical criteria. Used by data engineers to implement incremental data loads, track authorization lifecycle changes, and support audit trail requirements in compliance and claims analytics pipelines.

authorization modified timeauth_mod_tm

Records the exact timestamp when a prior authorization record was last updated in the utilization management system. Used in audit logging, workflow tracking, and compliance reporting to document when authorization decisions, clinical criteria, or approval parameters were changed and by which process.

authorization nameauth_nm

A human-readable display label assigned to a prior authorization type or record in payer, EHR, and utilization management systems, often corresponding to a service category or program name. Used by data engineers to populate authorization reference tables, support user-facing reporting interfaces, and map authorization records to clinical service taxonomies in analytics pipelines.

authorization numberauth_nbr

Unique alphanumeric business identifier assigned to a prior authorization request, used for cross-system referencing between payer UM platforms, provider EHR systems, pharmacy PBM adjudication engines, and claims processing workflows. Required on 837 transactions for authorization validation.

authorization onset dateauth_onset_dt

Captures the date when the member's symptoms or medical condition first began, as reported on the prior authorization request. Used by clinical reviewers in utilization management to assess medical necessity, determine appropriate level of care, and evaluate whether the requested service aligns with the condition timeline.

authorization oxygen saturationauth_o2sat

The blood oxygen level for a service pre-approval. 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 authorization management and reporting.

authorization paid amountauth_pd_amt

Records the actual dollar amount paid against a prior authorization after claims adjudication is complete. Used in utilization management and financial reporting to track spend against approved authorization limits, monitor budget consumption, and reconcile payments with the approved authorization value.

authorization paid dateauth_pd_dt

Records the date on which payment was issued for services rendered under a prior authorization. Used in utilization management financial reconciliation to confirm that approved services were paid within contractual timelines and to match remittance data against the original authorization approval.

authorization parentauth_prnt

Foreign key reference linking a child authorization record to its originating parent authorization in UM systems that support hierarchical approval structures, such as episode-of-care groupings, multi-service approvals, or amendment chains tracked within payer adjudication platforms.

authorization payment amountauth_pmt_amt

Captures the transaction dollar value associated with a payment linked to a prior authorization. Used in utilization management and claims financial workflows to track cumulative spend against authorized service limits, supporting cost monitoring and ensuring payments do not exceed approved authorization thresholds.

authorization payment statusauth_pmt_sts

Indicates the current payment processing state for services rendered under a prior authorization, such as pending, paid, or denied. Used in utilization management and claims adjudication workflows to monitor financial resolution of approved services and identify authorizations with outstanding or rejected payment transactions.

authorization percentageauth_pct

Numeric percentage value associated with a prior authorization, representing partial approval thresholds, benefit coverage rates, or cost-sharing splits applied during UM adjudication in payer systems, PBM platforms, and managed care authorization workflows for financial calculations.

authorization periodauth_prd

Defined date range during which an approved prior authorization remains clinically and administratively valid within payer UM systems, EHR platforms, and claims adjudication engines. Governs service eligibility windows and is validated against claim service dates on 837 transactions.

authorization phoneauth_ph

Telephone contact number recorded on a prior authorization record in UM platforms, representing the provider office, referring facility, or payer UM department contact used for real-time authorization inquiries, peer-to-peer review scheduling, and outbound notification workflows.

PreviousPage 18 of 178Next