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 ratingappr_rtg

Scored assessment value assigned to a prior authorization request indicating clinical appropriateness, urgency, or compliance with coverage criteria. Used by utilization management teams to prioritize, rank, and route approval decisions within managed care and health plan workflows.

approval ratioappr_ratio

Proportional metric comparing approved requests to total submitted prior authorization requests within a defined period, plan, or service category. Used in utilization management reporting to evaluate approval trends, assess medical necessity criteria effectiveness, and benchmark health plan performance.

approval reasonappr_rsn

The clinical or administrative explanation text documenting why a prior authorization or permission grant was approved in utilization management and payer systems. Captured as structured or free-text data, this field supports audit trails, regulatory compliance reporting, and denial prevention analytics.

approval received dateappr_rcvd_dt

Calendar date on which a prior authorization or service approval request was received by the health plan, utilization management team, or relevant review body. Used to calculate turnaround times, measure compliance with regulatory review deadlines, and track authorization workflow timelines.

approval referenceappr_ref

An external identifier or pointer linking a prior authorization or permission grant to a related transaction, such as a claim number, referral ID, or plan document in payer and EHR systems. Used by data engineers to cross-reference authorization records across adjudication and care management platforms.

approval resolution dateappr_resol_dt

Calendar date on which a prior authorization or service approval request reached a final determination, including approvals, denials, or withdrawals. Used in utilization management to measure decision turnaround, ensure regulatory compliance with timeliness standards, and close open authorization records.

approval respirationappr_resp

Respiratory rate measurement recorded as clinical supporting documentation associated with a prior authorization or service approval request. Captures breaths per minute to establish medical necessity, particularly for respiratory therapy, pulmonary services, or inpatient level-of-care authorization requests.

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.

PreviousPage 28 of 325Next