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,390 operations terms

approval revisionappr_rev

Sequential version number identifying updates or amendments made to a prior authorization or service approval record after initial submission. Tracks the iteration history of an authorization request, enabling audit trails and differentiating the current approved version from prior superseded versions.

approval riskappr_rsk

Assessed risk level assigned to a member or clinical scenario in the context of a prior authorization or service approval request. Used by utilization management clinicians to stratify cases by clinical urgency or complexity and route high-risk approvals for expedited or peer-to-peer review.

approval routeappr_rte

Medication administration pathway specified within a prior authorization or service approval request, such as oral, intravenous, or subcutaneous. Required for pharmacy and specialty drug authorizations to confirm the requested route aligns with clinical guidelines and formulary coverage criteria.

approval scheduled dateappr_sched_dt

Calendar date on which the authorized service, procedure, or treatment is planned to be performed following prior authorization approval. Used to validate that services are rendered within the approved authorization window and to coordinate scheduling between health plans, members, and treating providers.

approval scheduled timeappr_sched_tm

Specific time of day at which an authorized service or procedure is planned to occur following prior authorization approval. Used in utilization management and care coordination workflows to confirm service delivery timing aligns with authorization parameters and facility scheduling requirements.

approval scoreappr_scr

The calculated rating or numeric value assigned to a prior authorization or permission grant during clinical or automated review in utilization management platforms. Used in predictive analytics and decision support systems to quantify clinical appropriateness and prioritize authorization reviews in payer systems.

approval sequenceappr_seq

The ordering number defining the processing position of a prior authorization or permission grant within a multi-step utilization management workflow. Used by data engineers to reconstruct authorization review histories, enforce step-therapy requirements, and sequence batch adjudication in payer systems.

approval severityappr_sev

The clinical condition seriousness level associated with a prior authorization or permission grant in utilization management and payer systems. Used to classify urgency of authorization requests, route cases for expedited peer review, and support risk stratification analytics in care management platforms.

approval sexappr_sex

Biological sex classification of the member or patient associated with a prior authorization or service approval request. Applied in utilization management to validate gender-specific clinical criteria, support medical necessity determinations, and enable equity reporting across health plan authorization decisions.

approval sourceappr_src

The originating system, channel, or entity from which a prior authorization or permission grant was initiated, such as a provider portal, EDI transaction, or phone submission in payer and EHR platforms. Used by data engineers to audit authorization intake workflows and measure channel-specific approval rates.

approval start dateappr_start_dt

The beginning date marking when a prior authorization or permission grant becomes effective in payer, EHR, and utilization management systems. Used during claims adjudication to validate that service dates fall within the authorized coverage window and to calculate authorization duration for compliance reporting.

approval start timeappr_start_tm

Specific time at which an authorized service, procedure, or clinical encounter begins, as recorded in the prior authorization or service approval record. Used to confirm service delivery falls within approved parameters and to calculate duration for time-sensitive authorizations such as home health or infusion therapy.

approval stateappr_st

U.S. state or territory associated with a prior authorization or service approval request, typically reflecting the member's state of residence or the location where services will be rendered. Used to apply state-specific coverage rules, mandates, and regulatory review timeframe requirements to the authorization.

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.

PreviousPage 28 of 320Next