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 legal namesymp_legal_nm

The official legally registered name of the patient associated with a reported symptom record. Used in clinical and administrative systems to ensure accurate patient identity verification, particularly for documentation requiring legal compliance, consent, or formal clinical reporting purposes.

symptom levelsymp_lvl

Hierarchical tier value classifying severity or categorization of a patient-reported symptom within standardized clinical taxonomies used in EHR and clinical decision support systems. Data engineers use this field to normalize symptom severity scoring across heterogeneous source systems during integration.

symptom license numbersymp_lic_nbr

Identifier linking a reported symptom to the licensed clinician who documented it during a clinical encounter. Used in EHR and clinical data systems to maintain accountability and traceability of symptom documentation to the appropriate credentialed healthcare professional.

symptom marital statussymp_mar_sts

Patient's marital status recorded in association with a reported symptom, used in clinical and epidemiological analysis to identify correlations between relationship status and symptom presentation, severity, or frequency within population health and chronic disease management workflows.

symptom master identifiersymp_mstr_id

Enterprise-level unique identifier assigned to a patient-reported symptom, enabling consistent tracking and linkage of the symptom record across disparate clinical systems, EHRs, and data warehouses throughout the patient's longitudinal health record.

symptom maximumsymp_max

Upper boundary value associated with a measurable symptom attribute, such as the highest reported pain scale score or peak frequency of occurrence. Used in clinical documentation to define severity thresholds and guide treatment escalation decisions in patient care workflows.

symptom medical record numbersymp_mrn

Patient's medical record number associated with a documented symptom, linking the symptom record to the patient's health history within a facility's EHR or clinical data system and enabling accurate patient identification across clinical encounters.

symptom middle namesymp_mid_nm

Middle name or initial of the patient associated with a reported symptom, used for accurate patient identification and demographic matching within clinical data systems to reduce duplicate records and ensure symptom documentation is attributed to the correct individual.

symptom minimumsymp_min

Lower boundary value associated with a measurable symptom attribute, such as the lowest recorded pain score or minimum frequency of occurrence. Used in clinical documentation to establish baseline severity and monitor symptom improvement over the course of treatment.

symptom mobilesymp_mob

Mobile phone number of the patient associated with a reported symptom, used to facilitate follow-up communication, remote symptom monitoring, telehealth outreach, and care coordination efforts related to the patient's documented complaint and ongoing clinical management.

symptom modified bysymp_mod_by

Username or system identifier of the clinician or user who last updated a symptom record within the clinical documentation system. Supports audit trail requirements, data governance, and accountability tracking for changes made to patient-reported symptom information.

symptom modified datesymp_mod_dt

Timestamp recording the most recent update to a patient-reported symptom record in EHR or clinical documentation systems. Data engineers rely on this field for incremental data load strategies, change data capture pipelines, and audit trail maintenance in healthcare data warehouses.

symptom modified timesymp_mod_tm

Timestamp recording when a patient-reported symptom record was most recently updated in the clinical system. Used for audit trail maintenance, version control, and data integrity monitoring to ensure accurate longitudinal tracking of changes to symptom documentation.

symptom namesymp_nm

Standardized or free-text display label identifying a specific patient-reported symptom in EHR, clinical survey, and patient-reported outcome systems. Data engineers map this field to clinical terminologies such as SNOMED CT or ICD-10 during normalization and interoperability pipeline development.

symptom notesymp_nt

Clinician or patient-authored annotation providing additional context for a reported symptom in EHR documentation and care management systems. Data engineers treat this as unstructured data requiring NLP processing for integration into structured clinical analytics and quality reporting pipelines.

symptom numbersymp_nbr

Numeric reference value assigned to a patient-reported symptom within clinical documentation, assessments, or EHR systems. Data engineers use this field for referential integrity checks, deduplication logic, and linking symptom records to associated encounter or diagnosis tables in data warehouses.

symptom onset datesymp_onset_dt

Date on which the patient first experienced or reported a symptom, representing a critical clinical data point used to establish disease progression timelines, guide differential diagnosis, and measure symptom duration in longitudinal clinical and population health analysis.

symptom oxygen saturationsymp_o2sat

Peripheral oxygen saturation level recorded in association with a patient-reported symptom, typically measured via pulse oximetry. Used in clinical documentation to assess respiratory status, monitor symptom severity, and inform treatment decisions for conditions affecting pulmonary function.

symptom paid amountsymp_pd_amt

Dollar amount reimbursed or paid by a payer for clinical services associated with the evaluation and management of a patient-reported symptom. Used in claims and billing workflows to reconcile payments against submitted charges and track financial transactions tied to symptom-related encounters.

symptom paid datesymp_pd_dt

Date on which payment was issued by an insurer or payer for services related to the evaluation or treatment of a patient-reported symptom. Used in claims processing and revenue cycle management to reconcile reimbursements and monitor payment timelines.

PreviousPage 701 of 806Next