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 identifierdsrd_id

System-generated or assigned unique value that distinctly identifies a specific disorder record within a clinical database or health information system. Serves as the primary key for linking disorder-related data across encounters, diagnoses, treatment plans, and outcome tracking tables.

disorder indexdsrd_idx

Numeric position value that indicates the sequential rank or ordering of a disorder within a patient's problem list, diagnostic record, or clinical encounter. Used to prioritize or sequence multiple co-occurring conditions in clinical documentation and reporting workflows.

disorder indicatordsrd_ind

Boolean or coded flag that denotes the presence, absence, or active status of a specific disorder for a patient within a clinical or claims record. Used in population health screening, eligibility determination, and clinical quality measure calculations to identify affected members.

disorder instructiondsrd_instr

Clinical or administrative guidance text associated with a diagnosed disorder, detailing care protocols, patient education steps, or documentation requirements. Supports care management workflows by delivering condition-specific directives to clinical staff or patients within health information systems.

disorder keydsrd_key

Reference value used as a lookup or join key to relate a disorder record to associated clinical, operational, or administrative data across healthcare database tables. Enables cross-system data linkage for reporting, analytics, and care management within clinical data warehouses.

disorder languagedsrd_lang

Coded or text value identifying the preferred language in which disorder-related clinical documentation, patient instructions, or care communications should be delivered. Supports health equity initiatives and regulatory compliance by ensuring language-appropriate clinical information management.

disorder last namedsrd_last_nm

Family surname of the patient or clinician associated with a disorder record in a clinical or administrative system. Used to support patient matching, record retrieval, and identity verification when linking disorder documentation to the correct individual within healthcare data systems.

disorder legal namedsrd_legal_nm

Officially registered full name associated with a disorder record, typically the patient's legal identity as recognized by government or insurance documentation. Ensures accurate identity matching for clinical documentation, claims adjudication, and compliance reporting across health systems.

disorder leveldsrd_lvl

Value representing the hierarchical tier or severity classification of a disorder within a clinical taxonomy or coding structure, such as ICD categorization levels. Used in clinical analytics and disease classification to differentiate primary, secondary, or complication-level diagnoses.

disorder license numberdsrd_lic_nbr

Professional licensure identifier associated with the clinician who diagnosed or documented a disorder in the patient record. Used in credentialing validation, provider attribution, audit trails, and regulatory compliance reporting within clinical and claims data environments.

disorder marital statusdsrd_mar_sts

Coded value representing the marital or domestic partnership status of the patient associated with a disorder record. Captured as a social determinant of health data point in clinical documentation to support psychosocial assessments, care planning, and population health stratification.

disorder master identifierdsrd_mstr_id

Enterprise-level master identifier that uniquely identifies a disorder record across multiple source systems within a health information network or integrated delivery system. Enables consistent data reconciliation, deduplication, and longitudinal tracking of conditions across disparate clinical platforms.

disorder maximumdsrd_max

Upper boundary value associated with a measurable clinical parameter related to a disorder, such as the maximum allowable threshold for a lab result, dosage range, or severity score. Used in clinical decision support rules and quality metric calculations to flag out-of-range conditions.

disorder medical record numberdsrd_mrn

Facility-assigned medical record number linked to the patient encounter in which a disorder was diagnosed or documented. Serves as a key identifier for retrieving condition-specific records within a health system and supports patient identity resolution across clinical and administrative workflows.

disorder middle namedsrd_mid_nm

Middle name or initial of the patient associated with a disorder record, used to improve identity matching accuracy and reduce duplicate record creation in clinical and administrative health systems. Supports precise patient disambiguation when first and last names alone are insufficient.

disorder minimumdsrd_min

Lower boundary value defining the minimum threshold of a measurable clinical parameter associated with a disorder, such as a minimum lab value, symptom duration, or severity score. Applied in clinical decision support logic and quality reporting to establish baseline clinical criteria.

disorder mobiledsrd_mob

Mobile telephone number associated with the patient linked to a disorder record, used for appointment reminders, care coordination outreach, and condition management communications. Supports patient engagement programs and telehealth workflows tied to ongoing disorder monitoring and follow-up.

disorder modified bydsrd_mod_by

Username or system identifier of the user who last updated a disorder record within a clinical or administrative data system. Captured as part of the audit trail to support data governance, record integrity verification, and compliance tracking for clinical documentation changes.

disorder modified datedsrd_mod_dt

The calendar date when a disorder record was last updated in the clinical system. Captures revisions to diagnosis details, severity classifications, or clinical status changes, enabling audit trails and longitudinal tracking of condition management across care episodes.

disorder modified timedsrd_mod_tm

The timestamp recording when a disorder record was last updated in the clinical system. Used alongside the modified date to provide precise audit trails for changes to diagnosis details, clinical status updates, or severity reclassifications within EHR and clinical data systems.

PreviousPage 5 of 16Next