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 datepulm_dt

Calendar date associated with a pulmonology clinical event, such as a consultation, pulmonary function test, or bronchoscopy procedure. Used to sequence respiratory care timelines, track disease progression, and measure intervals between lung specialty visits.

pulmonology datetimepulm_dttm

Combined date and timestamp for a pulmonology clinical event, capturing the precise moment of a respiratory procedure, test result, or specialist encounter. Enables accurate sequencing of pulmonary care events and supports time-sensitive respiratory treatment protocols.

pulmonology dea numberpulm_dea_nbr

Drug Enforcement Administration registration number assigned to a pulmonologist, authorizing the prescribing of controlled substances such as opioids used in palliative respiratory care or cough suppression. Required for prescriptions involving Schedule II-V medications in pulmonary treatment plans.

pulmonology death datepulm_death_dt

Date of patient death recorded within a pulmonology clinical context, used to track mortality outcomes for patients with chronic respiratory conditions such as COPD, pulmonary fibrosis, or lung cancer. Supports survival analysis and pulmonary disease outcome reporting.

pulmonology deleted datepulm_del_dt

Date on which a pulmonology record was marked for deletion or removal from active clinical use. Used for audit trail maintenance and data governance in respiratory care systems, ensuring historical accuracy while flagging records no longer valid for clinical decision-making.

pulmonology deleted indicatorpulm_del_ind

Boolean flag indicating whether a pulmonology record has been logically deleted from active clinical use. Allows respiratory care data systems to retain historical records for audit and compliance purposes while excluding them from active patient care workflows and reporting.

pulmonology descriptionpulm_desc

Free-text or structured narrative describing a pulmonology finding, procedure, diagnosis, or clinical note related to respiratory care. Captures clinician observations about lung function, breathing patterns, airway conditions, or treatment rationale within the pulmonology encounter record.

pulmonology detailpulm_dtl

Granular clinical information associated with a pulmonology encounter, including specifics of respiratory findings, spirometry results, imaging interpretations, or bronchoscopy observations. Provides supplementary context beyond summary fields to support comprehensive pulmonary care documentation.

pulmonology discharge datepulm_dsch_dt

Date on which a patient was discharged from inpatient or observation care under pulmonology service. Used to calculate length of stay for respiratory admissions, track readmission risk for conditions such as COPD exacerbations or pneumonia, and coordinate post-discharge pulmonary follow-up.

pulmonology due datepulm_due_dt

Scheduled deadline for a pulmonology-related clinical action, such as a follow-up pulmonary function test, repeat imaging study, or specialist reassessment. Used to manage care gaps and ensure timely monitoring of chronic respiratory conditions like asthma or interstitial lung disease.

pulmonology durationpulm_dur

Length of time associated with a pulmonology clinical event, such as the duration of a bronchoscopy procedure, mechanical ventilation episode, oxygen therapy course, or respiratory symptom onset period. Used to measure treatment exposure and monitor disease progression in lung specialty care.

pulmonology emailpulm_eml

Electronic mail address associated with a pulmonology care team member, patient, or clinical contact used for respiratory care coordination. Supports secure communication regarding pulmonary test results, appointment scheduling, care plan updates, and referral correspondence in lung specialty workflows.

pulmonology emergency indicatorpulm_emerg_ind

Flag identifying a pulmonology encounter or intervention as emergent in nature, such as acute respiratory failure, massive hemoptysis, or status asthmaticus requiring urgent care. Used to prioritize clinical workflows, allocate respiratory therapy resources, and distinguish emergency from routine pulmonary visits.

pulmonology end datepulm_end_dt

Date marking the conclusion of a pulmonology treatment course, therapy period, clinical study enrollment, or care episode. Used to define the boundaries of respiratory treatment intervals, measure outcomes at episode close, and transition patients from active pulmonary management to maintenance care.

pulmonology end timepulm_end_tm

Timestamp marking the conclusion of a pulmonology procedure, test, or clinical encounter, such as the end of a bronchoscopy, pulmonary function testing session, or sleep study. Used to calculate procedure duration and support accurate billing and scheduling in respiratory care settings.

pulmonology entered bypulm_ent_by

Identifier of the clinical staff member who entered or created a pulmonology record in the health information system. Used for accountability, audit trail maintenance, and data quality oversight within respiratory care documentation, capturing whether entry was made by a physician, nurse, or technician.

pulmonology ethnicitypulm_ethn

Ethnicity classification of a patient receiving pulmonology care, used to identify health disparities in respiratory disease prevalence and outcomes. Supports population health analysis for conditions disproportionately affecting specific ethnic groups, such as sarcoidosis, asthma, or occupational lung diseases.

pulmonology expiration datepulm_exp_dt

Date after which a pulmonology-related record, authorization, credential, or clinical order is no longer considered valid. Applies to prior authorizations for pulmonary procedures, physician certifications, standing respiratory therapy orders, or clinical protocol versions used in lung specialty care settings.

pulmonology external identifierpulm_ext_id

Reference identifier assigned to a pulmonology record by an external system such as a referring hospital, health information exchange, or payer platform. Used to match and reconcile pulmonary records across disparate systems, enabling care coordination for patients seen across multiple respiratory care settings.

pulmonology faxpulm_fax

The facsimile number used to transmit records, referrals, and clinical documents to a pulmonologist or pulmonary care facility. Supports care coordination for patients with respiratory conditions such as COPD, asthma, pulmonary fibrosis, and sleep apnea.

PreviousPage 541 of 806Next