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 death dateid_death_dt

Date on which a patient died in association with or as a result of an infectious disease diagnosis. Used in mortality reporting, epidemiological case fatality rate calculations, public health surveillance, and outcome analysis for conditions such as sepsis, HIV, or reportable communicable diseases.

infectious disease deductible amountid_ded_amt

Dollar amount applied toward a member's annual deductible for infectious disease-related medical services before insurance coverage begins. Captured on claims and explanation of benefits records to track cost-sharing accumulation for services such as specialist visits, diagnostics, or inpatient infectious disease care.

infectious disease deleted dateid_del_dt

Date on which an infectious disease record was logically deleted or inactivated within the system, typically due to data correction, duplicate resolution, or case closure. Supports data integrity auditing, soft-delete workflows, and regulatory retention requirements for clinical and administrative records.

infectious disease deleted indicatorid_del_ind

Flag indicating whether an infectious disease record has been logically removed from the active dataset. A value of 1 or Y marks the record as deleted, allowing historical data retention while excluding it from current clinical reporting, surveillance, and case management workflows.

infectious disease descriptionid_desc

Human-readable text label describing a specific infectious disease condition, pathogen, or clinical classification. Used in disease surveillance systems, case reporting, and clinical decision support to display standardized disease names such as tuberculosis, HIV, or hepatitis C alongside coded identifiers.

infectious disease detailid_dtl

Granular clinical or epidemiological information associated with an infectious disease case or diagnosis. May include transmission route, pathogen subtype, severity classification, or laboratory findings recorded in disease surveillance registries and public health reporting systems.

infectious disease discharge dateid_dsch_dt

The calendar date on which a patient with an infectious disease diagnosis was formally discharged from an inpatient facility. Used in hospital claims, clinical registries, and infection control tracking to measure length of stay and monitor post-discharge outcomes for communicable disease cases.

infectious disease due dateid_due_dt

The target date by which a required action related to an infectious disease case must be completed, such as a follow-up test, treatment milestone, or public health reporting submission. Used in care management workflows and disease surveillance systems to enforce clinical and regulatory timelines.

infectious disease durationid_dur

The measured length of time spanning the onset and resolution of an infectious disease episode, expressed in days, weeks, or months. Used in epidemiological analysis, clinical outcome measurement, and disease surveillance to assess illness severity and treatment effectiveness across patient populations.

infectious disease effective dateid_eff_dt

The date on which an infectious disease diagnosis, treatment protocol, or program enrollment becomes clinically or administratively active. Used in disease registries, care management platforms, and public health systems to establish the start of a reportable condition or intervention period.

infectious disease emailid_eml

The electronic mail address associated with a patient, provider, or public health contact involved in infectious disease case management. Used in disease surveillance systems and care coordination platforms to facilitate secure communication for contact tracing, reporting, and follow-up outreach.

infectious disease emergency indicatorid_emerg_ind

Flag designating that an infectious disease case or exposure event requires urgent clinical or public health response. Used in hospital information systems and disease surveillance platforms to trigger priority workflows, expedited reporting, or immediate infection control measures for high-risk communicable diseases.

infectious disease end dateid_end_dt

The calendar date marking the conclusion of an infectious disease episode, treatment course, or surveillance monitoring period. Used in clinical registries and public health reporting systems to calculate disease duration, measure treatment outcomes, and close active case records in communicable disease tracking platforms.

infectious disease end timeid_end_tm

The precise time at which an infectious disease-related clinical event, isolation period, or treatment intervention concluded. Used alongside the end date in hospital infection control systems and disease surveillance platforms to support accurate duration calculations and clinical workflow documentation.

infectious disease enrollment statusid_enrl_sts

Indicates whether a patient is currently active, inactive, or pending enrollment in an infectious disease management program such as an HIV care continuum, TB treatment program, or hepatitis treatment registry. Used to track patient engagement and program participation across disease management platforms.

infectious disease entered byid_ent_by

The identifier of the user, clinician, or system that originally created or submitted an infectious disease record in a clinical or surveillance system. Used for audit trail purposes in electronic health records, disease registries, and public health platforms to ensure data accountability and traceability.

infectious disease ethnicityid_ethn

The self-reported or administratively recorded ethnic background of a patient diagnosed with an infectious disease. Used in epidemiological surveillance, public health disparity analysis, and disease registry reporting to identify demographic patterns in communicable disease incidence and treatment outcomes across populations.

infectious disease expiration dateid_exp_dt

The date on which an infectious disease-related record, authorization, certification, or program enrollment becomes invalid or inactive. Used in disease management platforms and clinical systems to enforce review cycles, trigger re-enrollment processes, and ensure current clinical or regulatory standing is maintained.

infectious disease external identifierid_ext_id

A unique reference code assigned by an external system, such as a public health registry, laboratory information system, or health information exchange, to identify an infectious disease case or patient record. Used to link and reconcile data across disparate surveillance and clinical platforms.

infectious disease faxid_fax

The facsimile number used to transmit infectious disease case reports, laboratory results, or clinical documentation between healthcare facilities, public health departments, and disease surveillance agencies. Supports mandatory reporting workflows for notifiable communicable diseases requiring rapid inter-agency communication.

PreviousPage 327 of 806Next