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

syndrome addresssynd_addr

The physical or mailing address associated with a patient or facility record linked to a reported syndrome, particularly within public health surveillance systems. Used in syndromic surveillance and epidemiological tracking to map geographic clusters of symptom patterns and support outbreak investigation workflows.

syndrome approval statussynd_appr_sts

Indicates the current review or validation state of a syndrome record within a public health surveillance or clinical data system, such as pending review, confirmed, or rejected. Used by epidemiologists and health officials to manage the verification pipeline for reported symptom clusters and disease patterns.

syndrome charge amountsynd_chrg_amt

The monetary value associated with clinical services rendered in connection with a documented syndrome, captured in claims or billing systems. Used in healthcare cost analysis to evaluate the financial impact of treating specific symptom clusters and to support population health cost modeling.

syndrome effective datesynd_eff_dt

The date on which a syndrome definition, surveillance protocol, or patient syndrome record becomes active within a clinical or public health data system. Used in epidemiological reporting to establish the onset timeframe for symptom cluster tracking, case management, and disease trend analysis.

syndrome group numbersynd_grp_nbr

A numeric identifier that groups related syndrome records within a public health surveillance or clinical data system, enabling aggregation of cases sharing common symptom patterns or exposure events. Used in outbreak investigation and epidemiological analysis to link related cases across reporting periods.

syndrome medical record numbersynd_mrn

The unique patient medical record number (MRN) associated with a documented syndrome case, linking the syndromic surveillance or clinical record to the patient's longitudinal health history. Used to correlate syndrome reports with prior diagnoses, treatment encounters, and lab results in clinical data warehouses.

syndrome scheduled datesynd_sched_dt

The planned date for a clinical assessment, follow-up visit, or public health investigation related to a documented syndrome case. Used in care management and surveillance workflows to track scheduled evaluations of patients presenting with specific symptom clusters requiring monitoring or further diagnostic workup.

syndrome scheduled timesynd_sched_tm

The specific time designated for a clinical encounter, diagnostic evaluation, or surveillance follow-up associated with a documented syndrome case. Used alongside the scheduled date to coordinate timely patient assessments and ensure compliance with public health response or clinical monitoring protocols.

syndrome street addresssynd_st_addr

The physical street address of a patient or reporting facility associated with a documented syndrome case in public health or clinical surveillance systems. Used in geospatial epidemiology to map syndrome incidence, identify geographic clusters, and support local health department outbreak response activities.

syndrome unitsynd_unt

Identifies the clinical unit, ward, or organizational department associated with a syndrome case record, such as an emergency department, ICU, or outpatient specialty clinic. Used in syndromic surveillance systems to attribute case volumes to specific care settings and monitor unit-level symptom cluster trends.

system addresssys_addr

The physical or network address associated with a healthcare information system, application server, or integrated delivery network node. Used in IT infrastructure management, system integration mapping, and healthcare data governance to identify the location or endpoint of systems participating in clinical data exchange.

system effective datesys_eff_dt

The date on which a healthcare system record becomes active and valid for use. Marks the start of a temporal period for system-level configurations, rules, or parameters, enabling date-range queries and historical tracking of system state changes in data warehouses.

system scheduled datesys_sched_dt

The calendar date on which a system-level process, job, or automated workflow is planned to execute. Used in healthcare IT operations to coordinate batch processing, data feeds, and interface transmissions across clinical and administrative platforms.

system scheduled timesys_sched_tm

The clock time at which a system-level process, automated job, or interface transmission is planned to run. Combined with the system scheduled date, this value defines the precise execution window for batch processes in healthcare data environments.

system street addresssys_st_addr

The physical street-level address associated with a healthcare system entity, such as a facility, data center, or administrative office. Used to support geographic reporting, correspondence routing, and regulatory location-based submissions in healthcare operations.

system unitsys_unt

The discrete unit of measure or organizational unit assigned to a system-level record. Identifies the specific department, cost center, or measurement standard associated with the system entity, supporting operational reporting and resource allocation tracking.

target record counttgt_rec_cnt

The total number of records successfully loaded into a target table or data warehouse after a data pipeline execution, compared against the source record count to calculate load success rates, identify records rejected due to data quality failures, and ensure complete and accurate data transfer in healthcare data integration workflows.

task addresstsk_addr

The physical or mailing address associated with a specific workflow task, such as the location where a home health visit, care coordination activity, or follow-up action is to be performed. Used to route field-based clinical and administrative tasks.

task agetsk_age

The number of days, hours, or business periods a workflow task has been open or pending since its creation date. Used in care management and utilization review platforms to monitor task aging, prioritize workloads, and enforce service level agreement timelines.

task allowed amounttsk_alwd_amt

The maximum dollar amount contractually permitted for reimbursement associated with a workflow task in a care management or utilization review context. Supports cost tracking and financial reconciliation when tasks are linked to specific claims or authorization events.

PreviousPage 265 of 325Next