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 periodid_prd

The defined time interval associated with an infectious disease event, such as incubation period, infectious period, treatment duration, or surveillance reporting window, used in epidemiological modeling, outbreak investigation, and antimicrobial therapy management.

infectious disease phoneid_ph

The primary telephone contact number associated with a patient, caregiver, or facility involved in an infectious disease case, used for clinical follow-up, contact tracing coordination, lab result notification, and public health outreach in ID management workflows.

infectious disease planid_pln

The documented clinical treatment strategy for an infectious disease patient, encompassing antimicrobial therapy selection, isolation precautions, diagnostic workup, follow-up scheduling, and care coordination decisions recorded in ID encounter notes or care plans.

infectious disease policy numberid_pol_nbr

Unique identifier assigned to an insurance or coverage policy associated with an infectious disease encounter or treatment episode. Used in claims processing and member eligibility systems to link reimbursement requests to specific plan contracts covering infectious disease specialty services.

infectious disease preferred nameid_pref_nm

Standardized display name used to represent an infectious disease diagnosis, organism, or condition within clinical documentation systems. Ensures consistent identification across EHR workflows, lab reporting, and care coordination records when referencing specific infectious disease conditions or pathogens.

infectious disease priceid_prc

Monetary cost associated with an infectious disease treatment, procedure, or service. Captured in claims and billing systems to reflect negotiated rates, fee schedules, or actual charges for infectious disease specialty care, including antimicrobial therapies and diagnostic workups.

infectious disease primary indicatorid_prim_ind

Boolean or coded flag that designates whether an infectious disease diagnosis is the primary condition driving a clinical encounter or inpatient admission. Used in claims coding and clinical documentation to distinguish principal diagnoses from comorbid or secondary infectious conditions.

infectious disease priorityid_prty

Ranked value indicating the urgency or clinical importance assigned to an infectious disease case, treatment order, or public health intervention. Used in care management workflows and case tracking systems to triage patients requiring immediate infectious disease specialist attention or isolation protocols.

infectious disease procedure dateid_proc_dt

Calendar date on which a clinical procedure was performed in the context of an infectious disease encounter, such as a biopsy, incision and drainage, or lumbar puncture. Recorded in claims and EHR systems to establish care timelines and support infection surveillance reporting.

infectious disease pulseid_pulse

Heart rate measurement, in beats per minute, recorded during an infectious disease clinical encounter. Used as a vital sign indicator to assess hemodynamic stability, monitor for sepsis or systemic inflammatory response, and track patient response to antimicrobial treatment over time.

infectious disease quantityid_qty

Numeric count or volume measure related to an infectious disease context, such as the number of antibiotic doses dispensed, colony-forming units identified in a culture, or units of treatment administered. Used in pharmacy, lab, and clinical documentation systems.

infectious disease raceid_race

Patient-reported or recorded racial classification captured during an infectious disease encounter. Used in public health surveillance and epidemiological analysis to identify health disparities in infectious disease prevalence, treatment access, vaccination rates, and clinical outcomes across population groups.

infectious disease rangeid_rng

Defined minimum and maximum values associated with a clinical measurement or laboratory result in an infectious disease context, such as acceptable antibiotic dosing thresholds or reference intervals for infection markers like CRP, procalcitonin, or white blood cell counts.

infectious disease rateid_rt

Calculated unit value in an infectious disease context, such as reimbursement rate per service, infection incidence rate per population, or antimicrobial administration rate per day. Used in claims pricing, epidemiological surveillance, and pharmacy management systems.

infectious disease ratingid_rtg

Scored or ranked assessment applied to an infectious disease case, risk profile, or clinical severity level. Used in care management, quality reporting, and risk stratification systems to evaluate disease acuity, treatment complexity, or patient vulnerability to infectious complications.

infectious disease ratioid_ratio

Proportional relationship between two measured values in an infectious disease context, such as the ratio of infected to exposed individuals in an outbreak, drug-to-pathogen sensitivity ratios, or the proportion of resistant versus susceptible organisms identified in cultures.

infectious disease reasonid_rsn

Narrative or coded explanation documenting why a specific infectious disease-related action was taken, such as the clinical justification for prescribing a restricted antimicrobial, initiating isolation precautions, or ordering a specialized diagnostic test in an infectious disease workup.

infectious disease received dateid_rcvd_dt

Date on which an infectious disease-related document, specimen, referral, or test result was received by a clinical facility or health system. Used in laboratory information systems and care coordination workflows to track turnaround times and ensure timely infectious disease case management.

infectious disease referenceid_ref

External identifier or pointer linking an infectious disease record to a related document, case number, laboratory accession, or external health system entry. Used to cross-reference clinical data across public health registries, laboratory systems, and EHR platforms for infectious disease tracking.

infectious disease resolution dateid_resol_dt

Date on which an infectious disease diagnosis, active infection episode, or related condition was documented as resolved or no longer clinically active. Used in longitudinal patient records, public health case reporting, and care management systems to close infectious disease episodes and track treatment outcomes.

PreviousPage 330 of 806Next