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 feeid_fee

The charge associated with an infectious disease-related clinical service, consultation, laboratory test, or treatment procedure. Captured in claims and billing systems to support reimbursement processing, cost analysis, and financial reporting for infectious disease care delivered in outpatient, inpatient, or public health settings.

infectious disease first nameid_first_nm

The given name of the patient or individual associated with an infectious disease case record. Used in disease surveillance systems, contact tracing platforms, and clinical registries to identify and distinguish individuals while supporting case management, follow-up outreach, and communicable disease reporting workflows.

infectious disease flagid_flg

A binary or coded indicator used to mark records requiring special attention within an infectious disease dataset, such as confirmed notifiable conditions, high-risk exposures, or cases under public health investigation. Used in surveillance systems and clinical platforms to filter and prioritize case management activities.

infectious disease frequencyid_freq

The administration frequency or recurrence interval for medications, treatments, or monitoring protocols prescribed within an infectious disease care plan. Captures dosing schedules such as daily, twice daily, or weekly intervals to support antimicrobial stewardship and clinical decision-making.

infectious disease full nameid_full_nm

The complete, unabbreviated name of an infectious disease diagnosis, pathogen, or condition as documented in clinical records. Used for display, reporting, and communication purposes across infectious disease surveillance systems, lab reporting workflows, and public health data submissions.

infectious disease genderid_gndr

The biological sex or gender identity of a patient receiving infectious disease treatment or monitoring. Used to support epidemiological analysis, stratify infection risk, guide dosing calculations, and meet public health reporting requirements for communicable disease surveillance programs.

infectious disease glucoseid_gluc

The blood glucose measurement recorded during infectious disease evaluation or treatment. Elevated glucose levels are clinically significant in managing infections such as sepsis or diabetic foot infections, and this value supports monitoring of metabolic status in infectious disease inpatient and outpatient encounters.

infectious disease group numberid_grp_nbr

The insurance group identifier associated with a patient's health plan coverage at the time of an infectious disease encounter. Used to facilitate claims adjudication, verify benefits eligibility, and coordinate billing across payers for infectious disease specialty services and related laboratory testing.

infectious disease hemoglobinid_hgb

The measured hemoglobin concentration in a patient's blood as recorded during an infectious disease encounter. Hemoglobin levels are monitored to assess anemia associated with chronic infections, HIV, tuberculosis, or as a side effect of antimicrobial therapies such as antiretrovirals or antimalarials.

infectious disease history present illnessid_hpi

The structured narrative documenting the onset, duration, character, and progression of a patient's current infectious condition as recorded by an infectious disease clinician. Captures symptom timeline, exposure history, prior treatments, and relevant epidemiological context essential for diagnosis and treatment planning.

infectious disease identifierid_id

The unique alphanumeric key assigned to an infectious disease case, patient record, or encounter within clinical and public health data systems. Enables consistent tracking of cases across infectious disease surveillance platforms, laboratory information systems, and epidemiological reporting databases.

infectious disease indexid_idx

The sequential or ranked position assigned to an infectious disease record, episode, or finding within a clinical dataset or case list. Used to order multiple infection episodes, co-infections, or serial lab results for a single patient within infectious disease management systems.

infectious disease indicatorid_ind

A binary or categorical flag denoting the presence, absence, or status of a specific infectious disease condition, exposure, or clinical finding. Used in infectious disease surveillance, case identification workflows, and quality reporting to trigger alerts or classify patient cohorts for epidemiological analysis.

infectious disease instructionid_instr

The clinical guidance, patient education text, or procedural directions associated with an infectious disease treatment plan or isolation protocol. Includes discharge instructions, antimicrobial therapy directions, infection control precautions, and follow-up care guidance documented in infectious disease clinical records.

infectious disease keyid_key

The reference value used to link or look up infectious disease records across relational data systems, clinical databases, or reporting platforms. Serves as a join key connecting infectious disease encounter data to related laboratory results, pharmacy records, diagnosis codes, and patient demographic information.

infectious disease labelid_lbl

The human-readable display text assigned to an infectious disease diagnosis, condition category, or data field within clinical applications and reporting interfaces. Used to present standardized disease terminology to clinicians, patients, and public health staff in dashboards, reports, and care summaries.

infectious disease languageid_lang

The preferred spoken or written language of a patient receiving infectious disease care, used to ensure accurate communication of diagnoses, treatment instructions, and infection control guidance. Supports language-concordant care delivery and compliance with health equity and patient rights requirements.

infectious disease last nameid_last_nm

The family surname of a patient enrolled in or receiving infectious disease specialty services. Used for patient identification, case matching across public health reporting systems, and record linkage in infectious disease surveillance and contact tracing workflows where full identity verification is required.

infectious disease legal nameid_legal_nm

The officially registered full legal name of a patient as documented in infectious disease clinical records and public health systems. Used for identity verification, mandatory communicable disease reporting to health departments, insurance billing, and legal documentation associated with infectious disease treatment.

infectious disease levelid_lvl

The severity classification, acuity tier, or hierarchical position assigned to an infectious disease diagnosis or care episode. Used to stratify patients by infection severity, guide triage and treatment intensity decisions, and support risk-adjusted reporting in infectious disease quality measurement programs.

PreviousPage 328 of 806Next