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

site identifiersite_id

The unique alphanumeric code assigned to a care delivery location to distinguish it from all other facilities within a healthcare system, network, or data platform. Used as the primary key for linking claims, encounters, credentialing, and enrollment records to a specific physical site.

site indexsite_idx

A sequential or positional numeric value assigned to a care delivery location within a sorted list, data structure, or hierarchical dataset. Used in healthcare information systems to establish ordering, enable efficient data retrieval, and support relational lookups across facility records.

site indicatorsite_ind

A coded value or boolean flag that signals a specific characteristic, operational status, or classification attribute of a care delivery location. Used in network management, claims adjudication, and eligibility processing to trigger business rules or filter site records based on defined criteria.

site keysite_key

The surrogate or natural key value used to uniquely reference a care delivery location within a database or data warehouse schema. Serves as the primary relational link across claims, encounter, credentialing, and member assignment tables to ensure consistent facility identification.

site languagesite_lang

The primary language or languages supported at a care delivery location for patient communication and clinical services. Used in member-to-provider matching, care coordination, and network directory systems to ensure patients are directed to facilities that can meet their language access needs.

site last namesite_last_nm

The surname or secondary name component of a care delivery location's name, used when site naming conventions separate name elements into first and last components. Supports alphabetical sorting, directory display, and search functions within facility management and healthcare administration systems.

site legal namesite_legal_nm

The officially registered or legally recognized name of a care delivery location as recorded with licensing authorities, payers, or government entities. Used in credentialing, contracting, regulatory reporting, and claims adjudication to ensure the facility is correctly identified for compliance purposes.

site levelsite_lvl

The hierarchical tier or classification level assigned to a care delivery location within a health system's organizational structure, such as primary care, specialty, or tertiary care. Used in network design, referral management, and reimbursement tiering to differentiate facilities by capability or role.

site license numbersite_lic_nbr

The official license identifier issued by a state or regulatory body to authorize a care delivery location to operate and provide healthcare services. Used in credentialing, compliance verification, claims adjudication, and provider network management to validate a facility's legal authorization to render care.

site marital statussite_mar_sts

An attribute that may capture the legal or operational relationship status of a care delivery location, such as whether it is an independent entity, a joint venture, or formally affiliated with a health system. Used in contracting, ownership reporting, and network affiliation tracking within healthcare administration systems.

site master identifiersite_mstr_id

The enterprise-level master record identifier assigned to a care delivery location to uniquely distinguish it across all systems within an organization's healthcare data ecosystem. Used in master data management to resolve duplicate records, link source system data, and maintain a single authoritative site record.

site maximumsite_max

The upper threshold value configured for a specific care delivery location, used to enforce capacity limits, dosage ceilings, or operational constraints. Applies in clinical settings to control resource allocation, scheduling capacity, or parameter boundaries at the facility level.

site medical record numbersite_mrn

The unique patient identifier assigned by a specific care delivery location within its local medical records system. Distinguishes patients across multi-site health networks where each facility maintains independent MRN sequences, enabling accurate patient matching and longitudinal record linkage.

site middle namesite_mid_nm

The middle name or initial associated with a care delivery location's registered entity name. Used in formal documentation, credentialing records, or facility registration to fully qualify the legal name of the site when abbreviated or alternate names exist in healthcare systems.

site minimumsite_min

The lower threshold value configured for a specific care delivery location, used to enforce baseline requirements for capacity, dosage floors, or operational parameters. Applied in clinical and administrative systems to define acceptable lower bounds at the facility or unit level.

site mobilesite_mob

The mobile or cellular phone number associated with a care delivery location, used for urgent communications, on-call coordination, or patient outreach. Stored in facility contact records to support care coordination, emergency notifications, and administrative communications across health systems.

site modified bysite_mod_by

The unique identifier of the user or system account that last updated the care delivery location's record. Captured as part of audit trail functionality in healthcare data systems to ensure accountability, traceability, and compliance with data governance and regulatory requirements.

site modified datesite_mod_dt

The calendar date on which a care delivery location's record was most recently updated in the healthcare system. Supports data governance, audit trails, and change tracking by identifying when facility attributes such as address, status, or credentials were last modified.

site modified timesite_mod_tm

The precise time at which a care delivery location's record was most recently updated in the healthcare system. Used alongside the modified date to provide a complete timestamp for audit trail purposes, ensuring accurate sequencing of changes in multi-user healthcare data environments.

site namesite_nm

The official display name assigned to a care delivery location, used to identify the facility across clinical, administrative, and billing systems. Appears in patient-facing communications, provider directories, claims submissions, and operational reports to distinguish one facility from another within a health network.

PreviousPage 231 of 325Next