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 parentsymp_prnt

Foreign key or reference identifying the superior symptom record in a hierarchical classification structure within EHR and clinical terminology systems. Data engineers use this field to build symptom taxonomy trees, support drill-down analytics, and enable parent-child aggregation in clinical reporting.

symptom percentagesymp_pct

Numeric ratio representing relative frequency, severity proportion, or population prevalence of a patient-reported symptom in EHR, clinical trial, and population health systems. Data engineers use this field in risk scoring models, quality benchmarking calculations, and outcomes reporting across clinical datasets.

symptom periodsymp_prd

Defined time span during which a patient-reported symptom was active or observed, captured in EHR clinical documentation and patient-reported outcome systems. Data engineers use this field to compute episode duration metrics, align symptom windows to claims periods, and support longitudinal trend analysis.

symptom phonesymp_ph

Telephone contact number associated with a patient-reported symptom record in EHR or care coordination systems, used for follow-up communications. Data engineers handle this PII field with appropriate masking and tokenization during ETL processing to maintain HIPAA compliance in data pipelines.

symptom plansymp_pln

Clinician-documented treatment or management plan developed in response to a patient-reported symptom, outlining intended interventions, follow-up actions, or referrals. Recorded in the assessment and plan section of clinical notes within EHR systems to guide ongoing patient care.

symptom policy numbersymp_pol_nbr

Health insurance policy number associated with a patient-reported symptom, used to link clinical symptom documentation to the patient's insurance coverage for billing, claims adjudication, and authorization workflows within healthcare revenue cycle and payer systems.

symptom preferred namesymp_pref_nm

Patient's preferred name recorded in association with a reported symptom, used in clinical communication and documentation systems to ensure respectful, person-centered care while maintaining accurate patient identification throughout symptom tracking and encounter workflows.

symptom pricesymp_prc

Charge or cost amount associated with clinical services rendered for the evaluation or treatment of a patient-reported symptom. Used in healthcare billing systems and revenue cycle management to establish the billed amount prior to payer adjudication and patient responsibility determination.

symptom primary indicatorsymp_prim_ind

Flag identifying whether a symptom is the primary presenting complaint driving a clinical encounter or diagnosis. Used in clinical documentation and coding workflows to distinguish the chief complaint from secondary symptoms and ensure accurate diagnosis sequencing for claims and reporting.

symptom prioritysymp_prty

Ranked importance value assigned to a patient-reported symptom within EHR clinical decision support, care management, or triage systems. Data engineers use this field to drive alert sequencing logic, prioritize care intervention workflows, and support acuity-based patient stratification in analytical models.

symptom procedure datesymp_proc_dt

Date on which a clinical procedure was performed in response to or during evaluation of a patient-reported symptom. Used in clinical and claims data to establish the service timeline, support diagnosis-procedure alignment, and ensure accurate billing and medical record documentation.

symptom pulsesymp_pulse

Heart rate measurement recorded in beats per minute at the time a patient-reported symptom was assessed. Captured during clinical encounters to establish baseline vitals and monitor cardiovascular status associated with the presenting complaint in EHR systems.

symptom quantitysymp_qty

Numeric count or volume measure associated with a patient-reported symptom occurrence in EHR and clinical documentation systems, such as frequency or episode count. Data engineers use this field in symptom burden calculations, utilization analytics, and population health severity scoring models.

symptom racesymp_race

Patient-reported racial identity recorded at the time of symptom documentation. Used in clinical and epidemiological analysis to identify health disparities, support population health reporting, and meet federal demographic data collection requirements tied to the symptom encounter.

symptom rangesymp_rng

Minimum and maximum boundary values defining an acceptable or observed span for a patient-reported symptom metric in EHR and clinical decision support systems. Data engineers use this field to implement validation rules, flag out-of-range values during ingestion, and support reference range comparisons in clinical analytics.

symptom ratesymp_rt

Frequency or occurrence rate of a patient-reported finding within a defined timeframe, captured in EHR and clinical data systems. Used by data engineers to normalize symptom burden metrics across patient populations and episodes of care.

symptom ratingsymp_rtg

Standardized numerical or categorical score assigned to a patient-reported symptom to quantify its severity, frequency, or impact on daily function. Commonly uses validated scales such as 0-10 pain scores or Likert scales within clinical documentation systems.

symptom ratiosymp_ratio

Calculated proportional value comparing symptom-related measurements, such as the ratio of symptom frequency to total clinical events or severity index relative to population norms. Used in clinical analytics to assess symptom burden and treatment response patterns.

symptom reasonsymp_rsn

Explanatory text or coded rationale documenting why a patient-reported finding was recorded in EHR or clinical systems. Data engineers use this field to support root cause analysis, clinical decision support logic, and care gap identification across encounters.

symptom received datesymp_rcvd_dt

Calendar date on which a patient-reported symptom complaint was formally received and entered into the clinical system. Used to establish intake timelines, measure care response intervals, and support quality audits tracking time from symptom report to clinical action.

PreviousPage 702 of 806Next