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

sign scheduled timesgn_sched_tm

The planned clock time at which an observable clinical sign is scheduled to be assessed or documented during a patient encounter. Used in clinical workflow and scheduling systems to coordinate care team activities, track assessment adherence, and support time-sensitive monitoring protocols such as vital sign intervals.

sign street addresssgn_st_addr

The street-level address of the care location where an observable clinical sign was assessed or documented. Used in clinical and administrative systems to identify the physical site of patient assessment, supporting place-of-service reporting, multi-site care coordination, and regulatory compliance documentation.

sign unitsgn_unt

The unit of measure applied to an observable clinical sign, such as mmHg for blood pressure, beats per minute for pulse, or degrees for temperature. Used in EHR and clinical data systems to standardize the quantification of physical findings, enabling accurate trend analysis and clinical decision support.

site addresssite_addr

The full physical street address of a healthcare care delivery location, such as a clinic, hospital, or outpatient facility. Used in provider enrollment, credentialing, and claims systems to identify where services are rendered, supporting network management, place-of-service billing, and regulatory compliance reporting.

site agesite_age

The number of years a healthcare care delivery location has been operational since its establishment or licensure date. Used in facility management and network analytics to assess site maturity, inform infrastructure planning, support contract negotiations, and analyze performance benchmarks relative to facility tenure.

site allowed amountsite_alwd_amt

The maximum reimbursable dollar amount a payer will cover for services rendered at a specific care delivery location, based on contract terms or fee schedules. Used in claims adjudication and revenue cycle management to calculate provider payment after applying contractual discounts and patient cost-sharing obligations.

site amountsite_amt

The gross monetary value associated with services rendered at a specific care delivery location before adjustments, discounts, or patient cost-sharing are applied. Used in revenue cycle and financial reporting systems to capture total billed charges at the facility level, supporting cost analysis and payer contract performance evaluation.

site approval statussite_appr_sts

The current authorization or credentialing state of a care delivery location, indicating whether the site has been reviewed, approved, or denied for inclusion in a provider network or program. Used in network management and credentialing workflows to track facility compliance with payer, accreditation, and regulatory standards.

site approved bysite_appr_by

The name or identifier of the individual or authority who granted approval for a care delivery location to participate in a network, program, or operational status. Used in credentialing and network management systems to maintain an audit trail of site authorization decisions and accountability for compliance oversight.

site arrival timesite_arrv_tm

The recorded clock time at which a patient arrives at a care delivery location for a scheduled or unscheduled encounter. Used in operational and clinical systems to measure patient flow efficiency, calculate door-to-provider intervals, support throughput analytics, and meet regulatory reporting requirements for emergency and acute care settings.

site arrived datesite_arrv_dt

The calendar date on which a patient arrives at a care delivery location for a healthcare encounter. Used in scheduling, clinical, and claims systems to establish the encounter start date, support length-of-stay calculations, validate service timelines for billing, and track patient access metrics across care delivery sites.

site assessmentsite_asmt

Structured or narrative clinical evaluation text documenting the condition, readiness, or suitability of a care delivery location. Captures findings from facility reviews, infection control audits, or accreditation inspections used in healthcare operations and quality management workflows.

site balancesite_bal

Outstanding financial amount remaining unpaid for services rendered at a specific care delivery location. Calculated as total billed charges minus payments and adjustments applied, used in revenue cycle management to track accounts receivable aging across facility sites.

site billed amountsite_bill_amt

Total gross charges invoiced for healthcare services rendered at a specific care delivery location before any contractual adjustments, payments, or write-offs are applied. Used in revenue cycle and claims processing to establish the initial charge amount for reimbursement calculations.

site birth datesite_birth_dt

Date on which a care delivery location was officially established, licensed, or first became operational within the healthcare system. Used in facility management and credentialing workflows to calculate site age, track operational history, and support regulatory compliance reporting.

site blood pressuresite_bp

Recorded systolic and diastolic arterial pressure measurement captured at the point of care during a clinical encounter at a specific care delivery location. Used in clinical documentation workflows to track patient vital signs and associate readings with the originating facility or care site.

site cancelled datesite_cncl_dt

Date on which a scheduled service, appointment, procedure, or site-level activity was formally cancelled at a care delivery location. Used in scheduling and operational analytics to measure cancellation rates, identify capacity trends, and support no-show management across facilities.

site categorysite_cat

Classification grouping assigned to a care delivery location that identifies its functional type within the healthcare network, such as ambulatory clinic, urgent care, inpatient hospital, or long-term care facility. Used in reporting, contract management, and network configuration workflows.

site charge amountsite_chrg_amt

Monetary value representing the fee charged for a specific service or procedure performed at a care delivery location, prior to payer adjustments or patient responsibility calculations. Used in claims adjudication, fee schedule validation, and cost analysis across facility sites.

site chief complaintsite_cc

Primary symptom or clinical concern reported by the patient at the time of their encounter at a specific care delivery location. Captured as free text or coded value in clinical documentation workflows and used to support triage, diagnosis coding, and site-level utilization analysis.

PreviousPage 228 of 325Next