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 last nameloc_last_nm

The secondary or surname component of a physical service site name, used when facility names are parsed into structured name fields. Supports accurate sorting, searching, and display of location records in facility directories and healthcare administrative systems.

location legal nameloc_legal_nm

The officially registered legal name of a physical service site as recorded with state licensing boards, CMS, or corporate registration authorities. Used in credentialing, contracting, claims adjudication, and regulatory compliance reporting to ensure accurate facility identification.

location levelloc_lvl

Hierarchical position value in provider network and facility master data systems that classifies a physical service site within an organizational structure, such as enterprise, region, market, or clinic level, enabling rollup reporting and multi-site analytics.

location license numberloc_lic_nbr

The state or regulatory agency-issued license number assigned to a physical service site, such as a hospital license, ambulatory surgical center license, or laboratory certification. Used in credentialing, compliance verification, and payer enrollment workflows to validate facility operating authority.

location marital statusloc_mar_sts

An operational or administrative status attribute applied to a physical service site to indicate its current relationship or affiliation state, such as an independent, merged, or acquired facility. Used in network management and health system consolidation tracking to reflect site affiliation changes.

location master identifierloc_mstr_id

The enterprise master record identifier assigned to a physical service site within a master facility index or enterprise master patient index system. Used to uniquely and persistently identify a location across all integrated systems, supporting deduplication and data governance across health networks.

location maximumloc_max

The upper threshold or capacity limit associated with a physical service site, such as maximum patient census, bed capacity, or maximum reimbursable facility fee. Used in capacity planning, contract rate management, and utilization management to enforce site-level operational or financial ceilings.

location medical record numberloc_mrn

A site-specific patient identifier assigned by a particular facility or service location within a health system. Used to link patient records to the physical site where care was delivered, supporting longitudinal tracking across multi-site EHR and HIS environments.

location middle nameloc_mid_nm

The middle name or initial component of the full legal or registered name for a physical care delivery site. Used in facility directories, claims submissions, and administrative records to distinguish locations with similar primary names within a health system or network.

location minimumloc_min

The lower boundary value associated with a defined threshold or operational parameter at a specific service location. Used in clinical capacity planning, resource allocation workflows, and facility management systems to enforce minimum thresholds for staffing, inventory, or census levels.

location mobileloc_mob

The mobile or cellular contact number registered for a specific care delivery site or its designated on-call staff. Used in care coordination, emergency notifications, and facility directories to enable direct communication with location-specific personnel in clinical and administrative workflows.

location modified byloc_mod_by

The unique identifier of the user or system process responsible for the most recent update to a location record. Used in audit trail tracking within EHR and HIS platforms to maintain data integrity and accountability for changes to facility configuration or registration details.

location modified dateloc_mod_dt

Timestamp field in EHR and provider master data systems recording the most recent update to a physical service site record. Used in ETL audit processes and incremental data loads to detect and propagate changes to downstream claims, enrollment, and reporting systems.

location modified timeloc_mod_tm

The precise date and timestamp recording when a location record was last updated in the healthcare information system. Used in data governance, audit logging, and synchronization processes to track changes to facility attributes across EHR, HIS, and clinical data warehouse environments.

location nameloc_nm

Display label field in provider directories, EHR facility master tables, and claims systems that stores the human-readable name of a physical service site. Used for UI rendering, reporting, member-facing documents, and matching across health plan and provider data sources.

location noteloc_nt

Annotation or comment field in EHR and provider master data systems capturing supplemental information about a physical service site, such as temporary closures, operational exceptions, or special handling instructions used by care coordination and claims processing teams.

location numberloc_nbr

Numeric reference identifier assigned to a physical service site in provider master, claims, and facility management systems. Used to uniquely distinguish service locations within a network, enabling linkage across billing, scheduling, credentialing, and utilization reporting datasets.

location onset dateloc_onset_dt

The date on which a specific condition, event, or operational status began at a defined service location. Used in facility management and clinical reporting systems to track when location-level changes, service interruptions, or environmental health conditions were first identified or initiated.

location oxygen saturationloc_o2sat

The recorded peripheral blood oxygen saturation measurement captured at a specific clinical service location during patient assessment. Used in inpatient and emergency care settings to document vital sign observations tied to the site of care, supporting clinical decision-making and outcome reporting.

location paid amountloc_pd_amt

The total dollar value of payments received or processed for services rendered at a specific healthcare facility or service site. Used in claims adjudication and revenue cycle management systems to reconcile reimbursements against billed charges at the location level for financial reporting.

PreviousPage 143 of 325Next