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

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

A numeric or alphanumeric indicator tracking the iteration of a pre-service authorization record, incremented each time the authorization is amended or updated. Used to maintain a complete audit history of authorization changes and ensure downstream claims systems reference the most current approved version.

precertification zipprecert_zip

The five- or nine-digit postal code associated with the facility or address on a pre-service authorization request. Used to identify the geographic service area, validate in-network status of the rendering location, and support regional reporting on authorization volumes and approval patterns.

present on admission indicatorpoa_ind

A one-character code on inpatient claims indicating whether a diagnosis was present at the time of admission, required by Medicare and many state Medicaid programs to distinguish between pre-existing conditions and hospital-acquired complications. POA coding affects DRG assignment, hospital-acquired condition payment reductions, and quality reporting for conditions that carry different clinical significance depending on when they developed.

prior balance amountprior_bal_amt

The outstanding account balance owed by a patient from previous encounters before the current visit, used in patient financial counseling workflows and point-of-service collection processes to address existing balances alongside current visit financial responsibility. Prior balance amounts affect patient propensity-to-pay scoring and collection strategy assignment.

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 current review or authorization state of a documented patient health problem, indicating whether it has been clinically validated, approved for treatment planning, or is pending further evaluation. Used in EHR problem list workflows to manage care plan alignment and ensure active conditions meet documentation standards.

problem charge amountprob_chrg_amt

The billed or estimated charge associated with diagnosing or treating a documented patient health problem. Used in clinical and revenue cycle workflows to link problem list conditions to associated encounter costs, supporting cost-of-care analysis and population health financial modeling.

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 unique medical record number assigned to the patient whose active health problem is documented. Used to link the problem list entry to the patient's longitudinal clinical record across EHR encounters, ensuring accurate attribution of diagnoses and continuity of care documentation.

problem scheduled dateprob_sched_dt

The calendar date on which a clinical encounter or follow-up appointment is planned in relation to a documented patient health problem. Used in care management workflows to track whether scheduled interventions for active diagnoses are occurring as planned and to support chronic condition management programs.

problem scheduled timeprob_sched_tm

The specific time of day at which a clinical encounter or procedure related to a documented patient health problem is scheduled to occur. Used alongside the scheduled date in EHR care coordination workflows to manage appointment logistics and ensure timely follow-up for active diagnoses.

problem street addressprob_st_addr

The physical street address of the patient or care site associated with a documented health problem record. Used in population health and care management programs to support outreach, coordinate community-based services, and identify geographic patterns in the prevalence of specific diagnoses or chronic conditions.

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 full physical address associated with a prosthetic device record, such as the fitting facility, supplier, or patient location. Used in durable medical equipment (DME) claims and prosthetic management workflows to route orders, deliveries, and follow-up care coordination.

prosthetic approval statuspros_appr_sts

Indicates the current authorization state of a prosthetic device request, such as pending, approved, denied, or under review. Used in DME prior authorization workflows to track payer decisions and ensure coverage confirmation before device fabrication or delivery to the patient.

prosthetic charge amountpros_chrg_amt

The billed dollar amount associated with a prosthetic device service, including fabrication, fitting, or adjustment. Captured in DME claims and financial systems to support reimbursement processing, cost analysis, and reconciliation against contracted payer rates for artificial limbs or body parts.

prosthetic effective datepros_eff_dt

The date on which a prosthetic device authorization, coverage, or service record becomes active. Used in DME billing and member benefit systems to establish the valid coverage window, ensuring claims submitted fall within the approved period for the prescribed prosthetic device.

PreviousPage 178 of 325Next