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

policy street addresspol_st_addr

The street address on record for an insurance coverage policy, typically associated with the policyholder's primary residence or the insuring entity's administrative location. Used in insurance administration and claims processing systems for correspondence, regulatory filings, geographic risk assessment, and member identification.

policy unitpol_unt

The standardized measurement unit associated with an insurance coverage agreement in claims, PBM, and enrollment systems. Defines quantity dimensions for benefits, coverage limits, or authorized services within a policy, supporting accurate adjudication, utilization tracking, and benefit calculation.

precertification active indicatorprecert_actv_ind

A binary flag indicating whether a precertification request for a planned medical service or procedure is currently active within the utilization management system. Used in prior authorization workflows to quickly identify open or valid precertifications, support claims adjudication, and prevent payment of unauthorized services.

precertification active statusprecert_actv_sts

The current activity status of a precertification request submitted for a planned medical service or procedure. Indicates whether the authorization is pending review, approved, denied, expired, or withdrawn. Used in utilization management systems to track the lifecycle of prior authorization decisions and support claims adjudication workflows.

precertification addressprecert_addr

The physical location associated with a pre-service authorization request, including facility or provider address fields stored in utilization management and EHR systems. Used by payers and PBM platforms to route precertification requests, validate in-network status, and ensure accurate claims adjudication alignment.

precertification ageprecert_age

The age of the patient in years at the time a precertification request is submitted for a planned medical service or procedure. Used in utilization management and clinical review workflows to apply age-specific medical necessity criteria, evaluate appropriateness of requested services, and support authorization decision documentation.

precertification allowed amountprecert_alwd_amt

The maximum dollar amount approved for reimbursement under a precertification authorization for a specific medical service or procedure. Established during the prior authorization review process and used in claims adjudication to determine payable amounts, preventing overpayment and ensuring reimbursement aligns with contracted rates and medical necessity determinations.

precertification amountprecert_amt

The monetary value tied to a pre-service authorization, representing approved cost thresholds for procedures or services within utilization management and claims systems. Payers and PBM platforms use this field to enforce financial limits, validate claim payments, and flag cost overruns during adjudication.

precertification approval statusprecert_appr_sts

The decision outcome status of a precertification request indicating whether the requested medical service or procedure has been approved, denied, partially approved, or pended for additional clinical review. Used in utilization management systems to drive downstream claims processing, member notification, and provider communication workflows.

precertification approved byprecert_appr_by

The identifier or name of the clinical reviewer, medical director, or automated system that granted approval for a precertification request. Used in utilization management audit trails to document accountability for prior authorization decisions, support regulatory compliance, and provide reference data for appeals and dispute resolution processes.

precertification arrival timeprecert_arrv_tm

The recorded time at which a patient arrives for a precertified medical service or procedure at the treating facility. Used in utilization management and care coordination systems to validate service delivery against approved precertification windows, support operational reporting, and reconcile authorized services with actual clinical encounter data.

precertification arrived dateprecert_arrv_dt

Records the date the patient physically arrived at the care facility for a precertification-linked service event. Used in utilization management workflows to validate that authorized services align with actual patient presentation timelines and appointment scheduling.

precertification assessmentprecert_asmt

Contains the clinical reviewer's narrative evaluation of medical necessity for a requested service during the precertification process. Captures diagnoses, treatment rationale, and clinical findings used by the utilization management team to approve, modify, or deny the prior authorization request.

precertification balanceprecert_bal

The remaining approved monetary value on a pre-service authorization after partial utilization, tracked in utilization management and claims adjudication systems. Payers use this field to determine remaining benefit availability, prevent overpayment, and reconcile approved versus paid amounts across EHR and claims platforms.

precertification billed amountprecert_bill_amt

Represents the total dollar amount submitted by the rendering provider on the precertification request for the proposed services. Used in utilization management and financial auditing to compare anticipated charges against approved authorization values and final claim amounts.

precertification birth dateprecert_birth_dt

The date of birth associated with the member or patient on a pre-service authorization request, stored in utilization management and payer systems. Used to verify member eligibility, confirm identity matching in EHR and enrollment platforms, and validate age-based coverage criteria during the precertification review process.

precertification blood pressureprecert_bp

The arterial pressure value for a pre-service authorization. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

precertification cancelled dateprecert_cncl_dt

Records the specific date on which an active precertification request was cancelled before completion or approval. Used in utilization management reporting to track authorization lifecycle events, identify trends in cancelled requests, and audit compliance with payer cancellation policies.

precertification categoryprecert_cat

The classification grouping assigned to a pre-service authorization request, such as inpatient, outpatient, or specialty service, within utilization management and payer systems. Used by data engineers to segment authorization workflows, apply categorical business rules, and support reporting across EHR and claims adjudication platforms.

precertification charge amountprecert_chrg_amt

Captures the expected service charge associated with the procedure or treatment requiring prior authorization. Used in utilization management workflows to assess financial appropriateness of requested services and support cost containment analysis across precertification transactions.

PreviousPage 171 of 325Next