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

location paid dateloc_pd_dt

The date on which payment was issued or posted for services associated with a specific healthcare service location. Used in revenue cycle management and claims processing systems to track reimbursement timelines, monitor payment cycles, and reconcile accounts receivable at the facility level.

location parentloc_prnt

Foreign key or reference value in provider network and facility hierarchy tables that links a physical service site to its superior organizational entity, such as a parent clinic, hospital system, or health network. Supports rollup reporting and multi-site governance workflows.

location percentloc_pct

Proportional metric field in facility and provider analytics systems representing the percentage allocation or utilization of a physical service site, such as capacity usage, network share, or cost distribution across locations used in population health and financial reporting.

location periodloc_prd

Date range field in provider master and EHR facility systems defining the effective start and end dates during which a physical service site is active or associated with a network or contract. Used to validate location eligibility during claims adjudication and enrollment processing.

location phoneloc_ph

Telephone contact number stored in provider directory and EHR facility master systems for a physical service site. Used in member-facing communications, referral workflows, and provider data quality validation processes across health plan and care management platforms.

location planloc_pln

The documented care or operational plan associated with a specific service location, outlining treatment protocols, resource strategies, or facility management directives. Used in clinical documentation and facility planning systems to standardize care delivery approaches across defined service sites.

location policy numberloc_pol_nbr

The unique identifier assigned to an insurance or coverage policy linked to a specific service location. Used in claims processing and benefits administration systems to associate facility-level billing transactions with the correct payer contract, enabling accurate reimbursement and coverage verification.

location preferred nameloc_pref_nm

The commonly used or operationally preferred display name for a healthcare service site, which may differ from its formal legal name. Used in patient-facing portals, scheduling systems, and facility directories to present location information in a clear, recognizable format for patients and staff.

location previousloc_prev

The prior physical service site associated with a patient, provider, or claim record in EHR and claims systems. Tracks historical location transitions to support continuity of care analysis, network migration audits, and provider attribution workflows across enrollment and claims platforms.

location priceloc_prc

The defined charge or cost value associated with services, procedures, or resources at a specific healthcare facility. Used in chargemaster management, claims billing, and contract pricing systems to establish and report the financial rate tied to care delivery at a particular service location.

location primary indicatorloc_prim_ind

A flag or boolean value designating whether a specific site is the primary service location in a network of facilities. Used in member enrollment, provider directories, and claims routing systems to identify the principal care delivery site for patient attribution, billing, and administrative workflow prioritization.

location priorityloc_prty

The importance ranking assigned to a physical service site in EHR, claims, or provider network systems. Determines which facility is selected first during care routing, claims adjudication, or provider directory lookups when multiple locations are associated with a single entity or encounter record.

location pulseloc_pulse

The patient heart rate measurement recorded at a specific clinical service location as part of a vital signs assessment. Used in inpatient, emergency, and ambulatory care documentation systems to capture and associate cardiovascular observations with the site of care for clinical monitoring and reporting.

location quantityloc_qty

The count or volume metric associated with a physical service site in claims, pharmacy, or EHR systems. May represent the number of services rendered, beds available, dispensing units, or active providers at a facility, supporting capacity planning and utilization reporting across healthcare data pipelines.

location raceloc_race

The racial or ethnic demographic classification associated with patient populations served at a specific healthcare facility. Used in population health management, health equity reporting, and quality measurement programs to analyze disparities and monitor demographic trends across defined service locations.

location rangeloc_rng

The defined value span or geographic boundary limits associated with a physical service site in provider network, claims, or member enrollment systems. Used to establish service area boundaries, reimbursement thresholds, or operational parameters for facilities participating in managed care or ACO arrangements.

location rateloc_rt

The contracted or standard unit price value assigned to a physical service site in claims adjudication, fee schedule, or PBM systems. Reflects facility-specific reimbursement rates negotiated with payers or established by CMS, used during claims pricing, provider contracting, and cost benchmarking workflows.

location ratingloc_rtg

A scored or categorical assessment value assigned to a healthcare service location based on quality metrics, patient satisfaction surveys, or performance benchmarks. Used in network management, value-based care programs, and provider directory systems to evaluate and compare facility performance across a health network.

location ratioloc_ratio

A proportional value representing a calculated relationship between two measured quantities at a specific service location, such as staff-to-patient ratios or resource utilization rates. Used in operational analytics and capacity management systems to monitor efficiency and compliance with regulatory staffing standards at the facility level.

location reasonloc_rsn

The coded or free-text explanation associated with a physical service site record in EHR, claims, or provider directory systems. Captures why a location was selected, changed, flagged, or terminated, supporting audit trails, network adequacy reviews, and claims adjudication exception handling processes.

PreviousPage 144 of 325Next