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 subtotalid_subtot

Represents a partial sum of charges, units, or clinical counts associated with infectious disease services before final aggregation. Used in financial reporting, utilization analytics, and bundled payment calculations for infectious disease episodes of care across inpatient and outpatient settings.

infectious disease surgery dateid_surg_dt

Records the date on which a surgical procedure was performed in the context of an infectious disease case, such as debridement for wound infections, abscess drainage, or prosthetic device removal. Used for clinical documentation, infection outcome tracking, and surgical site infection surveillance.

infectious disease system identifierid_sys_id

A system-generated unique key assigned to an infectious disease record within a clinical or surveillance data platform. Enables consistent cross-system referencing, deduplication, longitudinal record linkage, and integration of infectious disease data across EHR, laboratory, and public health reporting systems.

infectious disease targetid_tgt

The destination reference or linked entity associated with an infectious disease case or encounter, such as a treatment goal, surveillance target organism, or care pathway endpoint used in clinical tracking and public health reporting workflows.

infectious disease taxonomy codeid_tax_cd

The standardized classification code identifying the specific infectious disease specialty category, used in clinical and claims systems to classify pathogens, diagnoses, or specialist types according to recognized coding frameworks such as NUCC or SNOMED taxonomy structures.

infectious disease temperatureid_temp

The recorded body temperature measurement for a patient presenting with or monitored for an infectious disease condition, used as a key clinical vital sign indicator for fever detection, disease progression tracking, and treatment response assessment in clinical documentation.

infectious disease termination dateid_term_dt

The date on which an infectious disease episode, treatment protocol, isolation period, or case surveillance record was officially closed or ended, used to calculate disease duration and support epidemiological reporting and care management analytics.

infectious disease timeid_tm

The specific time of day associated with an infectious disease clinical event, such as symptom onset, specimen collection, medication administration, or care encounter, used to sequence events accurately in clinical documentation and outbreak investigation timelines.

infectious disease timestampid_ts

The combined date and time value marking when a specific infectious disease event, record entry, or clinical action occurred, used to establish precise chronological sequencing for patient care timelines, laboratory result tracking, and public health surveillance reporting.

infectious disease titleid_ttl

The formal name or designation assigned to an infectious disease protocol, case record, clinical document, or care plan, used to identify and organize disease-specific records within clinical data systems and ensure consistent labeling across care settings.

infectious disease totalid_tot

The aggregate sum of a quantifiable measure associated with an infectious disease record, such as total treatment days, total prescribed doses, or total lab tests ordered, used in clinical analytics and disease management reporting to assess care intensity and resource utilization.

infectious disease total countid_tot_cnt

The cumulative number of occurrences of a specific infectious disease event, such as total confirmed cases, total readmissions, or total positive cultures within a defined population or time period, used for epidemiological surveillance and quality reporting purposes.

infectious disease typeid_typ

The classification category identifying the nature of the infectious disease, such as bacterial, viral, fungal, or parasitic, used to stratify clinical records, guide treatment selection, and support disease-specific reporting in clinical and public health data systems.

infectious disease unitid_unt

The unit of measure applied to a clinical or laboratory value in an infectious disease record, such as colony-forming units, milligrams per liter, or international units, used to standardize quantitative data across lab results, medication dosing, and diagnostic reporting.

infectious disease updated dateid_upd_dt

The most recent date on which an infectious disease case record, clinical note, treatment plan, or surveillance entry was modified, used to track data currency, support audit trails, and ensure care teams are referencing the most up-to-date clinical information.

infectious disease urgencyid_urg

The clinical priority or time-sensitivity level assigned to an infectious disease case or intervention, such as routine, urgent, or emergent, used to triage patient care, allocate resources, and prioritize public health response actions in outbreak or endemic settings.

infectious disease valueid_val

The quantitative or qualitative result of a clinical measurement, laboratory test, or assessment associated with an infectious disease record, such as a pathogen load, resistance score, or symptom severity rating, used to track disease status and treatment outcomes.

infectious disease versionid_ver

The sequential version number of an infectious disease record, clinical protocol, or case documentation entry, used to manage record revisions, maintain audit history, and ensure that updated clinical guidelines or amended case data are correctly tracked over time.

infectious disease zipid_zip

The five or nine-digit postal code associated with the patient residence or exposure location linked to an infectious disease case, used in geographic disease surveillance, outbreak cluster mapping, and public health intervention targeting at the community level.

instrument active indicatorinst_actv_ind

A binary flag indicating whether a clinical instrument, diagnostic device, or laboratory tool is currently in active use within the healthcare facility, used to manage equipment inventories, support maintenance scheduling, and control which instruments are available for clinical assignments.

PreviousPage 332 of 806Next