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

symptom street addresssymp_st_addr

Street-level address associated with the patient at the time a symptom was reported. Used to support contact tracing, geographic health analysis, care coordination outreach, and demographic verification within clinical and public health symptom tracking systems.

symptom strengthsymp_str

Concentration or dosage strength of a medication or therapeutic agent associated with treatment of a patient-reported symptom. Recorded to ensure accurate medication reconciliation, dosing verification, and pharmacy coordination linked to the symptom encounter record.

symptom subtotalsymp_subtot

Intermediate aggregated value summing specific symptom-related charges, scores, or counts prior to final totalization. Used in clinical billing, composite symptom scoring, and analytics workflows to organize partial calculations within symptom assessment or claims data structures.

symptom surgery datesymp_surg_dt

Calendar date on which a surgical procedure was performed in direct response to or association with a patient-reported symptom. Used to link symptom onset to operative intervention, measure diagnostic-to-surgery intervals, and support surgical outcomes analysis in clinical data systems.

symptom system identifiersymp_sys_id

Unique system-generated key assigned to a patient-reported complaint within clinical documentation systems. Enables consistent tracking and cross-referencing of symptom records across EHR encounters, clinical data warehouses, and downstream analytics platforms throughout the patient care continuum.

symptom targetsymp_tgt

Destination reference linking a patient-reported finding to a treatment goal, care plan objective, or related clinical entity within EHR or care management systems. Data engineers use this field to map symptom data to intervention outcomes and care plan fulfillment tracking pipelines.

symptom taxonomy codesymp_tax_cd

Standardized classification code that categorizes a patient-reported symptom within a structured clinical terminology hierarchy, such as SNOMED CT or ICD. Supports consistent symptom grouping, clinical decision support, population health analytics, and interoperability across healthcare data systems.

symptom temperaturesymp_temp

Recorded body temperature value captured at the time a symptom is documented during a clinical encounter. Used as a vital sign data point to support differential diagnosis, monitor fever-related symptoms, and track physiological changes across inpatient, outpatient, and emergency care settings.

symptom termination datesymp_term_dt

Date on which a patient-reported symptom was documented as resolved, discontinued, or no longer active in the clinical record. Used to calculate symptom duration, measure clinical outcomes, and support longitudinal patient health tracking across episodes of care.

symptom timesymp_tm

Time-of-day value indicating when a patient-reported finding was recorded or experienced, stored in EHR and clinical monitoring systems. Data engineers use this field alongside symptom date fields to construct precise clinical timestamps for intraday event sequencing and adverse event analysis.

symptom timestampsymp_ts

Combined date and time value capturing the exact moment a patient-reported finding was recorded in EHR or clinical data systems. Data engineers use this field as a precise temporal key for event ordering, audit trail construction, and near-real-time clinical data pipeline processing.

symptom titlesymp_ttl

Standardized label or name assigned to a patient-reported symptom within the clinical documentation system. Provides a human-readable descriptor that aligns with clinical terminology standards, enabling consistent identification and communication of symptom data across care teams and health information systems.

symptom totalsymp_tot

Aggregate sum value representing the cumulative count or magnitude of patient-reported findings within an encounter or assessment period in EHR and care management systems. Data engineers use this field to calculate composite symptom burden scores and populate population health dashboards.

symptom total countsymp_tot_cnt

Aggregate number of times a specific symptom has been reported or documented for a patient across clinical encounters within a defined timeframe. Supports pattern recognition, chronic condition monitoring, population health reporting, and clinical research analytics in healthcare data environments.

symptom typesymp_typ

Category classification identifying the nature of a patient-reported finding, such as physical, behavioral, or functional, as coded in EHR and clinical data systems. Data engineers use this field to partition symptom datasets, apply condition-specific analytics logic, and align records to clinical ontologies like SNOMED CT.

symptom unitsymp_unt

Measurement unit associated with a quantifiable patient-reported finding, such as pain scale points or frequency counts, recorded in EHR and clinical assessment systems. Data engineers use this field to normalize symptom values across instruments and ensure dimensional consistency in clinical analytics datasets.

symptom updated datesymp_upd_dt

Timestamp recording the most recent modification made to a patient symptom record within the clinical documentation system. Used to maintain audit trail integrity, track clinical reassessments, and ensure data currency across EHR platforms and integrated health information exchanges.

symptom urgencysymp_urg

Clinically assigned triage level indicating the time-sensitivity with which a reported symptom requires evaluation or intervention. Drives care prioritization workflows in emergency and ambulatory settings, supporting triage protocols, resource allocation decisions, and clinical escalation pathways across care delivery systems.

symptom valuesymp_val

Discrete measured data point representing the magnitude or coded response for a patient-reported finding in EHR and clinical assessment systems. Data engineers use this field to extract quantifiable symptom observations for machine learning model inputs, quality metrics, and longitudinal clinical trend analysis.

symptom versionsymp_ver

Numeric or alphanumeric indicator tracking the iteration of a symptom record following clinical updates or amendments. Supports audit trail management, record versioning integrity, and change history documentation within EHR systems and clinical data repositories across patient care workflows.

PreviousPage 704 of 806Next