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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

questionnaire termination dateqstn_term_dt

Date on which a clinical questionnaire or assessment instrument becomes inactive or is officially retired from use. Used to manage the lifecycle of standardized screening tools, surveys, and patient-reported outcome measures, ensuring only current versions are administered in clinical workflows.

questionnaire timeqstn_tm

Time of day at which a structured clinical questionnaire or patient assessment was administered or completed. Captures the clock time component separately from the date, supporting analysis of response patterns, workflow timing, and clinical documentation sequencing in care settings.

questionnaire timestampqstn_ts

Combined date and time value recording when a structured clinical questionnaire or patient-reported outcome assessment was completed or submitted. Supports audit trail requirements, response time analysis, and longitudinal tracking of patient assessment data across care episodes.

questionnaire titleqstn_ttl

Official name or formal designation assigned to a structured clinical questionnaire, screening tool, or patient-reported outcome instrument. Used to identify and distinguish standardized assessments such as PHQ-9, GAD-7, or custom intake forms within clinical documentation and reporting systems.

questionnaire totalqstn_tot

Aggregate numeric value representing the sum of scored responses across all items within a structured clinical questionnaire or standardized assessment instrument. Used to calculate composite scores for validated tools such as depression scales, pain indices, or functional status measures.

questionnaire total countqstn_tot_cnt

Total number of individual questionnaire instances, items, or completed responses associated with a clinical assessment instrument. Used to track administration volume, measure completion rates, and support quality reporting across patient populations or care programs using standardized screening tools.

questionnaire typeqstn_typ

Classification category identifying the nature and purpose of a structured clinical questionnaire, such as intake assessment, symptom screening, patient satisfaction survey, or functional status evaluation. Drives routing logic, scoring algorithms, and reporting groupings within clinical data management systems.

questionnaire unitqstn_unt

Unit of measure associated with a response value captured within a structured clinical questionnaire, such as pounds, millimeters of mercury, or numeric scale points. Ensures consistent interpretation of quantitative responses across different clinical assessment instruments and reporting contexts.

questionnaire updated dateqstn_upd_dt

Date on which a structured clinical questionnaire, its content, scoring logic, or associated metadata was most recently modified. Tracks revision history of assessment instruments to ensure version control compliance and accurate longitudinal comparisons of patient-reported outcome data over time.

questionnaire urgencyqstn_urg

Indicator of the time sensitivity or clinical priority level assigned to a structured questionnaire requiring completion, such as routine, urgent, or emergent. Guides workflow prioritization and escalation protocols in care management systems when patient responses require timely clinical follow-up or intervention.

questionnaire versionqstn_ver

Sequential version identifier assigned to a structured clinical questionnaire to distinguish iterations resulting from content updates, scoring changes, or regulatory revisions. Ensures responses are evaluated against the correct instrument version and supports longitudinal data integrity in patient-reported outcome tracking systems.

questionnaire zipqstn_zip

Postal zip code value captured within a structured clinical questionnaire, typically reflecting the patient's residential location at the time of assessment. Used for geographic analysis of health outcomes, social determinants of health screening, and population health reporting across care programs.

queue addressque_addr

Physical or logical destination address associated with a work item held in a clinical or administrative processing queue, such as a department routing address or system endpoint. Used to direct tasks, authorizations, or clinical reviews to the appropriate team or workflow stage within healthcare operations systems.

queue ageque_age

Elapsed time, typically expressed in hours or days, that a work item has been waiting in a clinical or administrative processing queue without resolution. Used to monitor workflow bottlenecks, enforce service level agreements, and prioritize tasks in care management, utilization review, and claims processing queues.

queue allowed amountque_alwd_amt

Maximum reimbursable dollar amount associated with a claim, authorization request, or financial transaction held in an administrative processing queue. Reflects payer-determined contracted rates and is used to validate, adjudicate, or escalate queue items requiring financial review within healthcare revenue cycle workflows.

queue amountque_amt

Monetary value associated with a work item held in a clinical or administrative processing queue, such as a pending claim amount, authorization value, or billing transaction total. Used to prioritize high-value queue items and support financial reconciliation within revenue cycle management workflows.

queue approval statusque_appr_sts

Current authorization state of a work item in a clinical or administrative processing queue, indicating whether the item is pending review, approved, denied, or returned for additional information. Drives downstream workflow routing for prior authorizations, referrals, and claims adjudication processes within healthcare operations systems.

queue approved byque_appr_by

Identifier of the user, clinician, or system that granted approval for a work item held in a clinical or administrative processing queue, such as a prior authorization, referral, or care management task. Supports audit trail documentation and accountability tracking within utilization management and healthcare operations workflows.

queue arrival timeque_arrv_tm

Timestamp recording when a work item, patient task, or clinical transaction entered a processing queue within a healthcare operations system. Used to calculate queue wait times, measure workflow throughput, enforce service level agreement compliance, and identify processing delays in care management or revenue cycle queues.

queue arrived dateque_arrv_dt

The date a work item or task entered the processing queue in a healthcare workflow management system. Used in clinical operations and revenue cycle management to measure queue aging, prioritize work assignments, and monitor service level compliance across departments.

PreviousPage 186 of 325Next