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

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.

PreviousPage 24 of 325Next