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 zipsymp_zip

Postal code associated with the location where a patient-reported symptom was documented or where the patient resides at the time of reporting. Used in epidemiological surveillance, population health geographic analysis, and public health outbreak tracking across regional healthcare data systems.

syndrome active indicatorsynd_actv_ind

Boolean flag designating whether a documented syndrome is currently active within a patient's clinical record. Used by care management and clinical documentation systems to filter active conditions for treatment planning, quality measure reporting, and chronic disease management program enrollment workflows.

syndrome active statussynd_actv_sts

Categorical value indicating the current clinical state of a documented syndrome, such as active, resolved, or inactive. Supports care coordination workflows, chronic condition registries, and clinical decision support by ensuring treatment teams and data systems reflect the most current patient health status.

syndrome admission datesynd_admn_dt

Date on which a patient was admitted to an inpatient facility with a documented syndrome as a contributing or primary diagnosis. Used in hospital claims processing, length-of-stay calculations, case management workflows, and clinical outcome analytics within inpatient healthcare data systems.

syndrome agesynd_age

Patient's age in years at the time a syndrome was first documented or diagnosed within the clinical record. Used in epidemiological analysis, age-stratified population health reporting, clinical research cohort identification, and syndrome prevalence tracking across healthcare data systems.

syndrome allowed amountsynd_alwd_amt

Maximum reimbursable dollar amount designated by a health plan for services rendered in connection with a documented syndrome diagnosis. Applied during claims adjudication to calculate member cost-sharing obligations, provider payment amounts, and contractual adjustment values within payer financial systems.

syndrome amountsynd_amt

Monetary value associated with clinical services or claims tied to a documented syndrome diagnosis. Captured during claims processing or financial reconciliation to support cost-of-care analysis, syndrome-level spending reporting, and population health financial management within payer and provider data systems.

syndrome approved bysynd_appr_by

Identifier of the clinician, care manager, or system user who authorized a syndrome-related clinical record, treatment plan, or documentation entry. Maintains accountability and audit trail integrity within EHR and clinical workflow systems, supporting compliance, peer review, and quality assurance processes.

syndrome arrival timesynd_arrv_tm

Timestamp recording the exact time a patient presenting with a syndrome arrived at a clinical facility, typically an emergency department or urgent care setting. Used in triage analytics, door-to-treatment time calculations, throughput reporting, and emergency care quality benchmarking workflows.

syndrome arrived datesynd_arrv_dt

Calendar date on which a patient presenting with a syndrome arrived at a healthcare facility for evaluation or treatment. Used in conjunction with arrival time to support triage documentation, emergency department throughput analysis, and episode-of-care sequencing within clinical and operational data systems.

syndrome assessmentsynd_asmt

Structured or free-text clinical evaluation narrative documenting the clinician's interpretation of a patient's syndrome presentation, including findings, differential diagnoses, and clinical impressions. Forms a core component of SOAP-format clinical notes and supports diagnostic coding, care planning, and longitudinal outcome tracking.

syndrome balancesynd_bal

The outstanding financial balance associated with a syndrome-related encounter or treatment episode. Represents unpaid or remaining charges after payments and adjustments are applied, used in revenue cycle management to track syndrome-specific accounts receivable across billing systems.

syndrome billed amountsynd_bill_amt

The total gross charges submitted to a payer for services rendered in treating a diagnosed syndrome. Represents the initial invoice amount before adjustments, contractual allowances, or payments, used in claims processing and revenue cycle reporting to track syndrome-related billing activity.

syndrome birth datesynd_birth_dt

The recorded date of birth of the patient associated with a syndrome diagnosis or treatment record. Used in clinical and administrative systems to verify patient identity, calculate age-based eligibility criteria, and support syndrome-specific epidemiological analysis and demographic reporting.

syndrome blood pressuresynd_bp

The systolic and diastolic arterial pressure measurement recorded in the context of a syndrome-related clinical encounter. Used as a vital sign indicator to monitor hemodynamic status, support differential diagnosis, and track cardiovascular involvement within syndrome assessment workflows.

syndrome cancelled datesynd_cncl_dt

The date on which a syndrome-related order, referral, appointment, or treatment episode was formally cancelled. Used in clinical workflow management to track care discontinuation events, support audit trails, and measure cancellation patterns affecting syndrome management continuity of care.

syndrome categorysynd_cat

A classification grouping that organizes syndromes into clinically or administratively meaningful categories, such as metabolic, neurological, or cardiovascular. Used in population health management, clinical decision support, and reporting systems to stratify and analyze syndrome distributions across patient populations.

syndrome chief complaintsynd_cc

The primary symptom or reason for a clinical encounter as reported by the patient or caregiver in the context of a syndrome presentation. Captured at intake to guide triage, clinical assessment, and documentation workflows, and used in syndrome surveillance and outcomes research.

syndrome childsynd_chld

A subordinate or dependent syndrome record linked hierarchically to a parent syndrome entity. Used in clinical ontology and data modeling to represent sub-syndromes, comorbid clusters, or nested diagnostic groupings within syndrome classification hierarchies in EHR and clinical data warehouse systems.

syndrome citysynd_city

The city or municipality associated with the patient or facility record linked to a syndrome diagnosis or treatment encounter. Used in geographic analysis, public health surveillance, and syndrome outbreak tracking to identify regional distribution patterns and support location-based reporting.

PreviousPage 705 of 806Next