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 keyqstn_key

A surrogate or natural key that uniquely identifies a specific structured clinical questionnaire within a healthcare data system. Used to link questionnaire responses, scoring results, and metadata across clinical, claims, and care management platforms.

questionnaire languageqstn_lang

The spoken or written language in which a clinical questionnaire is administered to a patient or member. Used in care management and patient engagement systems to ensure health assessments are delivered in the respondent's preferred language, supporting health equity requirements.

questionnaire last nameqstn_last_nm

The family surname of the individual respondent associated with a completed clinical questionnaire. Used in patient-facing health assessments and care management workflows to identify and match questionnaire submissions to the correct member or patient record.

questionnaire legal nameqstn_legal_nm

The official registered full name of the individual respondent as it appears on government-issued identification, associated with a completed clinical questionnaire. Used in health plan enrollment, care management, and clinical assessment workflows for identity verification.

questionnaire levelqstn_lvl

A numeric or coded value indicating the hierarchy position of a questionnaire within a multi-tiered clinical assessment framework. Determines whether the questionnaire represents an initial screening, secondary evaluation, or detailed clinical intake within a structured care program.

questionnaire license numberqstn_lic_nbr

The professional license identifier of the clinician or administrator who authored, approved, or administered a clinical questionnaire. Used in regulatory compliance and credentialing workflows to associate structured assessments with a licensed healthcare professional.

questionnaire marital statusqstn_mar_sts

The marital or domestic partnership status of the patient or member respondent at the time a clinical questionnaire was completed. Captured in health risk assessments and social determinants of health screenings to support whole-person care planning.

questionnaire master identifierqstn_mstr_id

The enterprise-level master identifier that uniquely links a clinical questionnaire to a patient or member record across all systems within a healthcare organization. Used in master patient index matching to ensure consistent identification across clinical, claims, and care management platforms.

questionnaire maximumqstn_max

The upper boundary value defined for a scored or ranged response field within a clinical questionnaire. Used in health risk assessments and clinical scoring tools to validate responses, trigger alerts, and calculate composite scores such as PHQ-9 or HRA risk ratings.

questionnaire medical record numberqstn_mrn

The facility-assigned medical record number of the patient linked to a completed clinical questionnaire. Used to associate structured assessment responses with the correct patient record in EHR and clinical data warehouse environments for longitudinal care tracking.

questionnaire middle nameqstn_mid_nm

The middle name or initial of the individual respondent associated with a clinical questionnaire submission. Used in patient identity matching workflows within health assessments and care management systems to disambiguate records with similar first and last names.

questionnaire minimumqstn_min

The lower boundary value defined for a scored or ranged response field within a clinical questionnaire. Used in health risk assessments and clinical scoring tools to validate response inputs, enforce data quality rules, and calculate composite clinical risk scores.

questionnaire mobileqstn_mob

The mobile phone number of the patient or member respondent associated with a clinical questionnaire. Used in care management and outreach workflows to support SMS-based questionnaire delivery, appointment reminders, and follow-up communications tied to health assessment results.

questionnaire modified byqstn_mod_by

The system username or user identifier of the individual who last updated a clinical questionnaire record. Used in audit trail and data governance workflows to maintain accountability for changes made to structured assessment content, scoring rules, or patient responses.

questionnaire modified dateqstn_mod_dt

The calendar date on which a clinical questionnaire record was last updated in the healthcare data system. Used in data governance, audit logging, and longitudinal care tracking to identify when changes to questionnaire content, scoring, or patient responses were made.

questionnaire modified timeqstn_mod_tm

The timestamp indicating the exact time a clinical questionnaire record was last updated in the healthcare data system. Used alongside the modified date in audit trail and data lineage workflows to provide a precise record of when questionnaire data was altered or resubmitted.

questionnaire nameqstn_nm

The human-readable display label assigned to a clinical questionnaire, such as PHQ-9 Depression Screener or Annual Health Risk Assessment. Used in care management platforms, clinical portals, and reporting systems to identify and present structured assessments to clinicians and administrators.

questionnaire numberqstn_nbr

A system-assigned or externally defined numeric reference that uniquely identifies a clinical questionnaire instance or form version. Used in clinical data management and care management workflows to track, retrieve, and report on specific questionnaire submissions or assessment versions.

questionnaire onset dateqstn_onset_dt

The date on which the patient or member first reported symptoms or conditions that prompted initiation of a structured clinical questionnaire. Captured in disease management and care coordination workflows to establish the timeline of symptom onset relative to assessment and intervention activities.

questionnaire oxygen saturationqstn_o2sat

Records the peripheral oxygen saturation (SpO2) percentage captured within a clinical questionnaire, typically collected via pulse oximetry during patient assessments, triage screenings, or chronic disease monitoring workflows to evaluate respiratory and cardiovascular status.

PreviousPage 183 of 325Next