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

infectious disease license numberid_lic_nbr

The state-issued professional license identifier for a clinician practicing in infectious disease specialty medicine. Used to verify practitioner credentials, support claims processing, meet regulatory reporting requirements, and ensure proper attribution of infectious disease clinical documentation and prescribing activity.

infectious disease marital statusid_mar_sts

The legal relationship status of a patient receiving infectious disease care, captured at the time of enrollment or encounter. Relevant in infectious disease contexts for contact tracing of sexually transmitted infections, insurance coordination of benefits determination, and social determinants of health assessments.

infectious disease master identifierid_mstr_id

The enterprise-level master record identifier that uniquely and persistently identifies a patient across all infectious disease encounters, facilities, and affiliated health systems. Enables longitudinal case tracking, cross-system record matching, and unified patient history aggregation for infectious disease management and public health reporting.

infectious disease maximumid_max

The upper boundary value used in infectious disease clinical measurements, lab reference ranges, or dosing thresholds. Defines the highest acceptable or observed value for metrics such as viral load, temperature, or antibiotic concentration in ID patient management.

infectious disease medical record numberid_mrn

The unique patient identifier assigned within the infectious disease department or clinic, used to link patient records across encounters, lab results, antimicrobial orders, and contact tracing documentation in ID-specific clinical information systems.

infectious disease middle nameid_mid_nm

The middle name or initial of a patient or provider associated with an infectious disease record, used to support accurate patient matching and identity verification across ID clinic encounters, lab requisitions, and reportable disease registries.

infectious disease minimumid_min

The lower boundary value used in infectious disease clinical measurements, lab reference ranges, or dosing thresholds. Defines the lowest acceptable or observed value for metrics such as CD4 count, drug trough levels, or vital sign parameters in ID patient management.

infectious disease mobileid_mob

The mobile phone number associated with a patient or contact in the infectious disease program, used for appointment reminders, contact tracing outreach, medication adherence follow-up, and public health notification in ID care management workflows.

infectious disease modified byid_mod_by

The unique identifier of the user who last updated an infectious disease record, supporting audit trail requirements and data governance in ID clinical systems. Captures clinician, staff, or system account responsible for the most recent change to the record.

infectious disease modified dateid_mod_dt

The calendar date on which an infectious disease record was most recently updated, used to maintain data currency and audit compliance in ID clinical documentation, reportable disease registries, and antimicrobial stewardship tracking systems.

infectious disease modified timeid_mod_tm

The timestamp indicating when an infectious disease record was last updated, providing precise audit trail data for ID clinical documentation, infection control event tracking, and regulatory reporting where time-sensitive record changes require verification.

infectious disease nameid_nm

The standardized or display name of a diagnosed infectious disease, pathogen, or condition, used in clinical documentation, reportable disease registries, antimicrobial stewardship programs, and public health surveillance reporting within ID workflows.

infectious disease noteid_nt

Free-text or structured clinical annotation associated with an infectious disease encounter or record, capturing clinician observations, treatment rationale, isolation precautions, consultation findings, or epidemiological context relevant to ID patient management.

infectious disease numberid_nbr

A unique reference number assigned to an infectious disease case, encounter, or record, used to track and cross-reference ID cases across clinical systems, public health reporting databases, contact tracing workflows, and antimicrobial stewardship programs.

infectious disease onset dateid_onset_dt

The date on which a patient's infectious disease symptoms first appeared or the infection was confirmed to begin, critical for epidemiological investigation, incubation period calculation, contact tracing timelines, and reportable disease case definition compliance.

infectious disease oxygen saturationid_o2sat

The peripheral blood oxygen saturation percentage measured in patients with infectious diseases such as pneumonia, sepsis, or COVID-19, used to monitor respiratory status, guide supplemental oxygen therapy decisions, and assess disease severity in ID clinical settings.

infectious disease paid amountid_pd_amt

The monetary amount reimbursed or paid for infectious disease-related clinical services, procedures, or treatments, used in revenue cycle management to reconcile ID encounter claims against payer remittances and track financial outcomes for ID service lines.

infectious disease paid dateid_pd_dt

The date on which payment was received or posted for an infectious disease-related claim or service, used in revenue cycle reconciliation, accounts receivable aging analysis, and financial reporting for ID department billing and reimbursement tracking.

infectious disease parentid_prnt

The higher-level hierarchical entity linked to an infectious disease record, such as a parent encounter, episode of care, or disease category, used to organize ID case data into structured relationships within clinical and epidemiological data management systems.

infectious disease percentageid_pct

A proportional ratio value associated with an infectious disease metric, such as positivity rate, antimicrobial resistance prevalence, treatment adherence rate, or population infection rate, used in ID surveillance, stewardship reporting, and outcomes analysis.

PreviousPage 329 of 806Next