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 paid dateappr_pd_dt

The date on which payment was issued against a prior authorization or service approval. Used in utilization management and claims adjudication systems to track payment timelines, support prompt payment compliance monitoring, and enable financial reconciliation between authorization approvals and remittance advice records.

approval parentappr_prnt

The hierarchical superior record linked to a prior authorization or permission grant, representing a parent approval in multi-level utilization management workflows. Used in EHR and payer systems to associate child authorizations with master approval records for reporting and adjudication.

approval percentageappr_pct

The ratio or percentage value associated with a prior authorization or permission grant, such as the proportion of a requested service quantity approved by a payer. Used in utilization management and claims systems to calculate partial approvals and coordinate benefit determinations.

approval periodappr_prd

The defined time span during which a prior authorization or permission grant remains valid in payer, EHR, and utilization management systems. Data engineers use this field to enforce authorization validity windows during claims adjudication and eligibility verification processes.

approval phoneappr_ph

The telephone number associated with a prior authorization or permission grant, typically referencing the payer's utilization management contact center. Stored in EHR and provider systems to support real-time authorization verification and appeals coordination workflows.

approval preferred nameappr_pref_nm

The chosen display name of the member, patient, or clinician associated with a prior authorization or service approval, which may differ from their legal name. Used in utilization management systems to personalize correspondence and portal communications while maintaining the legal name separately for regulatory and billing purposes.

approval priceappr_prc

The cost value associated with a prior authorization or service approval, reflecting the negotiated rate, billed charge, or estimated cost of the approved service. Used in utilization management and financial systems to support cost projection, benefit limit tracking, and authorization-to-claim reconciliation across the approval lifecycle.

approval primary indicatorappr_prim_ind

A flag identifying whether a prior authorization or service approval is the primary authorization record among multiple related approvals for a member or episode of care. Used in utilization management systems to designate the controlling authorization for coordination of benefits, claims adjudication sequencing, and reporting hierarchies.

approval priorityappr_prty

The importance ranking assigned to a prior authorization or permission grant request in utilization management and care management platforms. Used by data engineers to triage urgent authorization workflows, route expedited reviews, and support SLA reporting in payer and EHR systems.

approval pulseappr_pulse

Heart rate measurement recorded at the time of or associated with a prior authorization or service approval request. Captures the patient's pulse in beats per minute as clinical supporting documentation to justify medical necessity for the requested service or procedure.

approval quantityappr_qty

The count or volume of services, units, or items authorized within a prior authorization or permission grant in payer and utilization management systems. Used during pharmacy PBM dispensing validation and claims adjudication to enforce approved quantity limits against submitted encounters.

approval raceappr_race

Racial or ethnic classification of the member or patient associated with a prior authorization or service approval request. Used in utilization management analytics to monitor approval equity, identify potential disparities, and support compliance with federal healthcare anti-discrimination reporting requirements.

approval rateappr_rt

The reimbursement rate or unit price value tied to a prior authorization or permission grant in payer and claims adjudication systems. Used by data engineers to validate contracted fee schedules, reconcile remittance advice, and audit authorized payment amounts against processed claims.

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.

PreviousPage 27 of 320Next