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

protocol sequenceproto_seq

Defines the numeric ordering position of a specific step, action, or intervention within a standardized clinical protocol. Ensures that care activities are executed in the correct prescribed order, supporting patient safety and consistent protocol adherence across clinical settings and care episodes.

protocol service dateproto_svc_dt

Records the calendar date on which a protocol-defined clinical service or intervention was delivered to the patient. Used to track adherence to protocol timelines, measure care delivery gaps, and support longitudinal analysis of treatment patterns within standardized clinical care pathways.

protocol severityproto_sev

Captures the assessed seriousness or acuity level of a patient's condition as defined within a standardized clinical protocol, such as mild, moderate, or severe classifications. Used to determine appropriate protocol pathways, escalation thresholds, and resource allocation for protocol-driven patient management.

protocol sexproto_sex

Records the patient's biological sex classification as required by a standardized clinical protocol, where sex-specific criteria influence eligibility, dosing, or care pathway selection. Used to ensure protocol applicability and support sex-stratified clinical outcome reporting and quality measure calculations.

protocol sourceproto_src

Identifies the originating reference, guideline, or authoritative body from which a standardized clinical protocol was derived, such as a specialty society, regulatory agency, or institutional committee. Used to maintain traceability, version control, and evidence-based validation of protocol content within clinical systems.

protocol start dateproto_start_dt

Records the calendar date on which a standardized clinical protocol was initiated for a patient. Used to establish protocol duration timelines, measure time-to-treatment metrics, assess adherence to evidence-based initiation criteria, and support longitudinal reporting of protocol-driven care episodes.

protocol start timeproto_start_tm

Records the exact clock time at which a standardized clinical protocol was initiated for a patient. Used in time-sensitive care contexts such as sepsis bundles or stroke protocols to measure adherence to critical treatment windows and calculate time-to-intervention performance metrics.

protocol stateproto_st

Captures the U.S. state or geographic jurisdiction associated with a standardized clinical protocol, indicating where the protocol applies or was enacted. Used to support regional compliance reporting, multi-site protocol management, and jurisdiction-specific regulatory or licensure requirements within clinical data systems.

protocol statusproto_sts

Indicates the current operational state of a standardized clinical protocol for a patient or at the system level, such as active, suspended, completed, or discontinued. Used to manage protocol lifecycle tracking, trigger workflow alerts, and support audit reporting of protocol adherence and completion rates.

protocol street addressproto_st_addr

Records the physical street address associated with the care site or entity where a standardized clinical protocol is administered or managed. Used to support facility-level reporting, multi-site protocol deployment tracking, and geographic analysis of protocol utilization across clinical locations.

protocol strengthproto_str

Specifies the drug concentration or dosage strength prescribed within a standardized clinical protocol for a medication-based intervention, such as 500mg or 0.9% concentration. Ensures consistent pharmacologic dosing adherence across all patients managed under the same evidence-based protocol framework.

protocol subtotalproto_subtot

Captures an intermediate calculated sum of costs, units, scores, or quantities associated with a subset of components within a standardized clinical protocol. Used in financial reconciliation, protocol cost analysis, and multi-phase treatment reporting where partial aggregations are required before a final total is computed.

protocol surgery dateproto_surg_dt

Records the calendar date on which a surgical intervention defined within or triggered by a standardized clinical protocol was performed. Used to measure adherence to protocol-specified surgical timing windows, track operative outcomes, and support perioperative quality reporting within protocol-driven care pathways.

protocol system identifierproto_sys_id

The unique system-generated identifier assigned to a standardized clinical protocol record, enabling consistent cross-system tracking, deduplication, and data linkage across EHR, clinical data warehouse, and care management platforms throughout the full lifecycle of the protocol.

protocol targetproto_tgt

Defines the specific clinical goal, therapeutic endpoint, or measurable outcome that a standardized protocol is designed to achieve, such as a target blood pressure, HbA1c level, or infection rate reduction. Used to assess protocol effectiveness and track patient progress against defined benchmarks.

protocol taxonomy codeproto_tax_cd

Records the National Provider Identifier taxonomy code identifying the clinical specialty or provider type associated with administering a standardized protocol. Used to classify protocol ownership by specialty, support credentialing validation, and enable specialty-stratified protocol utilization reporting across clinical systems.

protocol temperatureproto_temp

Records the patient's body temperature measurement captured as part of a standardized clinical protocol assessment, such as sepsis screening or post-operative monitoring. Used to evaluate protocol eligibility criteria, trigger escalation pathways, and document vital sign trends within protocol-driven clinical documentation.

protocol termination dateproto_term_dt

The date on which a clinical protocol officially ended or was discontinued. Used in clinical trials, care management programs, and treatment pathways to mark when a standardized set of clinical procedures or guidelines ceased to be active for a patient or study cohort.

protocol timeproto_tm

The specific time of day at which a clinical protocol action, intervention, or assessment was performed or scheduled. Used in clinical trials and care management workflows to ensure precise sequencing and adherence to time-sensitive treatment or data collection steps.

protocol timestampproto_ts

The combined date and time value recording when a clinical protocol event, intervention, or data entry occurred. Used in clinical trials and care management systems to establish an auditable, chronological record of protocol-driven activities and ensure regulatory compliance.

PreviousPage 537 of 806Next