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 charge amountsymp_chrg_amt

The gross billed charge associated with the clinical evaluation or treatment of a reported patient symptom. Captured in billing and revenue cycle systems to support claims adjudication, cost tracking, and financial reconciliation of symptom-driven encounters across inpatient and outpatient settings.

symptom chief complaintsymp_cc

The primary symptom or concern stated by the patient at the time of the clinical encounter, documented in their own words or as paraphrased by the clinician. Serves as the chief driver for triage decisions, diagnostic workup, clinical coding, and care pathway selection in EHR documentation workflows.

symptom childsymp_chld

Subordinate hierarchical relationship identifier for a patient-reported symptom finding within EHR ontology and clinical terminology systems. Data engineers use this field to traverse symptom hierarchies in structured clinical data models, supporting granular symptom rollup and parent-child relationship mapping.

symptom citysymp_city

The city or municipality associated with where a patient's symptom was reported, observed, or treated. Used in public health surveillance, epidemiological tracking, and geographic analysis of symptom patterns to identify regional disease trends and allocate clinical resources appropriately.

symptom classsymp_cls

Classification tier assigned to a patient-reported symptom finding in EHR and clinical coding systems, often aligned to ICD or SNOMED hierarchies. Data engineers use this field to segment symptoms by severity or system involvement, enabling tiered reporting and clinical decision support rule application.

symptom codesymp_cd

Standardized classification value representing a patient-reported symptom finding, typically drawn from ICD-10-CM, SNOMED CT, or proprietary coding schemes in EHR and claims systems. Data engineers use this field as a primary join key for symptom-to-diagnosis mapping and clinical analytics pipelines.

symptom coinsurance amountsymp_coins_amt

The portion of the symptom-related service cost that a patient is responsible for paying after the insurance deductible has been met, calculated as a percentage of the allowed amount. Used in claims processing and patient billing systems to determine member cost-sharing obligations for symptom-driven encounters.

symptom commentsymp_cmt

Free-text notation field capturing supplemental clinical context for a patient-reported symptom finding in EHR and clinical documentation systems. Data engineers use this field in NLP pipelines to extract unstructured symptom details not captured in coded fields, enriching structured clinical datasets.

symptom completed datesymp_cmpl_dt

The date on which the clinical assessment, treatment, or documentation workflow associated with a patient-reported symptom was marked as fully completed. Used in care management systems to track resolution timelines, measure clinical throughput, and support quality reporting for symptom follow-up compliance.

symptom confidential indicatorsymp_conf_ind

A flag indicating that a patient-reported symptom record contains sensitive information requiring restricted access, such as symptoms related to mental health, substance use, sexual health, or domestic violence. Governs visibility controls in EHR systems to comply with HIPAA and applicable state privacy regulations.

symptom contactsymp_cntct

Communication point or contact reference associated with a patient-reported symptom finding in EHR and care coordination systems. Data engineers use this field to link symptom records to provider or patient contact events, supporting care management workflows and outreach program analytics.

symptom copay amountsymp_cpay_amt

The fixed out-of-pocket dollar amount a patient is required to pay at the point of service for a visit or encounter driven by a reported symptom, as defined by their health plan benefit structure. Captured in claims and billing systems to reconcile member payments against insurance plan cost-sharing requirements.

symptom costsymp_cst

The total direct cost incurred by the healthcare system or payer for diagnosing, managing, or treating a patient-reported symptom, including labor, supplies, and ancillary services. Used in clinical analytics, population health management, and value-based care reporting to evaluate the financial burden of symptom-driven utilization.

symptom countsymp_cnt

Numeric value representing the total occurrences of a patient-reported symptom finding within EHR, claims, and population health systems. Data engineers use this field to measure symptom frequency per encounter or member, supporting chronic disease burden scoring and utilization trend reporting.

symptom countrysymp_ctry

The country in which a patient's symptom was reported, experienced, or clinically evaluated. Used in international patient records, travel medicine documentation, and global disease surveillance systems to track geographic origin of symptoms and support cross-border epidemiological monitoring and reporting.

symptom created bysymp_crtd_by

The unique identifier of the clinician, staff member, or system user who initially entered the patient-reported symptom into the clinical or health information system. Used for audit trail documentation, accountability tracking, and data governance to ensure integrity of symptom record creation across EHR workflows.

symptom created datesymp_crtd_dt

Record creation timestamp for a patient-reported symptom finding as logged in EHR, clinical data warehouses, and health information systems. Data engineers use this field to establish data lineage, track ingestion latency, and support incremental ETL processes for symptom-related data pipelines.

symptom created timesymp_crtd_tm

The precise timestamp recording when a patient-reported symptom entry was first created in the clinical system. Used in EHR audit logs, clinical documentation timelines, and data lineage tracking to establish when a symptom was initially captured relative to the patient encounter or care event.

symptom creatininesymp_cr

The serum or urine creatinine laboratory value documented in association with a patient-reported symptom, used to assess renal function as part of the diagnostic workup. Elevated or abnormal creatinine levels may indicate kidney disease or failure and directly inform clinical decision-making for symptom management.

symptom datesymp_dt

Calendar date on which a patient-reported symptom finding was documented or first observed, recorded in EHR and claims systems. Data engineers use this field to establish symptom onset timelines, calculate episode durations, and support longitudinal clinical cohort studies across healthcare data platforms.

PreviousPage 698 of 806Next