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 discharge dateproto_dsch_dt

The actual or anticipated date a patient is discharged from a care setting while enrolled in a clinical protocol. Used to track protocol episode completion, measure length of stay benchmarks, and evaluate outcomes associated with inpatient or post-acute care pathways.

protocol due dateproto_due_dt

The target date by which a specific clinical protocol step, assessment, or intervention must be completed for a patient. Used in care management systems to trigger alerts, drive workflow task lists, and ensure timely adherence to protocol-defined care milestones.

protocol durationproto_dur

The total length of time a clinical protocol is intended to span from initiation to completion, expressed in days, weeks, or months. Used to plan care timelines, allocate resources, and measure patient adherence against expected protocol treatment windows in care management systems.

protocol effective dateproto_eff_dt

The date on which a clinical protocol version becomes active and applicable for patient enrollment or clinical use. Used in protocol governance to manage version control, ensure clinicians apply current guidelines, and maintain accurate audit trails in clinical information systems.

protocol emailproto_eml

The electronic mail address associated with the clinical team, coordinator, or contact responsible for managing or administering a specific protocol. Used to route communications, notifications, and protocol-related correspondence within care management and clinical coordination platforms.

protocol emergency indicatorproto_emerg_ind

A flag identifying whether a clinical protocol is designated for urgent or emergent care situations, triggering expedited workflows or escalated clinical responses. Used in clinical systems to prioritize resource allocation and ensure time-sensitive protocol steps are initiated without delay.

protocol end dateproto_end_dt

The date on which a patient's participation in a clinical protocol concludes, either through successful completion, discontinuation, or transition to another care pathway. Used to calculate protocol episode duration, measure outcomes, and close active care management enrollments.

protocol end timeproto_end_tm

The specific timestamp marking the conclusion of a clinical protocol session, intervention, or monitoring period for a patient. Used alongside the protocol end date for precise episode tracking, clinical audit logging, and time-based outcome measurement in care management systems.

protocol entered byproto_ent_by

The identifier of the clinical staff member or system user who recorded or initiated a protocol entry in the healthcare information system. Used for accountability, audit trails, and data provenance tracking to ensure protocol documentation integrity in clinical and care management platforms.

protocol ethnicityproto_ethn

The recorded ethnicity of the patient enrolled in a clinical protocol, captured to support population health stratification, health equity reporting, and analysis of protocol outcomes across demographic groups in clinical data warehouses and care management systems.

protocol expiration dateproto_exp_dt

The date after which a clinical protocol version is no longer valid for new patient enrollment or active clinical use. Used in protocol governance workflows to enforce version retirement, prompt review cycles, and prevent application of outdated clinical guidelines in care delivery systems.

protocol external identifierproto_ext_id

A unique reference code assigned to a clinical protocol by an external system, registry, or standards body such as a research database or accreditation organization. Used to cross-reference and reconcile protocol records across disparate healthcare platforms and interoperability interfaces.

protocol faxproto_fax

The facsimile number associated with the clinical team or administrative contact responsible for a specific protocol. Used to transmit protocol-related documents, referrals, or patient records between healthcare facilities and care coordinators in environments where fax remains a required communication channel.

protocol feeproto_fee

The charge associated with administering or enrolling a patient in a specific clinical protocol, used for cost accounting, billing reconciliation, and financial reporting. May reflect bundled service costs or per-episode fees tracked in healthcare financial and clinical management systems.

protocol first nameproto_first_nm

The first name of the patient or clinical contact associated with a protocol record. Used to support patient matching, personalized care communications, and accurate identification within clinical workflows when displaying protocol enrollment details in care management systems.

protocol flagproto_flg

A binary or coded indicator used to mark a specific condition, exception, or status associated with a clinical protocol record, such as requiring review, being on hold, or meeting escalation criteria. Used to filter, prioritize, and manage protocol workflows in clinical systems.

protocol frequencyproto_freq

The defined interval or schedule at which protocol-specified interventions, assessments, or treatments must be performed for an enrolled patient. Used in care management systems to generate task schedules, monitor adherence, and ensure clinical activities occur at protocol-mandated intervals.

protocol full nameproto_full_nm

The complete formal name of a clinical protocol as defined by the governing clinical body or institution, used for unambiguous identification in documentation, reporting, and patient communication. Distinguishes the protocol from abbreviated codes or short labels in clinical data systems.

protocol genderproto_gndr

The biological sex or gender identity classification recorded within a clinical protocol, used to define eligibility criteria, screening thresholds, or treatment parameters that differ by sex, ensuring protocol-driven care pathways are applied to the correct patient populations.

protocol glucoseproto_gluc

The blood glucose measurement captured or required as part of a standardized clinical protocol, such as a diabetes management or surgical pre-op pathway. Used to determine protocol eligibility, trigger clinical decision rules, or document lab values at defined protocol checkpoints.

PreviousPage 533 of 806Next