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 expirationloc_exp

The status indicating that a physical service site's active period, contract, or certification has lapsed in provider network, credentialing, or facility management systems. Triggers record inactivation workflows in EHR and payer platforms to prevent invalid claims processing.

location expiration dateloc_exp_dt

The specific date on which a physical service site's network participation, certification, or operational status expires in credentialing, provider directory, or claims systems. Used to enforce eligibility windows and trigger renewal or termination workflows in payer and EHR platforms.

location external identifierloc_ext_id

The unique identifier assigned to a physical service site by an external system such as a payer, clearinghouse, or health information exchange. Enables cross-system reconciliation of facility records across claims processing, credentialing, and referral management platforms.

location faxloc_fax

The facsimile telephone number associated with a physical service site or facility. Used in clinical workflows for transmitting referrals, prior authorization requests, medical records, and other documents between healthcare facilities, payers, and administrative offices.

location feeloc_fee

The service charge or facility fee associated with a physical service site. Used in revenue cycle management and claims processing to capture location-specific costs such as facility fees billed on institutional claims, supporting accurate reimbursement and contract rate validation.

location first nameloc_first_nm

The primary or first component of a facility or service site name as it appears in operational and administrative records. Used in healthcare information systems to display, search, and distinguish locations when the site name is stored across multiple name fields.

location flagloc_flg

A binary or categorical indicator assigned to a physical service site in EHR, claims, or provider directory systems to denote special status such as inactive, out-of-network, sanctioned, or rural designation. Drives routing logic, reimbursement rules, and eligibility determinations during claims adjudication.

location frequencyloc_freq

The operational frequency attribute associated with a physical service site, such as hours of operation cycles or scheduling cadence. Used in facility management and care coordination systems to define how often services are offered or how regularly a site operates.

location full nameloc_full_nm

The complete, concatenated name of a physical service site or healthcare facility, combining all name components into a single displayable value. Used in facility directories, claims submissions, member-facing portals, and provider network management systems for accurate site identification.

location genderloc_gndr

Designates whether a physical service site specializes in or restricts services by gender, such as a women's health clinic or gender-specific treatment program. Used in network management, care coordination, and member referral systems to match patients with appropriate facility resources.

location glucoseloc_gluc

Records glucose monitoring or testing capability status associated with a physical service site, such as an on-site lab or point-of-care testing availability. Used in facility capability tracking systems to support care coordination for diabetic or metabolic condition management programs.

location group numberloc_grp_nbr

A group-level identifier associated with a physical service site, linking the location to a specific network group, practice group, or administrative cluster within a health system or payer network. Used in claims processing, contracting, and network management workflows.

location hemoglobinloc_hgb

Indicates the hemoglobin testing or laboratory capability available at a physical service site. Used in facility capability and service inventory systems to identify locations equipped to perform blood-based diagnostics, supporting care coordination for anemia or chronic disease management.

location history present illnessloc_hpi

Documents the current clinical condition or operational narrative associated with a physical service site, such as a site-specific intake protocol or active service limitation. Used in clinical and facility management records to capture contextual notes about the site's current operational status.

location identifierloc_id

A unique alphanumeric key assigned to a physical service site in EHR, claims, provider directory, and enrollment systems. Maps to NPI place of service, facility codes, or internal system IDs used to link patient encounters, claims, and contracts to a specific care delivery site.

location indexloc_idx

A system-generated positional or sequential number assigned to a physical service site within EHR, provider network, or facility management databases. Used to order, reference, or de-duplicate location records across multi-site health systems and payer data platforms.

location indicatorloc_ind

Boolean flag in EHR and provider master data systems denoting the active or inactive status of a physical service site. Used in facility management tables to filter eligible locations for claims routing, scheduling, and network validation workflows.

location instructionloc_instr

Free-text guidance field in provider directories and EHR facility master records that captures operational directives for a physical service site, such as patient check-in procedures, access restrictions, or care delivery protocols used by scheduling and referral systems.

location keyloc_key

A system-generated or assigned lookup key used to uniquely reference a physical service site within a database or data warehouse. Serves as the primary relational identifier linking location records across facility management, claims, scheduling, and provider network tables.

location languageloc_lang

The primary language or languages supported at a physical service site, including interpreter services and multilingual staff availability. Used in care coordination, member referral systems, and health equity reporting to match patients with facilities that can serve their communication needs.

PreviousPage 142 of 325Next