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 detailappr_dtl

Granular-level data associated with a specific authorization or approval record, including service codes, units authorized, and clinical criteria met. Stored in prior authorization platforms, payer adjudication systems, and EHR referral modules to support claims validation and provider communication.

approval due dateappr_due_dt

The deadline by which a prior authorization decision must be rendered per regulatory or contractual turnaround requirements. Used in utilization management workflows to trigger escalations, ensure compliance with state and federal review timeframes, and track pending approvals approaching required response deadlines.

approval durationappr_dur

The total length of time for which a prior authorization or service approval remains clinically and administratively valid. Used in utilization management to define the authorized service window, control claims adjudication eligibility, and determine when reauthorization is required for ongoing or recurring treatments.

approval effective dateappr_eff_dt

The date on which an authorization or approval becomes active and services may begin under the approved terms. Used in prior authorization systems, payer enrollment platforms, and EHR billing modules to validate claim service dates against authorized coverage windows and prevent improper payments.

approval emailappr_eml

The electronic mail address associated with the approving entity, reviewer, or contact within an authorization workflow. Captured in prior authorization management systems and payer portals to facilitate communication between utilization management teams, providers, and member services representatives.

approval end dateappr_end_dt

The date on which an authorization, referral, or approval record becomes inactive or the authorized service window closes. Used in prior authorization systems, payer adjudication engines, and EHR billing platforms to enforce coverage limits and flag claims submitted beyond the authorized period.

approval end timeappr_end_tm

The specific time of day at which a prior authorization or service approval expires or a time-sensitive approved service concludes. Used in utilization management and scheduling systems to enforce precise authorization boundaries for time-limited procedures, observation stays, or inpatient level-of-care approvals.

approval entered byappr_ent_by

The username or system identifier of the staff member or automated process that created or submitted a prior authorization or service approval record. Used in utilization management audit logs to establish accountability, support workflow tracing, and identify data entry sources for compliance and quality review purposes.

approval ethnicityappr_ethn

The self-reported or assigned ethnicity of the member associated with a prior authorization or service approval request. Used in utilization management analytics to monitor health equity, detect disparities in approval rates across demographic groups, and support population health reporting requirements.

approval expiration dateappr_exp_dt

The date after which a prior authorization or clinical approval is no longer valid for claim submission or service delivery. Referenced in payer adjudication systems, EHR authorization modules, and PBM platforms to deny claims submitted post-expiration and prompt reauthorization workflows.

approval external identifierappr_ext_id

A reference number assigned by an external system, trading partner, or delegated vendor to identify a prior authorization or service approval across organizational boundaries. Used to correlate approval records between health plan systems, provider portals, pharmacy benefit managers, and third-party utilization management platforms.

approval faxappr_fax

The facsimile number used to transmit prior authorization decisions, requests, or supporting clinical documentation between a health plan and a requesting facility or clinician. Used in utilization management workflows where electronic submission is unavailable and fax remains the designated communication channel for approval correspondence.

approval feeappr_fee

The administrative or clinical fee associated with processing or issuing a prior authorization or service approval. Used in utilization management and billing workflows to track costs tied to authorization transactions, delegated review arrangements, or external vendor fees charged for specialty approval determinations.

approval first nameappr_first_nm

The given name of the member or individual patient for whom a prior authorization or service approval has been requested or granted. Used in utilization management systems to support member identification, correspondence generation, and matching approval records to member enrollment and claims data.

approval flagappr_flg

A binary indicator field denoting whether a specific record, service, or transaction has received formal authorization or approval within the system. Used in EHR billing workflows, prior authorization platforms, and payer adjudication systems to route records for processing or additional review.

approval frequencyappr_freq

The authorized rate or schedule at which an approved service, medication, or procedure may be rendered within the approval period. Used in utilization management and claims adjudication to enforce quantity limits, prevent overbilling, and validate that submitted claims align with the frequency parameters defined in the authorization.

approval full nameappr_full_nm

The complete legal name of the member or patient associated with a prior authorization or service approval record. Used in utilization management systems for member identity verification, authorization correspondence, and reconciliation of approval records against enrollment, claims, and clinical data sources.

approval genderappr_gndr

The recorded gender of the member associated with a prior authorization or service approval request. Used in utilization management to apply gender-specific clinical criteria, ensure appropriate service authorization, and support health equity reporting on approval patterns across member demographic segments.

approval glucoseappr_gluc

The blood glucose lab value documented at the time of a prior authorization or service approval request. Used in utilization management to capture relevant clinical evidence supporting medical necessity determinations for diabetes-related treatments, medications, devices, or procedures requiring metabolic health documentation.

approval group numberappr_grp_nbr

The insurance group plan identifier associated with a member's coverage at the time a prior authorization or service approval is requested. Used in utilization management to route authorizations to the correct benefit plan, apply group-specific clinical criteria, and link approvals to the appropriate claims adjudication configuration.

PreviousPage 25 of 325Next