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 group numberproto_grp_nbr

A numeric identifier that groups related clinical protocols together within a healthcare system, enabling batch management, version control, and coordinated updates across protocol sets used in care pathways, order sets, or clinical decision support configurations.

protocol hemoglobinproto_hgb

The hemoglobin concentration value captured or required at a defined step within a clinical protocol, such as a pre-operative assessment or anemia management pathway. Used to evaluate patient eligibility, trigger interventions, or document lab results at protocol-defined checkpoints.

protocol history present illnessproto_hpi

The structured narrative describing a patient's current symptoms and condition progression as documented within a clinical protocol. Captures the chronological account of the presenting complaint, informing protocol-driven assessment steps, differential diagnosis support, and care pathway initiation criteria.

protocol identifierproto_id

The unique alphanumeric key assigned to a specific clinical protocol within a healthcare information system, enabling precise retrieval, version tracking, and cross-system referencing of standardized care pathways, order sets, or clinical decision support rules across EHR and data warehouse environments.

protocol indexproto_idx

A numeric position value that establishes the sequential order of a protocol within a series of related clinical procedures, care pathways, or order sets. Used to control execution sequence, display ordering, and step-by-step navigation within structured clinical workflow systems.

protocol indicatorproto_ind

A flag or Boolean value that signals whether a specific clinical protocol condition has been met, triggered, or is currently active for a patient encounter. Used in clinical decision support and care pathway systems to drive branching logic, alerts, and workflow routing based on protocol state.

protocol instructionproto_instr

The structured textual guidance embedded within a clinical protocol that directs clinicians through specific steps, actions, or decision points in a care pathway. Includes dosing directions, procedural steps, patient preparation requirements, or escalation criteria defined by evidence-based or institutional standards.

protocol keyproto_key

A system-generated or assigned reference value that serves as the primary lookup field for a clinical protocol record in a healthcare database. Used to join protocol definitions to associated patient encounters, order sets, clinical decision rules, or outcome tracking tables in data warehouse environments.

protocol labelproto_lbl

The human-readable display name or descriptive title assigned to a clinical protocol within a healthcare system interface. Used in clinical workflow applications, patient documentation, and reporting dashboards to present protocol information in a clear, standardized format for clinical and administrative users.

protocol languageproto_lang

The language in which a clinical protocol's instructions, documentation, and patient-facing materials are written or delivered. Ensures that standardized care pathways and patient education components are communicated in the appropriate language to support health literacy and equitable care delivery.

protocol last nameproto_last_nm

The family surname of the individual, typically a patient or clinician, associated with a clinical protocol record. Used in protocols that capture participant or author identification, enabling accurate attribution, patient matching, and record linkage within clinical workflow and data management systems.

protocol legal nameproto_legal_nm

The officially registered full name associated with a clinical protocol record, used for formal documentation, regulatory submissions, and compliance reporting. Ensures that protocol records accurately reflect the legally recognized identity of associated patients, clinicians, or institutional authors in healthcare systems.

protocol levelproto_lvl

A value indicating the hierarchical tier or complexity classification of a clinical protocol within a structured care pathway system. Used to organize protocols by acuity, clinical specialty, or procedural complexity, enabling appropriate routing, escalation logic, and tiered clinical decision support configurations.

protocol license numberproto_lic_nbr

The professional licensure identifier associated with the clinician or institution authorized to execute or oversee a specific clinical protocol. Used in credentialing validation, regulatory compliance tracking, and audit workflows to confirm that protocol administration is performed by appropriately licensed healthcare personnel.

protocol marital statusproto_mar_sts

The marital or relationship status of a patient recorded within a clinical protocol, used where social and family context influences care planning, next-of-kin identification, insurance coordination, or psychosocial assessment components defined within evidence-based or institutionally developed care pathway protocols.

protocol master identifierproto_mstr_id

The enterprise-level master identifier assigned to a clinical protocol, enabling consistent cross-system referencing across multiple EHR instances, data warehouses, and clinical applications. Used to maintain a single authoritative protocol identity across federated healthcare environments and support longitudinal protocol version management.

protocol maximumproto_max

The defined upper boundary value for a clinical parameter, dosage, frequency, or measurement within a standardized protocol. Used in clinical decision support and order set configurations to enforce safety thresholds, trigger alerts, or prevent protocol-driven orders from exceeding evidence-based or regulatory limits.

protocol medical record numberproto_mrn

The unique patient medical record number linked to a clinical protocol instance, associating the standardized care pathway with a specific patient's health record. Enables protocol outcome tracking, longitudinal care monitoring, and accurate patient-level reporting within EHR and clinical data warehouse environments.

protocol middle nameproto_mid_nm

The middle name or initial associated with a clinical protocol record, used to distinguish protocols with similar names or to reference the individual who authored or owns the protocol within clinical data management systems.

protocol minimumproto_min

The lower boundary value defined within a clinical protocol, such as a minimum dosage threshold, vital sign floor, or lab value cutoff, used to establish acceptable ranges for clinical decision-making and patient safety guardrails.

PreviousPage 534 of 806Next