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 statusloc_sts

The current operational state of a physical service site in provider directory, credentialing, or claims systems, such as active, inactive, suspended, or terminated. Used during claims routing, network adequacy validation, member attribution, and provider enrollment processing to ensure only eligible facilities are included in adjudication workflows.

location street addressloc_st_addr

The primary street address of a healthcare service site, including building number and street name. Used in provider directories, claims processing, member communications, and network management to identify the physical location of care delivery.

location strengthloc_str

A misapplied pharmacy field incorrectly associated with a facility record. In proper context, strength denotes the concentration or dosage of a medication. This field should be reviewed and remapped appropriately within the location management data model.

location subtotalloc_subtot

A partial aggregated value representing a subset of counts or amounts associated with a healthcare service site, such as a subtotal of services rendered, beds occupied, or claims tied to the location within a defined reporting period.

location system identifierloc_sys_id

A unique identifier assigned by the source system to distinguish a healthcare service site across internal and external platforms. Used as a primary or foreign key in data integration, claims processing, and provider network management workflows.

location targetloc_tgt

The designated destination facility or reference site in care coordination, claims routing, or provider network systems. Identifies where a patient is being referred, transferred, or directed for services, supporting referral management workflows, network steerage programs, and out-of-network exception tracking in EHR and payer platforms.

location taxonomy codeloc_tax_cd

The NUCC Health Care Provider Taxonomy code assigned to a healthcare service site, classifying the type of facility or specialty setting. Used in claims submission, provider enrollment, and network credentialing to identify the care setting category.

location temperatureloc_temp

A misapplied clinical vital sign field incorrectly mapped to a facility record. In proper context, temperature records a patient's body temperature during a clinical encounter. This field should be reviewed for correct placement in the location data model.

location termination dateloc_term_dt

The date on which a healthcare service site was officially deactivated, closed, or removed from an active network or registry. Used in provider directories, network management, and claims systems to enforce eligibility date ranges for the facility.

location timeloc_tm

The time-of-day value capturing when a service, event, or transaction occurred at a physical service site in EHR, claims, or pharmacy systems. Used for scheduling analytics, after-hours service tracking, shift-based utilization reporting, and timestamp validation during claims adjudication and clinical data integration workflows.

location timestamploc_ts

The precise date and time value recording when an event, transaction, or update occurred at or for a physical service site in EHR, claims, or provider directory systems. Supports audit trail integrity, real-time data pipeline processing, SLA monitoring, and regulatory compliance reporting across healthcare data infrastructure environments.

location titleloc_ttl

The formal name or designation assigned to a healthcare service site, such as a clinic, hospital wing, or department name. Used in provider directories, member-facing materials, and administrative systems to identify and display the facility consistently.

location totalloc_tot

The aggregate sum value calculated for a physical service site in claims, pharmacy, or financial reporting systems. Represents totalized metrics such as total billed charges, paid amounts, dispensed units, or patient encounters associated with a facility, used in cost analysis, provider performance benchmarking, and payer financial reconciliation workflows.

location total countloc_tot_cnt

The aggregate number of records, events, services, or occurrences associated with a healthcare service site within a defined scope or time period. Used in facility reporting, network analytics, and operational dashboards to summarize site-level activity.

location typeloc_typ

The standardized category classification identifying the nature of a physical service site in provider directory, claims, and EHR systems. Values may include inpatient hospital, outpatient clinic, pharmacy, telehealth, long-term care, or urgent care, driving claims adjudication rules, reimbursement logic, and network adequacy compliance determinations.

location unitloc_unt

Measurement unit descriptor in facility and operational data systems specifying the unit of measure associated with a physical service site metric, such as square footage, bed count, or capacity units. Supports standardized reporting across multi-site healthcare analytics environments.

location updated dateloc_upd_dt

The timestamp recording when a physical service site record was last modified in the healthcare facility registry. Supports audit trails, data governance, and ensures downstream systems referencing facility data are consuming the most current address, status, or operational details.

location urgencyloc_urg

Indicates the priority or time-sensitivity classification assigned to a physical service site, such as emergency, urgent care, or routine care designation. Used in care coordination and patient routing workflows to direct patients to appropriate facility types based on acuity level.

location valueloc_val

Quantitative or qualitative data point in EHR and provider analytics systems representing a measured attribute of a physical service site, such as capacity, utilization rate, or performance score. Used in facility benchmarking, network adequacy assessments, and operational dashboards.

location versionloc_ver

A sequential version number assigned to a physical service site record that increments each time the record is updated. Enables point-in-time reconstruction of facility data, supports change tracking across health information systems, and maintains historical accuracy for claims adjudication and reporting.

PreviousPage 146 of 325Next