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 active indicatorspec_actv_ind

A binary flag indicating whether a specialist physician or clinician currently holds an active status within a health plan network, hospital medical staff roster, or credentialing system. Used to filter eligible specialists during referral processing and network adequacy assessments.

specialist active statusspec_actv_sts

The current participation or credentialing status of a specialist physician within a health plan network or facility medical staff, indicating whether the specialist is actively accepting referrals, under suspension, or terminated. Used in referral management and network directory maintenance.

specialist agespec_age

The age in years of a specialist physician at a given reference date, typically used in workforce analytics, credentialing records, and health plan network reporting to support provider demographic analysis and succession planning within specialty networks.

specialist allowed amountspec_alwd_amt

The maximum dollar amount a health plan will reimburse for services rendered by a specialist physician, as defined by the plan's fee schedule or contracted rate. Used in claims adjudication to determine member cost-sharing obligations and specialist payment calculations.

specialist approved byspec_appr_by

The identifier or name of the individual who authorized a specialist referral, credentialing action, or clinical order. Used in referral management and utilization review workflows to establish accountability and support audit trails within managed care and care coordination systems.

specialist arrival timespec_arrv_tm

The recorded clock time at which a specialist clinician arrived at a care setting, such as a hospital floor, consultation room, or emergency department. Used in care coordination, response time tracking, and quality metrics reporting for specialist consultation timeliness.

specialist arrived datespec_arrv_dt

The calendar date on which a specialist clinician arrived to provide a consultation or procedure at a clinical facility. Used in inpatient care coordination, specialist response tracking, and episode-of-care reporting to measure timeliness of specialty service delivery.

specialist assessmentspec_asmt

The clinical evaluation or diagnostic impression documented by a specialist physician following examination of a referred patient. Captures the specialist's findings, differential diagnoses, and clinical conclusions within consultation notes in the patient's medical record.

specialist blood pressurespec_bp

The systolic and diastolic arterial blood pressure measurement recorded by a specialist clinician during a patient consultation or examination. Used in clinical documentation, chronic disease management, and outcome reporting within specialty care encounter records.

specialist cancelled datespec_cncl_dt

The date on which a scheduled specialist referral, consultation, or appointment was cancelled by the patient, referring provider, or specialist. Used in referral tracking systems to identify care gaps, measure no-show rates, and support follow-up workflows in utilization management.

specialist chief complaintspec_cc

The primary symptom, condition, or clinical concern documented at the time a patient is referred to or presents before a specialist physician. Drives the clinical focus of the specialist consultation and is captured in the encounter record to support diagnosis coding and care planning.

specialist cityspec_city

The city or municipality where a referring specialist's practice or facility is located. Used in referral management, care coordination records, and provider directory systems to route patients to appropriate specialty care and verify geographic accessibility of specialist services.

specialist completed datespec_cmpl_dt

The date on which a specialist referral, consultation, or treatment episode was formally completed. Used in referral tracking systems to measure timeliness of specialty care delivery, close open referral workflows, and support utilization reporting for managed care organizations.

specialist countryspec_ctry

The country where a specialist's practice or facility is registered and operating. Used in referral management and provider directory systems to distinguish domestic from international specialists, support cross-border care coordination, and ensure compliance with jurisdictional licensing requirements.

specialist created byspec_crtd_by

The system username or user identifier of the individual who created the specialist record in the healthcare information system. Used for data governance, audit trail documentation, and accountability tracking within referral management and provider credentialing workflows.

specialist created timespec_crtd_tm

The exact timestamp recording when a specialist record was initially entered into the healthcare information system. Used for audit trail purposes, data lineage tracking, and workflow sequencing within referral management, credentialing, and provider directory maintenance processes.

specialist creatininespec_cr

The serum creatinine laboratory value recorded in the context of a specialist consultation, used to assess a patient's renal function. Commonly captured in nephrology, cardiology, and transplant specialty workflows to inform treatment decisions, medication dosing, and monitoring protocols.

specialist dea numberspec_dea_nbr

The Drug Enforcement Administration registration number assigned to a specialist physician, authorizing them to prescribe controlled substances. Used in pharmacy systems, e-prescribing platforms, and credentialing records to validate prescribing authority and ensure regulatory compliance with federal narcotics laws.

specialist deleted datespec_del_dt

The date on which a specialist record was logically removed or inactivated within the healthcare information system. Used in provider directory maintenance, referral management audits, and data governance processes to track record lifecycle and maintain historical accuracy without permanent data loss.

specialist due datespec_due_dt

The target or deadline date by which a specialist referral, consultation, or follow-up action must be completed. Used in care management and referral tracking systems to prioritize pending specialist engagements, trigger escalation workflows, and monitor compliance with referral turnaround time standards.

PreviousPage 655 of 806Next