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 marital statusspec_mar_sts

The recorded marital status of the specialist physician, captured as part of demographic and HR-related provider profile data. Though clinically peripheral, this field supports provider workforce analytics, benefit eligibility administration, and demographic completeness requirements in provider data management systems.

specialist master identifierspec_mstr_id

The enterprise master person or provider identifier assigned to a specialist physician that serves as the authoritative, system-wide unique ID linking records across clinical, billing, credentialing, and claims platforms. Used to resolve duplicate provider records and maintain data integrity in master provider index systems.

specialist maximumspec_max

The upper boundary value defined for a specialist-related data element, such as the maximum allowable visits, referral authorizations, or clinical measurement thresholds associated with a specialist encounter. Used in utilization management, benefit configuration, and clinical decision support rule processing within health plan and EHR systems.

specialist middle namespec_mid_nm

The middle name or middle initial of the specialist physician as recorded in provider enrollment and credentialing records. Used to disambiguate providers with similar first and last names, support accurate identity matching across clinical systems, and fulfill naming requirements on licensure and claims documentation.

specialist minimumspec_min

The lower boundary value defined for a specialist-related data element, such as the minimum required visits, authorization thresholds, or acceptable clinical measurement ranges associated with specialty care. Used in utilization management rules, benefit plan configuration, and clinical decision support logic within healthcare data systems.

specialist mobilespec_mob

The mobile or cellular phone number for the specialist physician, used for direct contact in care coordination, referral communication, on-call scheduling, and urgent clinical notifications. Stored in provider directories and clinical communication platforms to facilitate real-time contact between care team members and administrative staff.

specialist modified byspec_mod_by

The username or system identifier of the user or automated process that last updated the specialist's record in the healthcare data system. Captured as part of audit trail functionality to support data governance, record integrity monitoring, and compliance tracking for provider profile and credentialing data changes.

specialist modified timespec_mod_tm

The timestamp recording when a specialist's record was most recently updated in the healthcare data system. Stored as part of the audit trail to support data governance, change history tracking, and synchronization processes between source systems and downstream clinical, credentialing, or claims data repositories.

specialist onset datespec_onset_dt

The date on which the patient's symptoms or condition first began, as documented during a specialist clinical encounter. Captured in the specialist's clinical note to establish disease chronology, support diagnostic coding accuracy, determine benefit eligibility timelines, and inform treatment planning in clinical and claims systems.

specialist oxygen saturationspec_o2sat

The peripheral oxygen saturation percentage (SpO2) recorded during or in association with a specialist clinical encounter. Measured by pulse oximetry and used by specialty physicians to assess respiratory function, monitor cardiopulmonary conditions, and guide treatment decisions, with values stored in clinical data systems for longitudinal tracking.

specialist paid amountspec_pd_amt

The actual dollar amount remitted to a specialist physician by a payer or patient following adjudication of a healthcare claim. Reflects contractual allowed amounts minus member cost-sharing, used in claims financial reporting, provider payment reconciliation, and cost analytics within health plan and revenue cycle management systems.

specialist paid datespec_pd_dt

The date on which payment was issued to a specialist physician for services rendered. Used in claims processing and provider reimbursement tracking to reconcile remittance advices, monitor payment cycles, and support financial reporting across specialty care encounters.

specialist preferred namespec_pref_nm

The preferred display name of a specialist physician as recorded in provider directories or referral management systems. Used to ensure accurate identification on referral authorizations, member-facing directories, and care coordination records where the specialist is referenced by name.

specialist pricespec_prc

The contracted or billed charge amount associated with a specialist physician's services. Used in claims adjudication, fee schedule management, and cost analysis to evaluate specialty care expenditures, negotiate contracts, and support actuarial and financial reporting workflows.

specialist procedure datespec_proc_dt

The date on which a specialist physician performed a clinical procedure for a patient. Captured on medical claims and referral records to establish the service timeline, support utilization review, and ensure accurate coordination of benefits across specialty care episodes.

specialist pulsespec_pulse

The patient's pulse rate recorded during a specialist physician encounter, measured in beats per minute. Captured as a vital sign in clinical documentation to monitor cardiovascular status, track changes across specialty visits, and inform clinical decision-making during specialty care.

specialist racespec_race

The self-reported or administratively assigned racial classification of a specialist physician. Used in provider credentialing, workforce diversity reporting, and health equity analyses to monitor representation across specialty types and support compliance with regulatory reporting requirements.

specialist ratingspec_rtg

A quality or performance score assigned to a specialist physician based on clinical outcomes, patient experience surveys, or network performance metrics. Used in value-based contracting, provider tiering, and member-facing plan directories to guide referral decisions and network management.

specialist ratiospec_ratio

A calculated proportion used in network adequacy and utilization analyses, such as the number of specialists per member population or specialist-to-primary-care ratios. Used by health plans to assess network adequacy, manage specialty access, and comply with regulatory standards.

specialist received datespec_rcvd_dt

The date on which a referral, consultation request, or specialist-related claim was received by the processing entity. Used in referral management and claims workflows to track turnaround times, measure authorization timeliness, and support compliance with access-to-care standards.

PreviousPage 657 of 806Next