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 datetimesymp_dttm

Combined date and time value capturing the precise moment a patient-reported symptom finding was recorded in EHR or clinical event systems. Data engineers use this field for high-resolution temporal sequencing of symptom events, supporting real-time clinical alerting and time-series analytics pipelines.

symptom dea numbersymp_dea_nbr

The Drug Enforcement Administration registration number of the prescribing clinician associated with a symptom-driven prescription encounter. Recorded in clinical and pharmacy systems to ensure regulatory compliance when controlled substances are prescribed as part of symptom treatment plans, supporting DEA audit requirements.

symptom death datesymp_death_dt

Date of patient death associated with a symptom-linked clinical record in EHR, mortality registries, and claims systems. Data engineers use this field to flag terminal events in symptom datasets, supporting survival analysis, mortality risk modeling, and HEDIS quality measure calculations.

symptom deductible amountsymp_ded_amt

The dollar amount applied toward a patient's annual insurance deductible for a symptom-related healthcare service before the health plan begins covering costs. Captured in claims adjudication systems to track member cost accumulation and determine when plan benefits become active for symptom-driven encounters.

symptom deleted datesymp_del_dt

The date on which a patient-reported symptom record was marked as deleted or logically removed from the active clinical dataset. Retained in audit and data governance systems to support record lifecycle management, regulatory compliance, and historical analysis of symptom documentation changes within the EHR.

symptom deleted indicatorsymp_del_ind

A binary flag indicating whether a patient-reported symptom record has been logically deleted from active clinical use without being permanently purged from the database. Used in EHR and data warehouse systems to filter inactive records from clinical views while preserving the data for audit and compliance purposes.

symptom descriptionsymp_desc

Textual explanation of a patient-reported symptom finding as captured in EHR clinical notes, patient-reported outcome systems, and intake forms. Data engineers use this field in NLP and text mining workflows to standardize free-text symptom narratives into structured, codeable clinical data elements.

symptom detailsymp_dtl

Granular clinical information associated with a patient-reported symptom finding stored in EHR and clinical documentation systems, including onset, severity, and duration attributes. Data engineers use this field to enrich symptom records with contextual metadata required for clinical phenotyping and risk stratification models.

symptom discharge datesymp_dsch_dt

Hospital or facility release date tied to a patient-reported symptom finding in EHR and inpatient claims systems. Data engineers use this field alongside admission dates to calculate length-of-stay metrics for symptom-driven encounters, supporting DRG analysis and inpatient utilization reporting pipelines.

symptom due datesymp_due_dt

The target date by which a clinical action, follow-up assessment, or care task related to a patient-reported symptom is expected to be completed. Used in care management and clinical workflow systems to trigger reminders, monitor timely intervention, and support quality metrics for symptom follow-up adherence.

symptom durationsymp_dur

The measured length of time a patient has been experiencing a reported symptom prior to or during the clinical encounter, expressed in minutes, hours, days, or weeks. A critical clinical descriptor used to differentiate acute from chronic presentations, guide diagnostic reasoning, and inform treatment urgency and planning.

symptom effective datesymp_eff_dt

Active beginning date indicating when a patient-reported symptom finding becomes clinically valid within EHR, care management, and health plan systems. Data engineers use this field to apply date-range filters in symptom queries, ensuring temporally accurate cohort selection and longitudinal member health tracking.

symptom emailsymp_eml

Electronic mail address associated with a patient-reported symptom record in EHR or patient portal systems. Used by data engineers to route symptom alerts, patient communications, and clinical notifications across care coordination platforms and telehealth integrations.

symptom emergency indicatorsymp_emerg_ind

A flag designating that a patient-reported symptom meets criteria for emergency-level care, triggering expedited triage, immediate clinical intervention protocols, or emergency department routing. Used in clinical information systems to prioritize patient flow, activate rapid response workflows, and support emergency care quality reporting.

symptom end datesymp_end_dt

The date a patient-reported symptom was resolved or ceased, captured in EHR clinical documentation and claims systems. Critical for data engineers calculating symptom duration, episode-of-care analytics, and longitudinal patient health trend reporting across clinical datasets.

symptom end timesymp_end_tm

The recorded clock time at which a patient-reported symptom resolved or ceased. Used in clinical documentation to calculate symptom duration, assess treatment response, and establish temporal patterns in EHR encounter and triage records.

symptom enrollment statussymp_enrl_sts

Indicates whether a documented symptom is actively tracked, resolved, or closed within a clinical monitoring program or care management workflow. Used to manage longitudinal symptom surveillance across patient encounters in EHR and disease management systems.

symptom entered bysymp_ent_by

Identifies the clinician, staff member, or system user who recorded the patient-reported symptom into the clinical documentation system. Used for audit trail purposes and accountability tracking in EHR workflows and clinical data quality management processes.

symptom ethnicitysymp_ethn

Records the patient's self-reported ethnicity at the time of symptom documentation. Used in clinical and epidemiological analysis to identify health disparities, population-level symptom patterns, and social determinants of health within EHR and public health reporting systems.

symptom expiration datesymp_exp_dt

The date after which a documented patient-reported symptom record is considered invalid or outdated within EHR and clinical data systems. Data engineers use this field to filter stale symptom records during ETL processes and ensure analytic accuracy in population health pipelines.

PreviousPage 699 of 806Next