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 preferred nameauth_pref_nm

Records the name by which the member associated with a prior authorization prefers to be addressed in communications. Used by utilization management staff and care coordinators to personalize outreach regarding authorization decisions, ensuring member-facing correspondence reflects individual identity preferences and improves engagement.

authorization priceauth_prc

The monetary amount approved for a specific service or procedure during the prior authorization process. Captures the negotiated or allowed cost ceiling used by payers to validate claims and ensure billing for authorized services does not exceed pre-approved amounts.

authorization primary indicatorauth_prim_ind

A flag identifying whether a prior authorization record is the primary approval on file when multiple authorizations exist for a member. Used in utilization management to determine which authorization takes precedence during claims adjudication and service coordination workflows.

authorization priorityauth_prty

Coded ranking value indicating the clinical urgency or processing priority of a prior authorization request within UM systems, such as routine, urgent, or expedited classifications. Drives SLA enforcement, queue routing logic, and turnaround time compliance tracking in payer adjudication platforms.

authorization pulseauth_pulse

The heart rate value 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 quantityauth_qty

Numeric value specifying the approved unit count for a prior authorization, such as number of visits, procedures, days of supply, or units of service permitted within a payer UM system. Compared against rendered quantities during claims adjudication to enforce approved service limits.

authorization raceauth_race

The racial or ethnic identity of the member associated with a prior authorization request. Captured to support health equity reporting, population health analytics, and regulatory compliance requirements under HEDIS and CMS mandates for demographic data collection in utilization management.

authorization rateauth_rt

Approved reimbursement or utilization rate associated with a prior authorization in payer UM and claims adjudication systems, representing contracted fee schedules, per-diem rates, or case rates. Referenced during claims pricing and reconciliation workflows in managed care and value-based payment models.

authorization ratingauth_rtg

A scored or tiered assessment assigned to a prior authorization request reflecting clinical urgency, medical necessity criteria met, or review complexity. Used by utilization management teams to prioritize authorization queues and benchmark review outcomes across service categories.

authorization ratioauth_ratio

A calculated proportional value comparing approved authorization quantities, units, or costs against requested amounts within a prior authorization. Used in utilization management analytics to evaluate approval rates, denial patterns, and resource allocation trends across service types.

authorization reasonauth_rsn

Reason descriptor for authorization within Provider processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

authorization received dateauth_rcvd_dt

The calendar date on which a prior authorization request was received by the payer or utilization management organization. Used to calculate turnaround time compliance, track regulatory response deadlines, and measure operational performance in authorization processing workflows.

authorization referenceauth_ref

External identifier or cross-system pointer linking a prior authorization record to related transactions such as referrals, claims, encounters, or provider contracts across EHR, payer UM, and PBM platforms. Supports data lineage tracking and interoperability between trading partner systems via EDI 278 transactions.

authorization resolution dateauth_resol_dt

The date on which a prior authorization request reached a final determination, including approval, denial, or withdrawal. Used in utilization management to measure review cycle time, monitor regulatory compliance for timely decision mandates, and close authorization records.

authorization respirationauth_resp

The breathing rate value 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 review systemsauth_ros

Documents the body systems evaluated during a clinical review of a prior authorization request. Captures findings from the review of systems assessment conducted by clinicians determining medical necessity, supporting documentation standards for inpatient, outpatient, and specialty service authorizations.

authorization revisionauth_rev

A version or iteration number indicating how many times a prior authorization record has been updated or amended after initial submission. Used in utilization management systems to maintain an audit trail of changes to authorization scope, dates, approved units, or clinical criteria.

authorization riskauth_rsk

A classification representing the clinical or financial risk level associated with a prior authorization request. Used by utilization management programs to stratify members for case management intervention, flag high-cost procedures, and apply appropriate medical necessity review criteria.

authorization routeauth_rte

The method of administration pathway specified in a prior authorization for medication or treatment delivery, such as oral, intravenous, or subcutaneous. Used to validate pharmacy and medical claims against approved administration methods and ensure clinical appropriateness criteria are met.

authorization scoreauth_scr

Calculated numeric rating generated by clinical decision support engines or UM platforms to quantify the appropriateness or medical necessity of a prior authorization request. Used in predictive analytics, auto-adjudication workflows, and population health systems to stratify and prioritize authorization reviews.

PreviousPage 19 of 178Next