mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

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 engineers & architects.

Back to Glossary

Domain

Operations

Scheduling, facilities, departments, workflows, and staff

6,387 operations terms

policy effective datepol_eff_dt

The date on which an insurance policy's coverage becomes active and claims become eligible for adjudication, used across EHR, enrollment, claims, and PBM systems to validate member eligibility, apply correct benefit rules, and ensure accurate coordination of benefits processing.

policy scheduled datepol_sched_dt

The planned appointment date for a insurance coverage agreement. Used to track temporal information related to policy scheduled date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for policy management and reporting.

policy scheduled timepol_sched_tm

The planned time for a insurance coverage agreement. Used to track temporal information related to policy scheduled time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for policy management and reporting.

policy street addresspol_st_addr

The street location for a insurance coverage agreement. 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 policy management and reporting.

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

The current status flag for a pre-service authorization. Used to track the current state or condition of the precertification. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

precertification active statusprecert_actv_sts

The current activity state for a pre-service authorization. Used to track the current state or condition of the precertification. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

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 years lived 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 allowed amountprecert_alwd_amt

The maximum reimbursable value for a pre-service authorization. Used to capture financial data associated with precertification transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

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 authorization state for a pre-service authorization. Used to track the current state or condition of the precertification. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

precertification approved byprecert_appr_by

The authorizing user 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 arrival timeprecert_arrv_tm

The patient arrival time for a pre-service authorization. Used to track temporal information related to precertification arrival time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

precertification arrived dateprecert_arrv_dt

The patient arrival date for a pre-service authorization. Used to track temporal information related to precertification arrived date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

precertification assessmentprecert_asmt

The clinical evaluation text 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 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

The invoice total value for a pre-service authorization. Used to capture financial data associated with precertification transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for precertification management and reporting.

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.

PreviousPage 167 of 320Next