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 countappr_cnt

The total number of approval events or authorization instances recorded for a member, provider, or service within a defined period. Used in utilization management systems, prior authorization platforms, and payer analytics to monitor approval frequency and identify outliers or trends.

approval countryappr_ctry

The country associated with the service location or member address linked to a prior authorization record. Used in utilization management to apply international benefit rules, coordinate coverage for services rendered abroad, and support global member programs administered by the health plan.

approval created byappr_crtd_by

The user identifier of the staff member, clinician, or automated system process that initially created the prior authorization record in the utilization management system. Maintained for audit trail integrity, workflow accountability, and compliance with regulatory documentation standards.

approval created dateappr_crtd_dt

The timestamp indicating when an authorization or approval record was first created in the system of record. Critical for audit trails in prior authorization platforms, EHR workflow engines, and payer utilization management systems to establish processing timelines and regulatory compliance.

approval created timeappr_crtd_tm

The timestamp recording when a prior authorization record was first created in the utilization management system. Used to establish the official start of regulatory turnaround time tracking and to support audit trails, workflow prioritization, and compliance reporting for authorization processing standards.

approval creatinineappr_cr

The serum creatinine lab value recorded at the time of a prior authorization or service approval request. Used in utilization management to document kidney function and support clinical criteria evaluation for procedures, medications, or specialty referrals requiring renal health evidence.

approval dateappr_dt

The calendar date on which a prior authorization, referral, or clinical approval decision was formally granted by a payer or utilization review entity. Stored in prior authorization systems, EHR referral modules, and claims platforms to validate service authorization timing.

approval datetimeappr_dttm

The combined date and timestamp capturing the exact moment an authorization or approval decision was recorded in the system. Used in prior authorization platforms, EHR audit logs, and payer adjudication systems to support time-sensitive compliance reporting and SLA tracking.

approval dea numberappr_dea_nbr

The Drug Enforcement Administration registration number of the prescribing or ordering clinician associated with a prior authorization or controlled substance approval. Used to verify prescriber credentials and regulatory compliance when approving controlled medication requests in pharmacy and utilization management workflows.

approval death dateappr_death_dt

The recorded date of member death associated with an active or pending approval or prior authorization record. Used in enrollment systems, payer platforms, and care management databases to terminate active authorizations and trigger downstream eligibility and claims processing updates.

approval deleted dateappr_del_dt

The calendar date on which a prior authorization or service approval record was logically removed from the active dataset. Used in utilization management systems to maintain audit trails, support retroactive review, and track when approvals were voided, rescinded, or administratively purged from production records.

approval deleted indicatorappr_del_ind

A binary or coded flag that identifies whether a prior authorization or service approval record has been logically deleted from active processing. Used in utilization management and claims adjudication systems to exclude voided approvals from eligibility checks while retaining the record for audit and compliance purposes.

approval descriptionappr_desc

Free-text or coded narrative explaining the scope, conditions, or rationale of a prior authorization or approval decision. Captured in utilization management systems, EHR authorization modules, and payer portals to communicate coverage determinations to providers and care coordinators.

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.

PreviousPage 24 of 320Next