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

precertification unitprecert_unt

Measurement unit defining the quantity metric for an approved pre-service authorization, such as days, visits, doses, or procedures. Used in payer and utilization management systems to specify authorized service quantities, enforce benefit limits, and validate claims submissions against approved units in EHR and claims adjudication workflows.

precertification updated dateprecert_upd_dt

The last change date for a pre-service authorization. Used to track temporal information related to precertification updated 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 urgencyprecert_urg

The time sensitivity level 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 valueprecert_val

Specific measured data point associated with a pre-service authorization, representing a clinical, financial, or administrative quantity such as authorized dollar amount, dosage, or service count. Used in payer and EHR systems to capture discrete authorization parameters that drive claims adjudication logic and utilization management decisions.

precertification versionprecert_ver

The record version number 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 zipprecert_zip

The postal code 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.

problem addressprob_addr

The physical location text linked to an active health condition or problem list entry in EHR systems. Identifies the care site or facility where the clinical problem was documented or is being managed, supporting longitudinal care tracking, referral workflows, and population health analytics.

problem approval statusprob_appr_sts

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

problem charge amountprob_chrg_amt

The service charge value for a active health condition. Used to capture financial data associated with problem transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for problem management and reporting.

problem effective dateprob_eff_dt

The date on which an active health condition officially began contributing to a patient's clinical record in EHR or care management systems. Used by data engineers to establish condition onset timelines, validate chronic disease eligibility windows, and support HEDIS and Stars quality measure date logic.

problem medical record numberprob_mrn

The patient medical record number for a active health condition. Used as a unique reference to identify and track the problem across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for problem management and reporting.

problem scheduled dateprob_sched_dt

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

problem scheduled timeprob_sched_tm

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

problem street addressprob_st_addr

The street location for a active health condition. 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 problem management and reporting.

problem unitprob_unt

The standardized measurement unit associated with a quantifiable active health condition in EHR clinical data systems, such as mg/dL for glucose or mmHg for blood pressure. Ensures dimensional consistency when aggregating or comparing problem-level clinical observations across patient records and data sources.

product addressprod_addr

The physical or mailing address associated with a pharmaceutical product manufacturer, distributor, or dispensing entity within pharmacy, PBM, or supply chain data systems. Used by data engineers to support regulatory reporting, drug sourcing validation, and provider-pharmacy relationship mapping in master data management workflows.

product effectiveprod_eff

The start date on which a pharmaceutical or healthcare product record, formulary status, or pricing contract becomes active within PBM, pharmacy, or health plan data systems. Critical for data engineers implementing slowly changing dimensions and point-in-time queries to ensure historically accurate drug benefit and cost reporting.

prosthetic addresspros_addr

The physical location text for a artificial body part. 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 prosthetic management and reporting.

prosthetic approval statuspros_appr_sts

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

prosthetic charge amountpros_chrg_amt

The service charge value for a artificial body part. Used to capture financial data associated with prosthetic transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for prosthetic management and reporting.

PreviousPage 174 of 320Next