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 account numbersymp_acct_nbr

A unique identifier linking a documented patient-reported symptom to a specific patient account or encounter record within the clinical or billing system. Enables cross-referencing of symptom documentation against encounter claims, treatment records, and financial transactions for care coordination and audit purposes.

symptom active indicatorsymp_actv_ind

A binary flag indicating whether a patient-reported symptom is currently active and ongoing at the time of documentation. Used in clinical records to distinguish between symptoms presently affecting the patient and those that have resolved, supporting accurate problem list maintenance and clinical decision-making.

symptom active statussymp_actv_sts

A coded status value representing the current clinical state of a patient-reported symptom, such as active, resolved, in remission, or chronic. Provides more granular tracking than a binary indicator, supporting longitudinal symptom management and enabling detailed reporting on symptom progression over time.

symptom addresssymp_addr

Physical location data associated with a patient-reported symptom finding, captured in EHR and clinical documentation systems. Used by data engineers to geocode symptom onset locations, enabling population health analytics and epidemiological surveillance workflows.

symptom adjustment amountsymp_adj_amt

A financial value representing contractual write-offs, corrections, or modifications applied to charges associated with an encounter where a specific symptom was documented. Used in revenue cycle processing to reconcile billed amounts with allowable reimbursement for visits driven by symptom-based diagnoses.

symptom admission datesymp_admn_dt

The hospital or facility entry date tied to a patient-reported symptom finding, stored in EHR and claims systems. Data engineers use this field to calculate symptom-to-admission lag times, supporting clinical quality metrics and care pathway analysis in inpatient workflows.

symptom agesymp_age

The patient's age at the time a specific symptom was first documented or reported. Used in clinical analytics and epidemiological research to analyze symptom onset patterns across age cohorts, supporting population health studies and age-stratified quality reporting for symptom prevalence and management.

symptom allowed amountsymp_alwd_amt

The maximum reimbursable dollar amount approved by a payer for services rendered in connection with a patient-reported symptom. Represents the contracted rate applicable to the encounter or claim line associated with the symptom's evaluation and management, used in revenue cycle reconciliation.

symptom amountsymp_amt

Monetary value associated with a patient-reported symptom finding, appearing in claims and billing systems where symptoms drive cost attribution. Data engineers use this field to link symptom documentation to reimbursement amounts, supporting financial reconciliation and cost-of-care reporting.

symptom approval statussymp_appr_sts

The authorization or clinical review state assigned to a documented patient-reported symptom, indicating whether it has been reviewed, approved, or validated by a clinician or supervisor. Used in clinical documentation workflows to ensure symptom records meet quality and completeness standards before finalization.

symptom approved bysymp_appr_by

The identifier or name of the clinician, supervisor, or system user who reviewed and approved the documentation of a patient-reported symptom. Maintains an audit trail of clinical sign-off for symptom records, supporting compliance with documentation standards and accountability in clinical data governance.

symptom arrival timesymp_arrv_tm

The recorded time at which a patient presenting with a specific symptom arrived at the care setting, such as an emergency department or urgent care clinic. Used to calculate door-to-treatment intervals, triage response metrics, and throughput analytics for symptom-driven acute care encounters.

symptom arrived datesymp_arrv_dt

The calendar date on which a patient presenting with a reported symptom arrived at a healthcare facility for evaluation or treatment. Used to establish the encounter timeline, support triage documentation, and enable analysis of care-seeking behavior and symptom onset-to-presentation intervals.

symptom assessmentsymp_asmt

The clinician's documented clinical evaluation of a patient-reported symptom, including characterization of onset, duration, severity, and associated findings. Forms part of the subjective and objective documentation in the clinical note, informing differential diagnosis and treatment planning for the presenting complaint.

symptom balancesymp_bal

Outstanding financial amount tied to a patient-reported symptom finding in claims and billing systems. Data engineers use this field to track unpaid balances associated with symptom-driven encounters, supporting accounts receivable workflows and revenue cycle management analytics.

symptom billed amountsymp_bill_amt

The total dollar amount charged to a payer or patient for healthcare services rendered during an encounter in which the reported symptom was the primary or contributing reason for the visit. Represents the gross charge before contractual adjustments or patient responsibility calculations are applied.

symptom birth datesymp_birth_dt

Date of birth associated with a patient record linked to a symptom finding in EHR and member enrollment systems. Data engineers use this field to validate patient identity during symptom record matching, supporting accurate member attribution and age-stratified clinical reporting.

symptom blood pressuresymp_bp

The systolic and diastolic arterial blood pressure measurement recorded at the time a patient-reported symptom was assessed. Captured as a vital sign to contextualize the clinical presentation, support differential diagnosis, and monitor hemodynamic status in relation to the documented symptom.

symptom cancelled datesymp_cncl_dt

The date a previously documented patient-reported symptom record was cancelled or voided in the clinical system. Used in EHR workflows to maintain an accurate symptom history timeline, track care plan modifications, and support audit trails when symptom entries are rescinded or recorded in error.

symptom categorysymp_cat

Grouping classification assigned to a patient-reported symptom finding within EHR, clinical decision support, and population health platforms. Data engineers use this field to aggregate symptoms into clinical domains such as respiratory or musculoskeletal, enabling cohort analysis and disease surveillance queries.

PreviousPage 697 of 806Next