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 coinsurance amountproto_coins_amt

The dollar amount representing the member's coinsurance obligation for services rendered under a specific clinical protocol. Captured in claims and benefits administration systems to calculate patient cost-sharing after the deductible has been met per plan design.

protocol commentproto_cmt

A free-text field capturing clinician or administrative notes associated with a specific clinical protocol, such as exceptions, modifications, or care instructions. Supports clinical documentation workflows where structured fields alone cannot capture relevant protocol-specific context.

protocol completed dateproto_cmpl_dt

The calendar date on which a clinical protocol was fully completed or all required steps were fulfilled. Used in care management and clinical data systems to measure protocol adherence, track care timelines, and support quality reporting and outcome analysis.

protocol confidential indicatorproto_conf_ind

A flag indicating that a clinical protocol record contains sensitive or restricted information requiring additional privacy controls, such as behavioral health or substance use treatment protocols. Used in EHR and data governance systems to enforce access restrictions per HIPAA and 42 CFR Part 2 regulations.

protocol copay amountproto_cpay_amt

The fixed dollar amount a member is required to pay at the time of service for care delivered under a specific clinical protocol. Recorded in claims and benefits systems to reflect patient cost-sharing obligations as defined by the member's health plan benefit structure.

protocol countproto_cnt

The total number of times a specific clinical protocol has been initiated, completed, or referenced within a defined timeframe or patient population. Used in clinical analytics and care management systems to measure protocol utilization, frequency of use, and population health trends.

protocol countryproto_ctry

The country associated with a clinical protocol record, used when protocols originate from or apply to international treatment guidelines, clinical trials, or cross-border care programs. Supports data governance and regulatory compliance in multinational healthcare data environments.

protocol created byproto_crtd_by

The username or system identifier of the individual or automated process that originally created a clinical protocol record. Used in audit trail and data governance workflows to establish accountability, support change management, and maintain record integrity in clinical information systems.

protocol created dateproto_crtd_dt

The calendar date on which a clinical protocol record was first created in the system. Used in clinical data warehouses and EHR systems to establish record provenance, support audit trails, and enable time-based analysis of protocol development and implementation patterns.

protocol created timeproto_crtd_tm

The timestamp recording the exact time a clinical protocol record was first entered into the system. Combined with the created date, this value supports precise audit logging, workflow sequencing, and event-based reporting in clinical information and data warehouse systems.

protocol creatinineproto_cr

The serum creatinine value associated with a clinical protocol, used to assess renal function before administering nephrotoxic medications or contrast agents. Captured in clinical data systems to support protocol eligibility screening, dose adjustment calculations, and safety monitoring workflows.

protocol dateproto_dt

The primary calendar date associated with a clinical protocol record, representing the date the protocol was initiated, ordered, or became effective. Used in clinical data systems for scheduling, longitudinal care tracking, and time-based protocol compliance and outcomes reporting.

protocol datetimeproto_dttm

The combined date and time value marking a key event in a clinical protocol lifecycle, such as initiation, modification, or completion. Used in clinical data warehouses and EHR systems to enable precise event sequencing, audit logging, and time-sensitive clinical workflow analysis.

protocol dea numberproto_dea_nbr

The Drug Enforcement Administration registration number associated with a clinical protocol involving controlled substances. Used in pharmacy and prescribing systems to verify prescriber authorization, ensure regulatory compliance, and maintain DEA-required documentation for controlled substance protocols.

protocol death dateproto_death_dt

The recorded date of a patient's death as it relates to a clinical protocol, used to mark protocol termination and support mortality outcome tracking. Captured in clinical data systems for protocol closure workflows, survival analysis, and population health and quality reporting purposes.

protocol deductible amountproto_ded_amt

The dollar amount applied toward a member's annual deductible for services rendered under a specific clinical protocol. Recorded in claims and benefits administration systems to accurately track cost-sharing accumulation and determine when coinsurance or plan coverage becomes applicable.

protocol deleted dateproto_del_dt

The calendar date on which a clinical protocol record was logically deleted or inactivated in the system. Used in clinical data management workflows to maintain audit history, support data retention compliance, and distinguish inactive records from active protocols in reporting and analytics.

protocol deleted indicatorproto_del_ind

A flag denoting that a clinical protocol record has been logically removed or inactivated without physical deletion from the database. Used in clinical data systems to preserve audit history, filter active records from reporting queries, and support data retention and governance requirements.

protocol descriptionproto_desc

The human-readable name and narrative explanation of a clinical protocol, detailing its purpose, scope, and intended use. Used in clinical data warehouses and care management systems to identify and communicate standardized treatment or care pathway procedures.

protocol detailproto_dtl

Granular specifications of a clinical protocol including step-by-step instructions, required interventions, decision criteria, and clinical parameters. Supports care teams in executing standardized treatment pathways consistently across patient populations in clinical workflow systems.

PreviousPage 532 of 806Next