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

counselor datecnsl_dt

The calendar date associated with a licensed mental health counselor record or event, such as a credentialing action, session, or enrollment transaction. Used in behavioral health systems to establish point-in-time reference for counselor-related activities and audit trails.

counselor datetimecnsl_dttm

The combined date and time value capturing a specific moment associated with a licensed mental health counselor event or transaction. Used in behavioral health systems to precisely timestamp counselor activities, scheduling events, or clinical record updates for audit and workflow tracking.

counselor dea numbercnsl_dea_nbr

The Drug Enforcement Administration registration number assigned to a licensed mental health counselor authorized to prescribe or handle controlled substances. This federally issued identifier is required for prescribing privileges and is tracked in credentialing and provider enrollment systems to verify DEA compliance.

counselor death datecnsl_death_dt

The recorded date of death for a licensed mental health counselor, used to terminate active credentialing records, close provider enrollment, and update billing eligibility in behavioral health and payer systems. Triggers downstream deactivation workflows across claims, scheduling, and member assignment records.

counselor deleted datecnsl_del_dt

The date on which a licensed mental health counselor's record was logically removed or deactivated in the behavioral health system. Used for audit trail maintenance and to establish when the counselor's profile became inactive in provider directories, credentialing systems, or care management platforms.

counselor deleted indicatorcnsl_del_ind

A flag indicating whether a licensed mental health counselor's record has been logically deleted or deactivated in the behavioral health system. Used to filter inactive counselor records from active rosters, provider directories, and eligibility workflows without permanently removing historical data.

counselor descriptioncnsl_desc

A human-readable textual description of a licensed mental health counselor, including specialty, role, or scope of practice details. Used in behavioral health systems, provider directories, and care management platforms to present meaningful counselor information to clinical staff, members, and administrative users.

counselor detailcnsl_dtl

Supplementary information associated with a licensed mental health counselor record, capturing additional attributes such as specialization, practice focus, or service modality. Used in behavioral health platforms and care management systems to provide extended context beyond standard demographic and credentialing fields.

counselor discharge datecnsl_dsch_dt

The date on which a mental health counselor formally discharged a patient from a behavioral health treatment program or inpatient psychiatric episode. Used in clinical documentation, claims processing, and utilization management systems to mark the end of an active treatment relationship and trigger follow-up care workflows.

counselor due datecnsl_due_dt

The deadline date by which a licensed mental health counselor must complete a required action, such as submitting credentialing documentation, renewing licensure, or fulfilling a compliance requirement. Tracked in provider credentialing and enrollment systems to manage counselor obligation timelines and prevent lapses in active status.

counselor durationcnsl_dur

The measured length of time associated with a mental health counselor's involvement in a clinical event, treatment episode, or administrative process. Used in behavioral health systems to quantify session length, program enrollment periods, or credentialing cycle durations for reporting, billing, and quality measurement purposes.

counselor emailcnsl_eml

The professional electronic mail address for a licensed mental health counselor, used for clinical communications, credentialing correspondence, referral coordination, and administrative notifications. Stored in provider directories and behavioral health platforms to support secure messaging and outreach workflows across care teams.

counselor emergency indicatorcnsl_emerg_ind

A flag identifying a licensed mental health counselor as available for or assigned to emergency behavioral health services, such as crisis intervention or psychiatric emergency response. Used in scheduling, care coordination, and dispatch systems to route urgent mental health cases to appropriately designated counselors.

counselor end datecnsl_end_dt

The date marking the conclusion of a licensed mental health counselor's active status, assignment, or participation in a specific program, contract, or care team. Used in behavioral health and provider management systems to define the boundary of a counselor's service period and support accurate claims adjudication.

counselor end timecnsl_end_tm

The specific time at which a licensed mental health counselor's session, shift, assignment, or clinical event concluded. Used in behavioral health scheduling, clinical documentation, and billing systems to record precise session boundaries for time-based service codes and productivity reporting.

counselor entered bycnsl_ent_by

The username or identifier of the system user who created or entered a licensed mental health counselor's record in the behavioral health platform. Used for data governance, audit logging, and accountability tracking to establish a chain of custody for counselor profile creation and updates.

counselor ethnicitycnsl_ethn

The self-reported or recorded ethnicity of a licensed mental health counselor, captured to support workforce diversity reporting, cultural competency initiatives, and demographic analysis. Used in healthcare workforce management systems and behavioral health organizations to meet regulatory reporting requirements and address health equity goals.

counselor expiration datecnsl_exp_dt

The date on which a licensed mental health counselor's credential, license, certification, or contractual agreement expires. Used in credentialing and provider enrollment systems to trigger renewal workflows, prevent lapsed practitioners from rendering services, and maintain compliance with payer and regulatory requirements.

counselor external identifiercnsl_ext_id

A unique identifier assigned to a licensed mental health counselor by an external system, such as a payer, state registry, or credentialing body. Used to cross-reference and reconcile counselor records across behavioral health platforms, claims systems, and provider enrollment databases where internal identifiers differ.

counselor faxcnsl_fax

The facsimile telephone number for a licensed mental health counselor, used to transmit clinical documents, referral authorizations, credentialing materials, and coordination of care communications. Stored in provider directories and behavioral health systems to support document exchange workflows with payers, facilities, and referring providers.

PreviousPage 136 of 806Next