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 codeqstn_cd

The unique alphanumeric identifier assigned to a specific clinical or administrative questionnaire, enabling consistent cross-system referencing in EHR, care management, and data warehouse platforms. Used to link questionnaire responses to the correct instrument definition during analysis and reporting.

questionnaire commentqstn_cmt

Free-text narrative entered by a clinician or administrator to provide additional context about a completed or pending questionnaire, such as patient refusal reasons, scoring anomalies, or follow-up notes. Supports clinical documentation and care coordination workflows.

questionnaire completed dateqstn_cmpl_dt

The calendar date on which a patient or clinician fully submitted all required responses in a structured questionnaire instrument. Used to measure assessment timeliness, track care gaps, and support quality reporting in clinical and population health management programs.

questionnaire confidential indicatorqstn_conf_ind

A binary flag that designates whether a questionnaire and its responses are subject to enhanced privacy restrictions, such as behavioral health or substance use screenings governed by 42 CFR Part 2. Controls access and disclosure rules within EHR and data warehouse systems.

questionnaire countqstn_cnt

The total number of questionnaire instances associated with a patient, encounter, or program within a defined time period. Used in population health analytics, care management tracking, and quality measure reporting to assess screening frequency and completion rates.

questionnaire countryqstn_ctry

Identifies the country associated with the questionnaire instrument or the patient population for which it was designed or administered. Relevant in multinational health systems and global clinical trial data management where locale-specific versions of assessment tools are deployed.

questionnaire created byqstn_crtd_by

The user identifier or system account responsible for initially creating the questionnaire record in the clinical or administrative system. Used for audit trail, accountability tracking, and workflow management in EHR and care management platforms.

questionnaire created dateqstn_crtd_dt

The calendar date on which the questionnaire record was first entered into the clinical or administrative system. Used for audit purposes, data lineage tracking, and distinguishing when an assessment instrument or patient-specific questionnaire instance was originally established.

questionnaire created timeqstn_crtd_tm

The timestamp indicating the exact time of day when the questionnaire record was created in the clinical or administrative system. Used alongside the created date for precise audit trail documentation and sequencing of concurrent questionnaire entries within the same date.

questionnaire creatinineqstn_cr

Records the patient's serum or urine creatinine value as captured within a structured clinical questionnaire or lab-integrated assessment, used to evaluate kidney function prior to procedures, medication dosing, or chronic disease management protocols such as CKD monitoring programs.

questionnaire dateqstn_dt

The date on which a structured clinical or administrative questionnaire was administered or associated with a patient encounter. Used to establish the temporal context of assessment responses for longitudinal health tracking, care gap analysis, and quality measure attribution.

questionnaire datetimeqstn_dttm

The combined date and time value capturing precisely when a structured clinical or administrative questionnaire was administered or recorded. Used for accurate sequencing of patient assessments, audit logging, and time-sensitive clinical workflows such as emergency department screenings.

questionnaire dea numberqstn_dea_nbr

The Drug Enforcement Administration registration number associated with a prescriber or facility referenced within a questionnaire context, such as controlled substance use assessments or medication reconciliation instruments requiring prescriber identification for regulatory compliance.

questionnaire death dateqstn_death_dt

Records the date of patient death as captured or referenced within a structured questionnaire instrument, such as end-of-life care assessments or mortality tracking tools. Used in clinical data analysis, quality reporting, and population health outcomes measurement.

questionnaire deleted dateqstn_del_dt

The calendar date on which a questionnaire record was marked as deleted or voided in the clinical or administrative system. Used for audit trail maintenance, data governance, and distinguishing logically removed records from active questionnaire instances in reporting datasets.

questionnaire deleted indicatorqstn_del_ind

A binary flag indicating whether a questionnaire record has been logically removed from active use in the clinical or administrative system without physical deletion. Used in data governance and reporting to exclude voided records while preserving the audit trail of historical questionnaire activity.

questionnaire descriptionqstn_desc

A human-readable text field that explains the purpose, scope, and intended use of a clinical or administrative questionnaire instrument. Used to help clinicians, administrators, and analysts identify the correct assessment tool and understand its clinical context during documentation and reporting.

questionnaire detailqstn_dtl

Granular information associated with a specific questionnaire instance, including individual question responses, scoring components, or supplementary clinical data captured during administration. Used in clinical documentation, outcomes analysis, and detailed patient assessment review workflows.

questionnaire due dateqstn_due_dt

The target date by which a clinical or administrative questionnaire must be completed for a patient, as defined by a care plan, quality program, or regulatory requirement. Used in care management workflows to trigger outreach, track overdue assessments, and support HEDIS or Stars quality measure compliance.

questionnaire effective dateqstn_eff_dt

The date on which a clinical or administrative questionnaire becomes active and valid for use. Defines the start of the period during which the questionnaire may be administered to patients, members, or respondents in health assessments, surveys, or screenings.

PreviousPage 181 of 325Next