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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

approval statusappr_sts

Tracks the current state of a prior authorization or claim approval within EHR, claims, or PBM systems. Common values include Pending, Approved, Denied, or Expired. Used in workflow routing and adjudication logic to determine next processing steps.

approval street addressappr_st_addr

Street-level address associated with a prior authorization or service approval request, identifying where services are to be rendered or the member's residence. Used to verify network adequacy, confirm facility eligibility, and apply location-specific coverage policies within utilization management workflows.

approval strengthappr_str

Drug concentration or dosage strength specified in a pharmacy or specialty medication prior authorization request, such as milligrams per tablet or milliliters per dose. Used to validate that the requested formulation aligns with clinical dosing guidelines and formulary-approved strength tiers.

approval subtotalappr_subtot

Partial monetary sum representing a subset of costs associated with a prior authorization or service approval request, such as approved units multiplied by unit cost before adjustments. Used in financial and utilization reporting to calculate expected claim liability and analyze partial approval cost impacts.

approval targetappr_tgt

Identifies the destination entity—such as a provider, facility, drug, or procedure code—to which a prior authorization or permission grant applies. Used in PBM and claims systems to link approvals to specific services or members during adjudication workflows.

approval taxonomy codeappr_tax_cd

Healthcare Provider Taxonomy Code associated with the rendering or requesting provider on a prior authorization or service approval request. Identifies the provider's clinical specialty to validate that the requested service aligns with the provider's scope of practice and applicable coverage criteria.

approval temperatureappr_temp

Body temperature measurement recorded as clinical supporting documentation within a prior authorization or service approval request. Captured in degrees Fahrenheit or Celsius to substantiate medical necessity, particularly for inpatient admissions, infectious disease treatments, or fever-related diagnostic authorization requests.

approval termination dateappr_term_dt

The date on which a prior authorization or service approval expires, ending the payer's permission for the authorized service. Used in utilization management systems to enforce approval windows and flag claims submitted after the authorized period ends.

approval timeappr_tm

Records the specific time of day a prior authorization or permission grant was approved within claims, PBM, or EHR systems. Used in audit trails and SLA reporting to measure turnaround times for authorization decisions against regulatory benchmarks.

approval timestampappr_ts

Captures the full date and time a prior authorization or claim approval decision was recorded in claims, PBM, or utilization management systems. Critical for audit compliance, SLA tracking, and determining authorization validity windows within adjudication pipelines.

approval titleappr_ttl

The formal name or label assigned to a prior authorization record, identifying the specific service, procedure, or treatment approved by the payer. Used in utilization management workflows to distinguish authorization types and support member care coordination.

approval totalappr_tot

Represents the aggregated monetary or unit sum associated with an approved prior authorization or claim permission in PBM or claims systems. Used to enforce benefit limits, track authorized spend, and reconcile approved quantities against actual utilization during claims adjudication.

approval total countappr_tot_cnt

The total number of approved service units, visits, or occurrences granted under a prior authorization. Used in utilization management to enforce limits on approved services and track consumption against authorized quantities in claims adjudication.

approval typeappr_typ

Classifies the category of a prior authorization or permission grant in claims, PBM, or utilization management systems. Common values include prior authorization, concurrent review, retrospective review, or formulary exception, driving downstream adjudication and workflow routing logic.

approval unitappr_unt

Specifies the measurement unit—such as days, doses, visits, or units of service—associated with an approved prior authorization in PBM or utilization management systems. Used to enforce quantity limits and validate claim submissions against authorized service volumes.

approval updated dateappr_upd_dt

The most recent date on which a prior authorization record was modified, such as when a payer amended approved units, extended an end date, or changed authorization status. Used to audit authorization changes and maintain accurate utilization management records.

approval urgencyappr_urg

The time sensitivity classification assigned to a prior authorization request, such as routine, urgent, or emergent. Payers use this value to determine review turnaround time requirements under utilization management guidelines and regulatory compliance standards.

approval valueappr_val

Represents the specific quantitative or coded data point tied to a prior authorization or permission grant in claims or PBM systems, such as an approved dollar amount or unit count. Used in adjudication to validate claims against approved thresholds and enforce benefit limits.

approval versionappr_ver

The sequential version number of a prior authorization record, incremented each time the authorization is amended or updated by the payer. Used in utilization management systems to maintain a full audit trail of authorization changes and support claims adjudication accuracy.

approval zipappr_zip

The postal code associated with the service location or rendering facility specified in a prior authorization. Used in utilization management and claims processing to validate that services were rendered at the authorized location and support geographic reporting.

PreviousPage 29 of 325Next