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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

specialist resolution datespec_resol_dt

The date on which a specialist's referral, authorization, case, or clinical issue was formally resolved or closed. Used in utilization management and care coordination systems to measure case duration, track specialty care outcomes, and support quality improvement initiatives.

specialist respirationspec_resp

The patient's respiratory rate recorded during a specialist physician encounter, measured in breaths per minute. Captured as a vital sign in clinical documentation to assess pulmonary and overall patient status within specialty care visits and support longitudinal clinical monitoring.

specialist revisionspec_rev

A version or iteration number indicating that a specialist-related record, authorization, referral, or claim has been updated or corrected. Used in claims adjudication and utilization management systems to track amendments, maintain audit trails, and manage resubmission workflows.

specialist riskspec_rsk

A scored or categorical assessment of clinical or financial risk associated with a patient referred to a specialist. Used in care management and utilization review programs to stratify members, prioritize specialty interventions, and support population health management within specialty care pathways.

specialist routespec_rte

The pathway or method by which a patient accesses specialist care, such as direct referral, self-referral, or emergency access. Used in referral management and claims systems to track access patterns, validate authorization requirements, and evaluate network utilization by specialty type.

specialist sexspec_sex

The biological sex of a specialist physician as recorded in credentialing or provider directory systems. Used in workforce analytics, provider network diversity reporting, and member preference matching to support equitable access to care and regulatory compliance reporting.

specialist start timespec_start_tm

The scheduled or actual clock time at which a specialist physician's encounter, procedure, or consultation began. Captured in clinical scheduling and claims systems to support appointment management, calculate service duration, and enable accurate reporting of specialty care workflows.

specialist statespec_st

The U.S. state or territory in which a specialist physician is licensed to practice or where their primary practice location is registered. Used in provider credentialing, network management, and claims processing to validate licensure, ensure geographic network adequacy, and support multi-state compliance.

specialist strengthspec_str

The concentration or dosage strength of a medication prescribed or administered by a specialist physician during an encounter. Captured in pharmacy and clinical records to ensure accurate medication management, support e-prescribing workflows, and enable medication reconciliation across specialty care episodes.

specialist subtotalspec_subtot

A partial sum of charges or costs attributed to a specialist physician before the application of adjustments, discounts, or additional fees. Used in claims adjudication and financial reporting to itemize specialty care expenditures, support billing reconciliation, and analyze cost components by service type.

specialist surgery datespec_surg_dt

The date on which a surgical procedure was performed by a specialist physician. Recorded on surgical claims and operative reports to establish the episode of care timeline, support coordination of pre- and post-operative services, and enable accurate claims adjudication for surgical specialty encounters.

specialist taxonomy codespec_tax_cd

The standardized NUCC taxonomy code identifying a specialist's specific medical discipline and training, such as cardiology or orthopedics. Used in provider directories, referral management, and claims processing to route patients to appropriately credentialed specialists and validate network participation.

specialist temperaturespec_temp

The recorded body temperature measurement for a patient being evaluated or treated by a specialist, captured in degrees Fahrenheit or Celsius. Used in clinical documentation to monitor patient vitals during specialist encounters and support diagnostic decision-making in specialty care settings.

specialist termination datespec_term_dt

The effective date on which a specialist's participation in a health plan network, referral agreement, or credentialing relationship ends. Used in provider roster management and claims adjudication to determine whether specialist services rendered were covered under an active network contract on the date of service.

specialist titlespec_ttl

The professional or academic title associated with a specialist provider, such as MD, DO, PhD, or NP, reflecting their credentialed role in the healthcare system. Used in provider directories, referral letters, and clinical correspondence to accurately identify and address specialist practitioners.

specialist total countspec_tot_cnt

The aggregated number of specialist providers, referrals, encounters, or services within a defined population or reporting period. Used in network adequacy assessments, utilization management reporting, and health plan analytics to evaluate specialist availability and access across geographic regions or member populations.

specialist updated datespec_upd_dt

The most recent date on which a specialist's provider record was modified, including changes to credentials, contact information, network status, or specialty classification. Used in provider data governance to ensure directory accuracy, support audit trails, and maintain compliance with network adequacy regulations.

specialist urgencyspec_urg

The clinically assigned priority level indicating how quickly a patient must be seen by a specialist, such as routine, urgent, or emergent. Used in referral management workflows to drive scheduling prioritization, authorization timelines, and care coordination decisions for patients requiring specialty evaluation.

specialist versionspec_ver

The incremental version number assigned to a specialist's provider record to track successive updates and maintain a complete change history. Used in provider data management systems to distinguish current from historical record states and support auditing, reconciliation, and data integrity processes.

specialist zipspec_zip

The five or nine-digit postal ZIP code of a specialist's primary practice location. Used in provider directory searches, network adequacy analysis, and geographic access reporting to measure patient proximity to specialty care and ensure compliance with health plan access standards across service areas.

PreviousPage 658 of 806Next