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 active indicatorappr_actv_ind

Binary flag indicating whether a prior authorization or service approval record is currently active within the utilization management system. Active approvals permit claim adjudication against authorized services. Inactive records may reflect expired, voided, or superseded authorizations.

approval active statusappr_actv_sts

Categorical status value describing the current activity state of a prior authorization or service approval, such as Active, Inactive, Expired, or Suspended. Used in utilization management workflows to determine whether an authorization remains valid for claim processing and service delivery.

approval addressappr_addr

The physical location associated with a prior authorization or permission grant record in utilization management and claims systems. Stored as a structured or free-text field in EHR and payer platforms; used to validate provider or facility eligibility during approval workflow processing and audit trail reconciliation.

approval ageappr_age

The age of the member or patient at the time a prior authorization or service approval was requested or granted. Used in utilization management to apply age-based medical necessity criteria, benefit eligibility rules, and clinical guidelines during the authorization review process.

approval allowed amountappr_alwd_amt

The maximum dollar amount a health plan will reimburse for services covered under a prior authorization. Establishes the financial ceiling for claim payments associated with the approved services, used during claims adjudication to validate billed charges against authorized reimbursement limits.

approval amountappr_amt

The authorized monetary value associated with a prior authorization or permission grant in utilization management and claims adjudication systems. Stored as a numeric field in payer and EHR platforms; used to validate claim payments against approved thresholds, trigger overpayment reviews, and support financial reconciliation in healthcare billing workflows.

approval approval statusappr_appr_sts

The authorization decision outcome for a prior authorization request, indicating whether services have been approved, denied, pended, or partially approved by the utilization management team. Drives downstream claim adjudication and member and provider notification workflows.

approval approved byappr_appr_by

The identifier or name of the clinical reviewer, medical director, or automated rule set that granted the prior authorization decision. Captured for audit trail purposes in utilization management systems, supporting compliance reviews, appeals processes, and regulatory reporting requirements.

approval arrival timeappr_arrv_tm

The time at which a prior authorization request was received by the utilization management system or review team. Used to calculate turnaround time compliance against regulatory and contractual standards governing how quickly health plans must render authorization decisions.

approval arrived dateappr_arrv_dt

The calendar date on which a prior authorization request was received by the health plan's utilization management department. Used to initiate regulatory turnaround time tracking, prioritize review queues, and report compliance with state and federal authorization response mandates.

approval assessmentappr_asmt

The clinical evaluation narrative or structured findings documented by a utilization management reviewer when determining medical necessity for a prior authorization request. May include clinical criteria rationale, diagnosis context, and supporting evidence used to render the authorization decision.

approval balanceappr_bal

The remaining authorized dollar amount or service units outstanding on a prior authorization or permission grant in utilization management systems. Tracked as a numeric field in payer and claims platforms; used to enforce benefit limits, prevent over-utilization, and support real-time eligibility verification during claims adjudication and provider billing workflows.

approval billed amountappr_bill_amt

The total dollar amount submitted by a provider for services covered under a prior authorization. Compared against the approval allowed amount during claims adjudication to identify overbilling, calculate member cost-sharing, and apply contractual adjustments within the health plan payment process.

approval birth dateappr_birth_dt

The date of birth associated with a member or patient on a prior authorization or permission grant record in payer and utilization management systems. Used as a key demographic validation field to match authorization requests against member enrollment data, confirm eligibility, and prevent fraud in claims adjudication pipelines.

approval blood pressureappr_bp

The systolic and diastolic blood pressure reading documented in connection with a prior authorization request, typically for cardiovascular, renal, or chronic condition services. Serves as clinical supporting evidence for medical necessity determinations within the utilization management review process.

approval cancelled dateappr_cncl_dt

The calendar date on which a prior authorization or service approval was formally cancelled before the authorized service period expired. Used in utilization management to update authorization validity, prevent erroneous claim payments, and maintain accurate authorization history records.

approval categoryappr_cat

The classification grouping assigned to a prior authorization or permission grant in utilization management and claims systems, such as inpatient, outpatient, or specialty drug. Used in payer and EHR platforms to route approval workflows, apply benefit rules, and segment authorization data for reporting and medical policy compliance analytics.

approval charge amountappr_chrg_amt

The gross charge amount associated with services covered under a prior authorization, representing the provider's standard fee before contractual adjustments or plan allowances are applied. Used during claims adjudication to validate that billed services align with the scope of the granted authorization.

approval chief complaintappr_cc

The primary symptom, condition, or clinical concern reported by the member or treating provider that prompted a prior authorization request. Captured in the utilization management record to support medical necessity review and ensure the requested services align with the documented clinical indication.

approval childappr_chld

A subordinate authorization record linked to a parent prior authorization in hierarchical utilization management and claims systems. Represents dependent service approvals, such as individual procedure line items under a broader admission approval; used in payer platforms to enforce tiered benefit rules and maintain approval lineage for audit and adjudication workflows.

PreviousPage 23 of 325Next