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 durationspec_dur

The total length of time associated with a specialist referral episode, consultation visit, or treatment course. Used in utilization management and care coordination systems to measure specialist engagement timelines, support capacity planning, and evaluate efficiency of specialty care delivery.

specialist emergency indicatorspec_emerg_ind

A flag indicating whether a specialist referral or consultation has been designated as an emergency or urgent case requiring expedited scheduling and care. Used in referral management systems to prioritize workflows, trigger immediate outreach, and ensure timely access to specialty services for high-acuity patients.

specialist end timespec_end_tm

The recorded time at which a specialist consultation, procedure, or appointment concluded. Used in scheduling systems and clinical documentation to calculate visit duration, support facility resource planning, and provide accurate encounter records for billing and care coordination purposes.

specialist entered byspec_ent_by

The username or identifier of the staff member who manually entered or submitted a specialist record or referral into the healthcare information system. Used for audit trail documentation, workflow accountability, and quality assurance reviews within referral management and provider credentialing processes.

specialist ethnicityspec_ethn

The self-reported or recorded ethnic background of a specialist physician. Used in provider workforce analytics, diversity reporting, and health equity initiatives to monitor representation across specialty disciplines and support compliance with regulatory workforce demographic reporting requirements.

specialist external identifierspec_ext_id

A unique identifier assigned to a specialist by an external system, such as a health information exchange, payer platform, or regional provider registry. Used to cross-reference and reconcile specialist records across disparate healthcare systems, supporting interoperability and accurate provider data matching.

specialist faxspec_fax

The fax number associated with a specialist's practice or office, used for transmitting referral authorizations, clinical notes, and consultation requests. Maintained in provider directory and referral management systems to facilitate secure document exchange between referring providers and specialty practices.

specialist feespec_fee

The charge amount billed or contracted for specialist consultation or procedure services. Used in revenue cycle management, fee schedule administration, and claims processing systems to validate billed amounts, apply contracted rates, and support reimbursement reconciliation for specialty care services.

specialist first namespec_first_nm

The legal given name of a specialist physician as recorded in the provider directory or referral management system. Used to accurately identify and display specialist information in patient referral documents, clinical correspondence, care team records, and provider-facing scheduling interfaces.

specialist full namespec_full_nm

The complete legal name of a specialist physician, typically combining first, middle, and last name components. Used across provider directories, referral documentation, clinical correspondence, and care coordination records to uniquely identify the specialist in both patient-facing and administrative healthcare workflows.

specialist genderspec_gndr

The recorded gender of a specialist physician as maintained in the provider directory or credentialing system. Used in workforce demographic reporting, patient-provider preference matching, and health equity analytics to support inclusive care access and monitor gender diversity across specialty disciplines.

specialist glucosespec_gluc

The blood glucose measurement recorded during or associated with a specialist clinical encounter. Captures fasting or random serum glucose values in mg/dL used by specialty physicians to monitor metabolic conditions such as diabetes or endocrine disorders in clinical data systems.

specialist hemoglobinspec_hgb

The hemoglobin concentration value, measured in g/dL, recorded in the context of a specialist clinical encounter. Used by specialty physicians to assess anemia, hematologic conditions, or treatment response, and stored in clinical data systems to support specialty care decisions and longitudinal monitoring.

specialist history present illnessspec_hpi

The structured narrative documented by a specialist physician describing the onset, duration, character, and progression of a patient's current condition. Captured during specialty consultations and stored in clinical systems as part of the formal evaluation note required for medical decision-making and billing compliance.

specialist keyspec_key

The unique surrogate or natural key value used to identify and look up a specialist record in healthcare data systems. Serves as the primary reference identifier linking specialist demographic, credential, and encounter data across clinical, credentialing, and claims processing tables.

specialist labelspec_lbl

The human-readable display text associated with a specialist record, typically combining name, credential, or specialty designation for use in clinical interfaces, reports, and referral workflows. Used to present specialist identity in a standardized, user-facing format across healthcare information systems.

specialist languagespec_lang

The preferred or primary spoken and written language of the specialist physician, used to facilitate patient-provider communication, match patients with linguistically compatible providers during referrals, and support care coordination documentation within clinical and member management systems.

specialist last namespec_last_nm

The legal family surname of the specialist physician as recorded in credentialing, provider enrollment, and clinical systems. Used for provider identification, directory listings, referral routing, and claims submission where the rendering or referring specialist must be identified by name.

specialist legal namespec_legal_nm

The full official name of the specialist physician as registered with state licensing boards and credentialing bodies. Used in provider enrollment, privileging, sanctions verification, and claims adjudication where the legally recognized identity of the rendering specialist must be confirmed and documented.

specialist license numberspec_lic_nbr

The state-issued professional license number assigned to the specialist physician by the relevant medical licensing board. Used to verify active licensure status, validate provider credentials during enrollment, support compliance audits, and cross-reference sanctions databases in healthcare credentialing and claims systems.

PreviousPage 656 of 806Next