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 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.

approval cityappr_city

The city associated with the location where authorized services are to be rendered, or the member's city of residence linked to a prior authorization record. Used in utilization management for network adequacy validation, geographic benefit rule application, and service location verification.

approval classappr_cls

The classification tier assigned to a prior authorization or permission grant in utilization management systems, indicating service level such as urgent, routine, or emergent. Used in payer and EHR platforms to determine review turnaround time requirements, apply medical policy rules, and segment authorization records for regulatory compliance reporting.

approval codeappr_cd

A standardized alphanumeric value assigned to a prior authorization or permission grant in payer and claims adjudication systems to confirm service approval. Used in EHR, pharmacy, and clearinghouse platforms to validate transaction eligibility, cross-reference authorization records during claim submission, and support audit trail documentation in utilization management workflows.

approval commentappr_cmt

A free-text notation field attached to a prior authorization or permission grant record in utilization management and payer systems. Captures reviewer notes, clinical rationale, denial reasons, or override justifications; used in EHR and claims platforms for audit documentation, appeal processing, and quality review workflows in authorization management pipelines.

approval completed dateappr_cmpl_dt

The calendar date on which all services authorized under a prior authorization were rendered and the authorization was fulfilled. Used in utilization management reporting to track authorization utilization rates, measure service completion timelines, and close authorization records in the system.

approval confidential indicatorappr_conf_ind

Flag designating that a prior authorization record contains sensitive health information requiring restricted access, such as behavioral health, substance use disorder, or HIV-related services. Controls visibility within utilization management systems to comply with 42 CFR Part 2 and applicable state privacy laws.

approval contactappr_cntct

The individual or role designated as the communication point during a prior authorization or clinical approval workflow. Captured in prior authorization management systems, EHR referral modules, and utilization management platforms to coordinate between providers, payers, and members.

PreviousPage 23 of 320Next