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 external identifiersymp_ext_id

A unique reference code assigned by an external system, such as a health information exchange or interoperability platform, to identify a specific patient-reported symptom. Enables consistent symptom tracking and data reconciliation across disparate clinical systems and care settings.

symptom faxsymp_fax

The facsimile number associated with the clinical site or provider contact responsible for documenting or following up on a patient-reported symptom. Used in care coordination workflows to route symptom-related communications between facilities and clinical teams.

symptom feesymp_fee

The charge or cost associated with the clinical assessment or management of a documented patient symptom. Used in billing and revenue cycle workflows to link symptom-driven encounters to applicable service fees within healthcare financial and claims processing systems.

symptom first namesymp_first_nm

Captures the given name of the patient associated with the reported symptom record. Used in EHR and clinical data systems to link symptom documentation to the correct patient identity, supporting accurate record matching and continuity of care across encounters.

symptom flagsymp_flg

Binary indicator field marking whether a patient-reported symptom meets a clinically significant threshold in EHR, clinical decision support, or care management systems. Data engineers rely on this field to trigger downstream alerts, quality measure logic, and risk stratification workflows.

symptom frequencysymp_freq

Describes how often a patient experiences a reported symptom, such as intermittent, constant, or episodic occurrences. Used in clinical assessment to characterize symptom burden, guide differential diagnosis, and monitor changes in symptom patterns over time in EHR systems.

symptom full namesymp_full_nm

The complete descriptive name of a patient-reported symptom as documented in the clinical record. Used to provide a standardized, human-readable label for the symptom within EHR displays, clinical summaries, and health information exchange documents shared across care settings.

symptom gendersymp_gndr

Records the patient's gender as documented at the time of symptom reporting. Used in clinical analysis and epidemiological reporting to examine gender-based symptom prevalence and presentation patterns within EHR systems and population health management platforms.

symptom glucosesymp_gluc

The blood glucose measurement recorded in association with a patient-reported symptom, particularly relevant for symptoms suggestive of hypoglycemia or hyperglycemia. Used in clinical documentation to correlate metabolic values with symptom onset and severity in EHR systems.

symptom group numbersymp_grp_nbr

A categorical identifier used to classify or cluster related patient-reported symptoms within a clinical data system. Supports grouping of symptom records for analysis, reporting, and clinical decision support across EHR and population health management platforms.

symptom hemoglobinsymp_hgb

The hemoglobin measurement recorded in conjunction with a patient-reported symptom, particularly relevant for symptoms such as fatigue or dyspnea potentially indicating anemia. Used to correlate laboratory findings with clinical symptom documentation in EHR systems.

symptom history present illnesssymp_hpi

A structured narrative describing the chronological development and context of a patient-reported symptom, including onset, duration, severity, and modifying factors. This is a core component of clinical encounter documentation used by clinicians to guide diagnosis and treatment planning.

symptom identifiersymp_id

Unique primary key assigned to a patient-reported symptom record within EHR, clinical documentation, or patient-reported outcome systems. Data engineers use this field as the join key when linking symptom data to encounters, diagnoses, and treatment records across healthcare data warehouses.

symptom indexsymp_idx

Positional integer value indicating the sequential order of a patient-reported symptom within a clinical encounter or assessment record in EHR systems. Data engineers use this field to preserve symptom ordering during ETL transformations and reconstruct structured clinical assessment outputs.

symptom indicatorsymp_ind

Boolean or binary field denoting the presence or absence of a specific patient-reported symptom in EHR, clinical survey, or patient-reported outcome systems. Data engineers use this field in cohort filtering logic, quality measure calculations, and clinical decision support rule engines.

symptom instructionsymp_instr

Free-text or coded guidance associated with a patient-reported symptom in EHR care plan and patient education systems. Data engineers must handle this field carefully due to its unstructured nature, often requiring NLP parsing for integration into clinical analytics and care coordination platforms.

symptom keysymp_key

A unique system-generated or assigned identifier used as the primary reference value for a patient-reported symptom record in clinical databases. Enables efficient indexing, retrieval, and relational linking of symptom data across EHR tables and health information system data warehouses.

symptom labelsymp_lbl

The standardized display text assigned to a patient-reported symptom for use in clinical interfaces, reports, and patient-facing documentation. Ensures consistent naming conventions across EHR systems and supports clarity in symptom communication among care team members.

symptom languagesymp_lang

Records the language in which the patient reported or described their symptom, or the language used to document symptom information. Used to support accurate clinical communication, interpreter services coordination, and language-appropriate patient education in EHR systems.

symptom last namesymp_last_nm

Captures the family surname of the patient associated with the reported symptom record. Used in clinical data systems to support accurate patient identification, record matching, and linkage of symptom documentation to the correct individual across encounters and facilities.

PreviousPage 700 of 806Next