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

Behavioral

Mental health, substance use, psychology and counseling

303 behavioral terms

disorder namedsrd_nm

The human-readable label assigned to a diagnosed abnormal health condition, such as Type 2 Diabetes or Hypertension. Used in clinical documentation, patient-facing materials, and reporting to identify conditions in a standardized, recognizable format across care settings.

disorder notedsrd_nt

Free-text clinical annotation associated with a specific disorder record, capturing provider observations, contextual details, or clarifications not represented in structured fields. Supports nuanced clinical documentation and communication across care teams managing the patient's condition.

disorder numberdsrd_nbr

A system-assigned numeric identifier uniquely referencing a specific disorder record within clinical or administrative databases. Enables consistent cross-system tracking of a diagnosed condition across encounters, referrals, claims submissions, and longitudinal health record management.

disorder onset datedsrd_onset_dt

The calendar date when a patient's disorder or abnormal health condition first began or was first observed. Critical for establishing disease chronology, calculating condition duration, supporting diagnostic coding accuracy, and informing clinical decision-making in longitudinal care management.

disorder paid amountdsrd_pd_amt

The dollar amount reimbursed by a payer for services rendered in treating a specific disorder. Used in claims adjudication and financial reporting to track actual payments against billed charges, supporting cost analysis and financial reconciliation for disorder-related healthcare services.

disorder paid datedsrd_pd_dt

The calendar date on which payment was issued for claims associated with treatment of a specific disorder. Used in revenue cycle management and claims adjudication reporting to track payment timing, identify delays, and reconcile accounts receivable for disorder-related services.

disorder parentdsrd_prnt

The higher-level disorder classification to which a specific condition belongs within a clinical terminology hierarchy, such as a broader disease category in ICD or SNOMED structures. Supports hierarchical grouping, aggregate reporting, and navigation of clinical ontologies in health data systems.

disorder percentagedsrd_pct

A numeric ratio or proportional value associated with a disorder, such as the percentage of disability attributed to a specific condition, prevalence rate within a population, or cost share allocation. Used in clinical analytics, population health reporting, and benefits administration workflows.

disorder perioddsrd_prd

The defined time interval during which a disorder is active, under treatment, or being tracked within a clinical or administrative system. Used to establish coverage windows, treatment durations, reporting timeframes, and eligibility calculations associated with a specific diagnosed condition.

disorder phonedsrd_ph

A telephone contact number associated with a disorder record, typically linked to the treating facility, specialty clinic, or care coordination team managing the condition. Used to facilitate communication and care coordination for patients diagnosed with the specific disorder.

disorder plandsrd_pln

The documented clinical treatment strategy or care plan established for managing a specific disorder, outlining interventions, medications, follow-up schedules, and goals. Used in EHR care planning workflows to guide clinicians and coordinate multidisciplinary management of the patient's condition.

disorder policy numberdsrd_pol_nbr

The insurance policy identifier associated with coverage for treatment of a specific disorder. Used in claims processing and benefits administration to link disorder-related services to the correct insurance policy, ensuring accurate adjudication and coordination of benefits across payers.

disorder preferred namedsrd_pref_nm

The clinically preferred or standardized display name designated for a disorder, used when multiple synonyms or alternate terms exist for the same condition. Ensures consistent terminology across clinical documentation, patient communications, reporting systems, and clinical decision support tools.

disorder pricedsrd_prc

The charged or estimated cost associated with diagnosing or treating a specific disorder, reflecting billed amounts before adjustments or payer negotiations. Used in healthcare cost analysis, revenue cycle management, and financial reporting to evaluate the economic burden of specific conditions.

disorder primary indicatordsrd_prim_ind

A flag designating whether a disorder is the primary diagnosis driving a clinical encounter or claims submission. Critical for ICD coding compliance, DRG assignment, reimbursement accuracy, and reporting workflows where distinguishing principal from secondary diagnoses is required.

disorder prioritydsrd_prty

A ranking value indicating the relative clinical urgency or importance of a disorder within a patient's active problem list or care plan. Used by clinicians and care managers to triage conditions, allocate resources, and sequence interventions based on acuity and treatment need.

disorder quantitydsrd_qty

A numeric count or volume measure associated with a disorder record, such as the number of occurrences, episodes, or units of a specific condition within a defined period. Used in population health analytics, utilization reporting, and clinical research to quantify condition burden.

disorder racedsrd_race

The patient's self-reported racial classification captured in association with a disorder record, used to analyze health disparities, disease prevalence patterns, and treatment outcomes across demographic groups. Supports equity reporting, population health research, and compliance with federal data collection standards.

disorder rangedsrd_rng

The minimum and maximum boundary values defining the measurable span of an abnormal health condition, such as acceptable lab value thresholds or symptom severity limits used in clinical decision support and diagnostic criteria evaluation.

disorder ratedsrd_rt

The frequency or occurrence rate at which a specific abnormal health condition is observed within a defined population or time period, used in epidemiological tracking, clinical quality reporting, and disease surveillance programs.

PreviousPage 6 of 16Next