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 license numberpulm_lic_nbr

The state-issued professional license number assigned to a pulmonologist, used to verify credentials, validate billing eligibility, and confirm scope of practice. Referenced during provider enrollment, claims adjudication, and regulatory compliance reporting across health systems.

pulmonology marital statuspulm_mar_sts

Records the marital status of a patient receiving pulmonology care. Used in demographic profiling, social determinants of health assessments, and care coordination workflows where household and support context may influence respiratory disease management and treatment planning.

pulmonology master identifierpulm_mstr_id

The enterprise-wide master identifier linking a pulmonology record across multiple clinical and administrative systems. Supports patient matching, longitudinal respiratory care tracking, and deduplication efforts within master patient index and health information exchange environments.

pulmonology maximumpulm_max

Captures the upper threshold value for a pulmonology-related clinical or administrative parameter, such as maximum allowable dosage, peak flow reading, or benefit limit. Used in clinical decision support rules, utilization management, and respiratory care protocol enforcement.

pulmonology medical record numberpulm_mrn

The facility-assigned medical record number uniquely identifying a patient within a pulmonology care setting. Used to link encounter records, diagnostic results, and treatment histories across inpatient, outpatient, and specialty respiratory care visits within a health system.

pulmonology middle namepulm_mid_nm

The middle name or initial of a patient or pulmonologist associated with a respiratory care record. Used in identity verification, duplicate patient detection, and accurate record matching across clinical systems to ensure proper attribution of pulmonology encounters and documentation.

pulmonology minimumpulm_min

Captures the lower threshold value for a pulmonology-related clinical or administrative parameter, such as minimum oxygen saturation thresholds, spirometry baseline values, or benefit floors. Used in clinical decision support, alert triggering, and respiratory care quality monitoring.

pulmonology mobilepulm_mob

The mobile phone number associated with a patient or pulmonology care contact. Used to support appointment reminders, telehealth outreach, care coordination communications, and patient engagement initiatives within respiratory specialty care programs and chronic disease management workflows.

pulmonology modified bypulm_mod_by

Identifies the user or system that last updated a pulmonology record, supporting audit trail requirements and data governance. Used in clinical data integrity reviews, change tracking, and compliance reporting to attribute modifications within respiratory care documentation systems.

pulmonology modified datepulm_mod_dt

Records the calendar date when a pulmonology record was most recently updated. Used in audit logging, data governance reviews, and synchronization processes to track changes to respiratory care documentation, patient records, or clinical workflow configurations across health information systems.

pulmonology modified timepulm_mod_tm

Captures the exact time a pulmonology record was last modified. Used alongside the modified date to provide a precise audit timestamp for changes to respiratory care records, supporting data integrity validation, system reconciliation, and compliance audit requirements.

pulmonology namepulm_nm

The display name associated with a pulmonology record, representing a patient, provider, procedure, or care entity in human-readable format. Used in clinical documentation, reporting dashboards, provider directories, and patient-facing communications within respiratory specialty care systems.

pulmonology notepulm_nt

Free-text or structured annotation associated with a pulmonology encounter, diagnosis, or care record. Captures clinical observations, follow-up instructions, or administrative comments related to respiratory care, supporting care coordination, documentation completeness, and clinical communication across care teams.

pulmonology numberpulm_nbr

A reference number assigned to a pulmonology record, encounter, or transaction for tracking and identification purposes. Used to correlate respiratory care records across clinical, billing, and administrative systems, supporting case management, reporting, and longitudinal care continuity.

pulmonology onset datepulm_onset_dt

Records the date when respiratory symptoms or a pulmonology-related condition first appeared. Used in clinical documentation to establish disease chronology, support diagnosis coding, inform treatment planning, and calculate duration of illness for respiratory conditions such as COPD or asthma.

pulmonology oxygen saturationpulm_o2sat

Records the peripheral blood oxygen saturation (SpO2) percentage measured for a patient under pulmonology care. A critical respiratory vital sign used to monitor hypoxemia, guide supplemental oxygen therapy decisions, assess disease severity, and track clinical response in lung disease management.

pulmonology paid amountpulm_pd_amt

The dollar amount reimbursed for pulmonology services rendered, reflecting actual payment after adjudication of claims. Used in revenue cycle management, cost analysis, and financial reconciliation to track respiratory specialty care reimbursements from payers, patients, or third-party administrators.

pulmonology paid datepulm_pd_dt

The date on which payment was issued for a pulmonology claim or service. Used in revenue cycle management and accounts receivable tracking to monitor reimbursement timelines, identify delayed payments, and reconcile pulmonology billing records against remittance advice from payers.

pulmonology parentpulm_prnt

Identifies the parent entity in a hierarchical relationship for a pulmonology record, such as a parent diagnosis, parent organization, or parent care program. Used to maintain structural data relationships, support rollup reporting, and manage respiratory care program hierarchies within clinical data systems.

pulmonology percentagepulm_pct

Proportional ratio used in pulmonology care contexts, such as percentage of predicted lung function (e.g., FEV1% predicted), treatment response rates, or pulmonologist utilization share within a respiratory care program or claims dataset.

PreviousPage 543 of 806Next