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

pulmonology timestamppulm_ts

The combined date and time value capturing when a pulmonology clinical event occurred, such as the exact moment of a spirometry result, respiratory consultation note, or mechanical ventilation adjustment recorded in the patient's clinical record.

pulmonology titlepulm_ttl

The formal designation or heading assigned to a pulmonology record, document, or clinical entry, such as a pulmonary function report title, respiratory care plan label, or specialist consultation document name within the patient's longitudinal health record.

pulmonology totalpulm_tot

The aggregate sum of a measured or counted element within pulmonology care, such as total respiratory therapy sessions, cumulative inhaler doses, or combined pulmonary function test scores recorded across a patient's treatment episodes or reporting period.

pulmonology total countpulm_tot_cnt

The cumulative number of discrete pulmonology occurrences, such as total asthma exacerbations, bronchoscopy procedures, or pulmonary specialist encounters documented for a patient within a defined clinical or administrative reporting timeframe.

pulmonology typepulm_typ

The category classification identifying the specific kind of pulmonology encounter, condition, or intervention, such as obstructive versus restrictive lung disease, acute versus chronic respiratory condition, or inpatient versus outpatient pulmonary care setting.

pulmonology updated datepulm_upd_dt

The most recent date on which a pulmonology clinical record, treatment plan, or diagnostic entry was modified, reflecting changes such as updated spirometry results, revised respiratory diagnoses, or amended pulmonary care plan documentation.

pulmonology urgencypulm_urg

The clinical priority level assigned to a pulmonology encounter or intervention, indicating time-sensitivity such as emergent respiratory failure, urgent asthma exacerbation, or routine chronic COPD management, used to guide care prioritization and resource allocation.

pulmonology valuepulm_val

A specific measured or recorded data point within pulmonology care, such as FEV1 percentage, oxygen saturation level, peak expiratory flow rate, or diffusion capacity result captured during pulmonary function testing or respiratory monitoring of a patient.

pulmonology versionpulm_ver

The iteration number identifying a specific revision of a pulmonology clinical record, treatment protocol, or diagnostic document, enabling tracking of changes to respiratory care plans, updated pulmonary diagnoses, or amended specialist consultation notes over time.

pulmonology zippulm_zip

The postal code associated with a pulmonology care location, patient residence, or referring facility within the respiratory specialty care context, used in geographic analysis of lung disease prevalence, care access, and pulmonology service utilization across regions.

quality admission dateqlty_admn_dt

Date a member was admitted to a facility for a care episode tied to a quality or performance measure, captured in EHR and claims systems. Used in HEDIS, Stars, and value-based care reporting to evaluate adherence to evidence-based admission and treatment standards.

quality discharge dateqlty_dsch_dt

Date a member was discharged from a facility for a quality measure-tracked care episode, recorded in EHR and claims systems. Used in HEDIS, Stars, and value-based contract reporting to assess treatment duration, readmission risk, and care standard compliance metrics.

quality labelqlty_lbl

The descriptive display text assigned to a healthcare quality measure or performance standard, such as a HEDIS measure name, CMS quality indicator label, or accreditation criterion title used in quality reporting dashboards and clinical performance scorecards.

quality procedure dateqlty_proc_dt

The calendar date on which a clinical procedure relevant to a quality measure was performed, such as a mammogram, colonoscopy, or HbA1c test, used to determine measure compliance within the required performance window for regulatory or accreditation reporting.

quality surgery dateqlty_surg_dt

The calendar date on which a surgical procedure relevant to a quality measure was performed, used to evaluate adherence to evidence-based surgical quality standards such as appropriate prophylactic antibiotic timing, venous thromboembolism prevention, or surgical site infection reporting.

questionnaire active indicatorqstn_actv_ind

A binary flag indicating whether a structured clinical questionnaire, such as a patient-reported outcome instrument, depression screening tool, or intake assessment form, is currently enabled and available for use within the clinical workflow or patient engagement system.

questionnaire active statusqstn_actv_sts

The current operational state of a structured clinical questionnaire, indicating whether it is active, inactive, retired, or pending within the healthcare system, governing its availability for patient assessments, clinical screenings, and care coordination workflows.

questionnaire admission dateqstn_admn_dt

The date a patient was admitted to an inpatient facility in association with a clinical questionnaire administration, linking structured assessment tools such as admission screening forms or risk stratification instruments to the specific hospital encounter they were completed during.

questionnaire discharge dateqstn_dsch_dt

The date a patient was discharged from an inpatient facility in association with a clinical questionnaire, linking discharge assessment instruments such as post-hospitalization care coordination surveys or functional status evaluations to the specific inpatient encounter they were completed for.

questionnaire durationqstn_dur

The total elapsed time associated with a clinical questionnaire, representing either the time period over which symptoms being assessed occurred, the administration window for the instrument, or the length of time a patient took to complete the structured assessment tool.

PreviousPage 546 of 806Next