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 chief complaintid_cc

The primary symptom or reason for visit documented at the start of an infectious disease encounter, as reported by the patient. Common examples include fever, productive cough, skin lesions, or night sweats, which guide initial clinical assessment and diagnostic workup for infectious conditions.

infectious disease childid_chld

A subordinate record or entity linked to a parent infectious disease case or encounter, used to represent hierarchical data relationships such as a follow-up visit linked to an index infection event, or a dependent claim line associated with a primary infectious disease hospitalization record.

infectious disease cityid_city

The municipality of residence or care delivery location associated with an infectious disease patient or encounter. Used in geographic disease surveillance, outbreak mapping, and population health reporting to identify regional clusters or trends in infectious disease incidence across service areas.

infectious disease classid_cls

Categorization tier assigned to an infectious disease record, grouping pathogens or conditions by type such as bacterial, viral, fungal, or parasitic. Used in clinical surveillance, public health reporting, and disease management workflows to organize and prioritize treatment protocols.

infectious disease codeid_cd

Standardized alphanumeric identifier assigned to a specific infectious disease diagnosis, typically mapped to ICD-10 or CDC classification systems. Enables consistent tracking, epidemiological surveillance, claims adjudication, and cross-system interoperability for infectious disease encounters.

infectious disease coinsurance amountid_coins_amt

Dollar amount representing the member's percentage-based cost-sharing obligation for infectious disease treatment services after the deductible is met. Captured on medical claims to reflect patient liability for specialist visits, lab testing, or inpatient infectious disease care.

infectious disease commentid_cmt

Unstructured free-text field capturing clinical notes, care coordination details, or administrative remarks specific to an infectious disease case. Used by clinicians and case managers to document nuances not captured in coded fields, supporting continuity of care and disease management.

infectious disease completed dateid_cmpl_dt

Date on which an infectious disease treatment episode, intervention, or reporting requirement was formally completed. Used in care management systems to track treatment course duration, measure outcomes, and close active disease management cases for conditions such as TB or HIV.

infectious disease confidential indicatorid_conf_ind

Flag designating whether an infectious disease record is subject to heightened privacy protections under federal or state law, such as HIV status or STI diagnoses. Governs access controls, data sharing restrictions, and compliance with 42 CFR Part 2 or state confidentiality statutes.

infectious disease copay amountid_cpay_amt

Fixed dollar amount a member is required to pay at the point of service for infectious disease-related care, such as specialist consultations or urgent care visits. Recorded on claims and eligibility systems to reconcile member cost-sharing obligations under the applicable benefit plan.

infectious disease costid_cst

Total expense associated with diagnosing, treating, or managing an infectious disease case, encompassing provider fees, pharmacy costs, laboratory testing, and hospitalization. Used in population health analytics and actuarial modeling to assess financial impact of infectious disease burden.

infectious disease countid_cnt

Numeric value representing the total number of infectious disease occurrences, cases, diagnoses, or related events within a defined population or time period. Used in epidemiological surveillance, quality reporting, and utilization analysis to measure disease prevalence and incidence trends.

infectious disease countryid_ctry

Country of origin or exposure associated with an infectious disease case, critical for identifying travel-related or imported infections such as malaria or typhoid. Used in public health surveillance and contact tracing to determine geographic risk factors and guide appropriate treatment protocols.

infectious disease created byid_crtd_by

Username or system identifier of the user or application that initially created the infectious disease record in the clinical or administrative system. Supports audit trail requirements, data governance accountability, and compliance with healthcare information management standards.

infectious disease created dateid_crtd_dt

Calendar date on which the infectious disease record was first entered into the clinical or administrative system. Used for audit trail integrity, data lineage tracking, and compliance reporting to establish when a case was opened or a diagnosis was first documented.

infectious disease created timeid_crtd_tm

Timestamp indicating the exact time an infectious disease record was created in the system, complementing the created date for full temporal precision. Essential for audit logging, event sequencing, and real-time disease surveillance systems requiring precise case initiation tracking.

infectious disease creatinineid_cr

Serum or urine creatinine laboratory value recorded in the context of an infectious disease encounter, used to assess renal function when prescribing nephrotoxic antimicrobials such as aminoglycosides or vancomycin. Critical for dosing adjustments and monitoring organ function during infection treatment.

infectious disease dateid_dt

General-purpose date field associated with a key event in the infectious disease record, such as diagnosis date, symptom onset, or reportable disease notification date. Context-dependent and used across clinical, epidemiological, and claims systems to anchor disease events to a specific calendar date.

infectious disease datetimeid_dttm

Combined date and time value capturing the precise moment of a key infectious disease event, such as a positive lab result, isolation order, or public health notification. Provides full temporal context required for outbreak investigation, clinical decision-making, and regulatory reporting timelines.

infectious disease dea numberid_dea_nbr

Drug Enforcement Administration registration number associated with a prescriber authorized to prescribe controlled substances used in infectious disease treatment, such as certain antiparasitics or pain management agents. Required for controlled substance prescribing compliance and pharmacy claims adjudication.

PreviousPage 326 of 806Next