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

questionnaire emergency indicatorqstn_emerg_ind

A binary flag identifying whether a clinical questionnaire was administered in the context of an emergency encounter, such as an ED triage screening, crisis mental health assessment, or acute symptom evaluation, used to differentiate urgent from routine structured clinical assessments.

questionnaire history present illnessqstn_hpi

Captures the structured HPI narrative within a clinical questionnaire, documenting the chronological description of a patient's chief complaint, symptom onset, duration, and progression as recorded during a clinical encounter or intake assessment.

questionnaire instructionqstn_instr

Contains the directional guidance text displayed to clinicians or patients when completing a structured clinical questionnaire, specifying how questions should be interpreted, answered, or scored to ensure consistent and valid data collection across encounters.

questionnaire labelqstn_lbl

Stores the human-readable display name assigned to a clinical questionnaire or individual question item, used to identify and present the questionnaire within EHR interfaces, patient portals, and clinical reporting dashboards.

questionnaire noteqstn_nt

Records supplemental annotation text associated with a clinical questionnaire, capturing clinician observations, clarifications, or contextual remarks that accompany structured question responses but fall outside the standardized answer fields.

questionnaire procedure dateqstn_proc_dt

Records the date on which a clinical procedure referenced within a questionnaire was performed, linking structured patient-reported or clinician-entered questionnaire data to specific procedural events in the patient's care timeline.

questionnaire rangeqstn_rng

Defines the permissible minimum and maximum value boundaries for a question response within a clinical questionnaire, enforcing valid data entry for numeric or scaled answers such as pain scores, lab values, or dosage quantities.

questionnaire resultqstn_rslt

Stores the computed or recorded outcome of a completed clinical questionnaire, representing aggregate scores, risk classifications, or individual response values used to inform clinical decision-making and populate the patient's longitudinal health record.

questionnaire routeqstn_rte

Identifies the administration pathway associated with a medication or treatment question within a clinical questionnaire, such as oral, intravenous, or topical delivery, supporting structured documentation of therapy-related patient assessments.

questionnaire surgery dateqstn_surg_dt

Records the date of a surgical procedure referenced within a clinical questionnaire, enabling structured capture of operative history during patient intake, pre-surgical assessments, or post-operative follow-up documentation workflows.

queue active indicatorque_actv_ind

A binary flag indicating whether a work item in a healthcare workflow queue is currently active and eligible for processing, used in care management, utilization review, and clinical operations systems to filter and prioritize pending tasks.

queue active statusque_actv_sts

Represents the current operational state of a work item within a healthcare workflow queue, distinguishing between active, paused, completed, or cancelled states to support task routing and workload management in clinical operations systems.

queue admission dateque_admn_dt

Records the inpatient admission date associated with a work item in a healthcare workflow queue, linking pending clinical or administrative tasks to the specific hospital encounter for which care coordination or utilization review action is required.

queue discharge dateque_dsch_dt

Records the inpatient discharge date associated with a work item in a healthcare workflow queue, used in care management and utilization review systems to track encounter completion and trigger post-discharge follow-up or billing workflow tasks.

queue durationque_dur

Measures the elapsed time a work item has remained in a healthcare workflow queue, from initial creation or assignment to resolution, supporting operational reporting on throughput, bottlenecks, and service-level compliance in clinical workflow systems.

queue emergency indicatorque_emerg_ind

A binary flag designating a work item in a healthcare workflow queue as requiring urgent or emergent attention, used to escalate prioritization in care management, prior authorization, or clinical operations systems for time-sensitive patient cases.

queue history present illnessque_hpi

Captures the HPI narrative attached to a work item in a healthcare workflow queue, providing clinical context about the patient's presenting condition to inform care coordinators, utilization reviewers, or clinical staff processing the queued task.

queue instructionque_instr

Contains directional guidance text associated with a work item in a healthcare workflow queue, specifying required actions, processing steps, or handling rules for clinical or administrative staff assigned to resolve the queued task.

queue labelque_lbl

Stores the human-readable display name assigned to a work item or queue category within a healthcare workflow system, used to identify task types, organize worklists, and present queue items in care management and clinical operations interfaces.

queue noteque_nt

Records free-text annotations added to a work item in a healthcare workflow queue, capturing communication between team members, status updates, or contextual remarks that support the handoff and resolution of clinical or administrative tasks.

PreviousPage 547 of 806Next