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 active indicatorid_actv_ind

A binary flag indicating whether an infectious disease case, condition, or patient record is currently active within the infectious disease specialty system. Used to filter active cases for clinical follow-up, public health reporting, outbreak monitoring, and infection control workflows within healthcare facilities.

infectious disease active statusid_actv_sts

Represents the current activity state of an infectious disease case or patient record, indicating whether the case is under active management, resolved, or closed. Used in infectious disease surveillance, public health reporting, and care coordination to prioritize active cases and maintain accurate disease registry data.

infectious disease addressid_addr

Records the physical location associated with an infectious disease case, which may represent the patient's residential address or exposure site. Used in epidemiological surveillance, outbreak investigation, contact tracing workflows, and public health reporting to identify geographic clusters and support disease containment efforts.

infectious disease adjustment amountid_adj_amt

The dollar value applied to modify an original claim charge for infectious disease specialty services, such as HIV, hepatitis, or sepsis treatment. Represents contractual adjustments, write-offs, or corrections applied during claims adjudication for infectious disease encounters.

infectious disease admission dateid_admn_dt

The calendar date on which a patient was formally admitted to an inpatient facility for treatment of an infectious disease condition such as sepsis, tuberculosis, or HIV-related illness. Used to calculate length of stay and track infectious disease hospitalization trends.

infectious disease ageid_age

The patient age in years at the time of an infectious disease encounter, diagnosis, or treatment event. Used in epidemiological analysis, risk stratification, and population health reporting for conditions such as HIV, hepatitis C, and drug-resistant bacterial infections.

infectious disease allowed amountid_alwd_amt

The maximum dollar amount a payer will reimburse for infectious disease specialty services under a member's benefit plan. Determined by contracted fee schedules or usual and customary rates, this value drives payment calculations for claims involving infectious disease diagnosis and treatment.

infectious disease amountid_amt

A general monetary value associated with an infectious disease specialty transaction, which may represent a payment, cost, or fee tied to services such as antimicrobial therapy, isolation care, or infectious disease specialist consultations recorded in claims or billing systems.

infectious disease approval statusid_appr_sts

The current authorization or review state of a clinical request, prior authorization, or treatment plan submitted for infectious disease specialty services. Indicates whether services such as long-term antibiotic therapy or antiviral treatment have been approved, denied, or are pending payer review.

infectious disease approved byid_appr_by

The identifier or name of the clinical staff member, medical director, or automated system that authorized a treatment plan, prior authorization request, or clinical decision related to infectious disease specialty care such as HIV management or antibiotic stewardship protocols.

infectious disease arrival timeid_arrv_tm

The recorded time at which a patient presenting with infectious disease symptoms arrived at a care setting such as an emergency department or urgent care clinic. Used in infection control monitoring and triage workflow analysis for conditions like sepsis where time-sensitive treatment is critical.

infectious disease arrived dateid_arrv_dt

The calendar date on which a patient arrived at a healthcare facility with a suspected or confirmed infectious disease condition. Used in outbreak surveillance, contact tracing workflows, and emergency department reporting to track infectious disease presentation patterns over time.

infectious disease assessmentid_asmt

The structured or free-text clinical evaluation documented by an infectious disease specialist or treating clinician, summarizing the patient's presenting condition, diagnostic findings, and clinical impression for infections such as sepsis, endocarditis, or opportunistic infections in immunocompromised patients.

infectious disease balanceid_bal

The remaining dollar amount owed on an infectious disease specialty claim or patient account after insurance payments, adjustments, and prior payments have been applied. Represents the outstanding patient or secondary payer liability for services such as infectious disease consultations or antiviral treatment.

infectious disease billed amountid_bill_amt

The gross dollar amount submitted by a provider on a claim for infectious disease specialty services before payer adjustments or contractual discounts are applied. Reflects the provider's standard charge for services such as infectious disease consultations, isolation care, or antimicrobial infusions.

infectious disease birth dateid_birth_dt

The date of birth of a patient receiving infectious disease specialty care. Used to calculate patient age at diagnosis or treatment, support age-based risk stratification, and enable longitudinal tracking of infectious disease conditions such as perinatal HIV or congenital infections across a patient's lifespan.

infectious disease blood pressureid_bp

The systolic and diastolic arterial pressure measurement recorded during an infectious disease encounter. A critical vital sign in infectious disease management, used to detect hemodynamic instability associated with sepsis, septic shock, or systemic inflammatory responses to severe infections.

infectious disease cancelled dateid_cncl_dt

The date on which a scheduled infectious disease appointment, procedure, or authorization was cancelled. Used in care coordination tracking to identify gaps in treatment continuity for patients managing chronic infectious conditions such as HIV, hepatitis C, or tuberculosis requiring ongoing follow-up.

infectious disease categoryid_cat

A classification label that groups infectious disease encounters, diagnoses, or cases by type such as bacterial, viral, fungal, or parasitic infections. Supports population health analytics, disease surveillance reporting, and quality measure stratification across infectious disease programs and public health registries.

infectious disease charge amountid_chrg_amt

The fee assessed by a healthcare provider for a specific infectious disease service or procedure before insurance adjudication. Represents the billable cost of services such as antimicrobial susceptibility testing, infectious disease specialist consultations, or isolation room utilization recorded on a claim.

PreviousPage 325 of 806Next