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 detailsite_dtl

Supplementary or granular information associated with a care delivery location record. Used in healthcare data systems to capture additional facility attributes such as unit specifications, service line details, or operational notes that extend the core site record for reporting and clinical workflow purposes.

site due datesite_due_dt

The deadline date associated with a care delivery location for a scheduled obligation, such as a compliance submission, accreditation renewal, or billing cycle. Used in administrative and revenue cycle management systems to track and enforce time-sensitive facility-level requirements and payment deadlines.

site effective datesite_eff_dt

The date on which a care delivery location becomes officially active or a specific attribute of the site record takes effect. Used in facility management and enrollment systems to define the start of a valid period, enabling accurate date-range queries and historical tracking of site configurations.

site emailsite_eml

The electronic mail address associated with a care delivery location for administrative or clinical communications. Used in facility management systems to route correspondence, appointment notifications, referral communications, and operational alerts to the appropriate site contact or department inbox.

site end datesite_end_dt

The date on which a care delivery location's active status or a specific site attribute concludes. Used in facility lifecycle and contract management systems to define the closing boundary of a valid period, supporting accurate historical reporting and preventing the use of inactive site records in clinical workflows.

site end timesite_end_tm

The specific time at which a care delivery location's activity, service window, or record validity concludes on a given date. Used in scheduling and facility management systems to define operational hours, close encounter records, and support time-based reporting for clinical and administrative workflows.

site entered bysite_ent_by

The username or identifier of the staff member who originally created or entered the care delivery location record into the healthcare system. Used in audit trails and data governance processes to establish accountability, track data entry activity, and support quality review of facility record creation.

site ethnicitysite_ethn

The ethnicity demographic attribute associated with a care delivery location record, typically reflecting the primary patient population served. Used in population health management and quality reporting to analyze health disparities, support culturally competent care initiatives, and meet regulatory demographic reporting requirements.

site expiration datesite_exp_dt

The date on which a care delivery location's credentials, contract, accreditation, or active record status expires. Used in provider credentialing, payer contracting, and facility management systems to monitor validity periods, trigger renewal workflows, and prevent billing or clinical activity after authorization lapses.

site external identifiersite_ext_id

A unique reference code assigned to a care delivery location by an external system, payer, or partner organization. Used in healthcare data integration and interoperability workflows to map and reconcile facility records across disparate systems such as claims platforms, HIEs, and third-party vendor databases.

site faxsite_fax

The facsimile telephone number associated with a care delivery location for transmitting clinical and administrative documents. Used in referral management, prior authorization, and medical records workflows to route fax communications to the correct facility contact, supporting secure document exchange between healthcare entities.

site feesite_fee

The service charge or facility fee associated with a specific care delivery location, such as a clinic, hospital outpatient department, or ambulatory surgery center. Used in claims processing and revenue cycle management to capture location-based cost differentials applied to rendered services.

site first namesite_first_nm

The primary given name component of a care delivery location's name, used when site naming conventions separate first and last name elements. Supports display, search, and reporting functions within facility directories, provider networks, and healthcare administration systems.

site flagsite_flg

A binary or coded indicator that marks a specific status, condition, or classification for a care delivery location, such as active/inactive, in-network, or credentialed status. Used in facility management systems to filter, route, and apply business rules across site records.

site frequencysite_freq

The operational frequency attribute associated with a care delivery location, such as how often services are rendered, reporting cycles occur, or data submissions are required. Used in scheduling, compliance tracking, and utilization management workflows tied to specific facilities.

site full namesite_full_nm

The complete, unabbreviated name of a care delivery location, combining all name components into a single displayable string. Used in member communications, provider directories, claims adjudication, and reporting to uniquely identify facilities in a human-readable format.

site gendersite_gndr

A classification attribute assigned to a care delivery location indicating the patient population served by gender, such as a women's health clinic or gender-specific treatment center. Used in network management, care coordination, and member referral routing within healthcare systems.

site glucosesite_gluc

The glucose measurement or blood sugar level recorded or associated with a specific care delivery location context, typically in clinical research, population health, or lab aggregation datasets. Used to track diagnostic lab results tied to a facility or site of service in clinical data systems.

site group numbersite_grp_nbr

A numeric identifier that associates a care delivery location with a specific facility group, network cluster, or administrative grouping within a health system. Used in claims processing, contract management, and network reporting to link individual sites to parent group structures.

site hemoglobinsite_hgb

The hemoglobin measurement recorded or associated with a specific care delivery location, typically in population health, clinical research, or aggregated lab reporting datasets. Used to track hematology results linked to a facility or site of service in clinical data warehouses.

PreviousPage 230 of 325Next