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

psychiatric glucosepsych_gluc

Blood glucose level documented within psychiatric care encounters, used to monitor metabolic health in patients prescribed atypical antipsychotics or mood stabilizers that carry elevated risk of hyperglycemia, diabetes, and metabolic syndrome. Critical for ongoing medication safety monitoring.

psychiatric hemoglobinpsych_hgb

Hemoglobin concentration recorded during psychiatric care encounters, used to assess for anemia that may contribute to or worsen psychiatric symptoms such as fatigue, depression, or cognitive impairment. Supports comprehensive metabolic monitoring in mental health treatment plans.

psychiatric labelpsych_lbl

Display text or descriptive identifier associated with a psychiatric care record, encounter, or clinical data element. Used to render human-readable labels in mental health clinical interfaces, reporting dashboards, and care management tools that present psychiatric encounter data.

psychiatric oxygen saturationpsych_o2sat

Peripheral blood oxygen saturation percentage measured during psychiatric care encounters, used to detect respiratory compromise in patients receiving sedating psychotropic medications or those with comorbid pulmonary conditions affecting mental health treatment safety.

psychiatric procedure datepsych_proc_dt

Date on which a psychiatric clinical procedure was performed, such as electroconvulsive therapy, transcranial magnetic stimulation, or psychological testing. Used to sequence treatment timelines, measure intervention intervals, and support clinical documentation in mental health records.

psychiatric pulsepsych_pulse

Heart rate value recorded during psychiatric care encounters, used to monitor cardiovascular effects of psychotropic medications including antipsychotics and stimulants that may cause tachycardia, bradycardia, or arrhythmia. Supports medication safety surveillance in mental health settings.

psychiatric respirationpsych_resp

Respiratory rate recorded during psychiatric care encounters, used to monitor breathing in patients receiving sedating medications or those at risk for respiratory depression. Supports vital sign trending and safety monitoring across inpatient and outpatient mental health settings.

psychiatric surgery datepsych_surg_dt

Date on which a surgical procedure was performed for a patient receiving psychiatric care, used to coordinate mental health treatment around operative events, track post-surgical psychiatric consultations, and document the temporal relationship between surgical interventions and psychiatric episodes.

pulmonology active indicatorpulm_actv_ind

Binary flag indicating whether a pulmonology case, referral, treatment plan, or patient record is currently active within the respiratory specialty care workflow. Used to filter active versus closed pulmonology cases in clinical systems managing lung disease populations such as COPD or asthma.

pulmonology active statuspulm_actv_sts

Categorical status value indicating the current activity state of a pulmonology encounter, referral, or care episode, such as active, inactive, or discharged. Used to manage respiratory specialty care workflows and identify patients currently under pulmonologist supervision for lung conditions.

pulmonology admission datepulm_admn_dt

Date on which a patient was admitted to an inpatient facility or pulmonology specialty unit for respiratory care. Used to calculate length of stay, track acute exacerbation events in conditions such as COPD or pulmonary fibrosis, and align billing records with clinical encounter timelines.

pulmonology agepulm_age

Patient age at the time of a pulmonology encounter or diagnosis, used to stratify respiratory disease risk, apply age-appropriate clinical guidelines, and support population health analytics for lung conditions such as asthma, COPD, and interstitial lung disease across age cohorts.

pulmonology allowed amountpulm_alwd_amt

Maximum reimbursable dollar amount approved by a payer for a pulmonology service or claim, reflecting contracted rates between the insurer and respiratory care provider. Used in claims adjudication and financial reporting to determine patient cost-sharing and provider reimbursement for lung specialty services.

pulmonology amountpulm_amt

Monetary value associated with a pulmonology claim, charge, or financial transaction, representing billed charges, paid amounts, or contractual adjustments for respiratory specialty services. Used in revenue cycle management and cost analysis for pulmonology department financial performance reporting.

pulmonology approval statuspulm_appr_sts

Authorization state of a pulmonology referral, procedure, or prior authorization request, indicating whether respiratory specialty services such as bronchoscopy, pulmonary function testing, or lung biopsy have been approved, denied, or pended by the payer for coverage.

pulmonology approved bypulm_appr_by

Identifier or name of the clinician, administrator, or payer representative who authorized a pulmonology referral, procedure order, or prior authorization request. Used to maintain an audit trail for respiratory specialty service approvals and support accountability in care coordination workflows.

pulmonology arrival timepulm_arrv_tm

Timestamp recording when a patient arrived for a pulmonology clinic visit or respiratory care encounter. Used to calculate wait times, measure care access performance, support operational reporting for pulmonology departments, and establish the start of the clinical encounter timeline.

pulmonology arrived datepulm_arrv_dt

Calendar date on which a patient arrived for a pulmonology appointment or respiratory care visit. Used to confirm encounter attendance, reconcile scheduling records with clinical documentation, and support reporting on pulmonology access and throughput metrics across respiratory care sites.

pulmonology assessmentpulm_asmt

Clinician-authored narrative or structured evaluation documenting findings from a pulmonology encounter, including interpretation of lung function tests, imaging results, and symptom progression for conditions such as COPD, asthma, or pulmonary hypertension. Forms the basis for respiratory treatment planning decisions.

pulmonology balancepulm_bal

The remaining unpaid amount on a pulmonology claim or patient account after payments and adjustments have been applied. Tracks outstanding financial liability for respiratory specialty services including asthma, COPD, and sleep apnea treatment encounters.

PreviousPage 539 of 806Next