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 master identifiercnsl_mstr_id

The enterprise-wide unique identifier assigned to a licensed mental health counselor, enabling consistent tracking across behavioral health systems, claims platforms, credentialing databases, and care coordination records regardless of practice location or affiliated facility.

counselor maximumcnsl_max

The upper threshold value applied to a licensed mental health counselor's record, such as maximum caseload capacity, maximum billable session hours, or maximum reimbursement limits defined by payer contracts or behavioral health program guidelines.

counselor middle namecnsl_mid_nm

The middle name or initial of a licensed mental health counselor, used in credentialing verification, insurance enrollment, and licensure matching processes where full legal name is required to distinguish practitioners with similar first and last names.

counselor minimumcnsl_min

The lower threshold value applied to a licensed mental health counselor's record, such as minimum required session frequency, minimum caseload requirements, or minimum reimbursement floor values defined by behavioral health program or payer contract terms.

counselor mobilecnsl_mob

The mobile phone number for a licensed mental health counselor, used in care coordination, urgent patient outreach, telehealth session scheduling, and secure messaging systems within behavioral health platforms and clinical communication workflows.

counselor modified bycnsl_mod_by

The user identifier of the individual who last updated a mental health counselor's record in the system, supporting audit trail requirements, data governance accountability, and compliance tracking across behavioral health and credentialing platforms.

counselor modified datecnsl_mod_dt

The calendar date on which a mental health counselor's record was most recently updated, used to support audit trails, data synchronization across behavioral health systems, credentialing renewal tracking, and regulatory compliance reporting.

counselor modified timecnsl_mod_tm

The timestamp recording when a mental health counselor's record was last updated, providing granular audit trail data for system change logs, data governance reviews, and compliance monitoring within behavioral health and credentialing platforms.

counselor namecnsl_nm

The full display name of a licensed mental health counselor as rendered in clinical documentation, member-facing materials, claims submissions, and care team rosters within behavioral health systems and managed care platforms.

counselor notecnsl_nt

Free-text annotation associated with a mental health counselor's record, capturing administrative details, credentialing exceptions, supervision arrangements, or workflow flags relevant to the counselor's role within behavioral health programs or payer networks.

counselor numbercnsl_nbr

A system-assigned or externally issued reference number identifying a licensed mental health counselor, used in claims processing, network directory lookups, credentialing submissions, and behavioral health program reporting across administrative systems.

counselor onset datecnsl_onset_dt

The date marking the start of a counselor's active status, assignment, or program participation, used in behavioral health reporting to determine eligibility windows, supervision period tracking, and longitudinal analysis of counselor engagement within clinical programs.

counselor oxygen saturationcnsl_o2sat

The recorded blood oxygen saturation level associated with a mental health counselor, typically captured in occupational health or employee wellness contexts where clinical vitals are tracked for staff providing direct patient care in behavioral health settings.

counselor paid amountcnsl_pd_amt

The dollar amount remitted to a licensed mental health counselor for rendered behavioral health services, reflecting reimbursement calculated from adjudicated claims, contracted fee schedules, or capitation arrangements within payer and managed behavioral health systems.

counselor paid datecnsl_pd_dt

The date on which payment was issued to a licensed mental health counselor for behavioral health services rendered, used in claims reconciliation, provider payment reporting, and accounts payable tracking within payer and managed care financial systems.

counselor parentcnsl_prnt

The identifier of the supervising clinician, group practice, or organizational entity to which a mental health counselor is hierarchically associated, supporting supervision tracking, billing under a supervising license, and network affiliation management in behavioral health systems.

counselor percentagecnsl_pct

A percentage value associated with a mental health counselor's record, representing metrics such as capitation allocation share, performance-based incentive rate, caseload utilization rate, or cost-sharing percentage within behavioral health contracts or value-based care arrangements.

counselor periodcnsl_prd

The defined time interval applicable to a mental health counselor's record, such as a credentialing cycle, contract term, supervision period, or reporting window used in behavioral health program administration and payer network management workflows.

counselor phonecnsl_ph

The primary office or contact telephone number for a licensed mental health counselor, used in provider directory maintenance, appointment scheduling, care coordination outreach, and network verification processes within behavioral health and managed care systems.

counselor preferred namecnsl_pref_nm

The name a licensed mental health counselor chooses to use in clinical and administrative contexts, which may differ from their legal name, used in patient-facing communications, care team documentation, and scheduling systems to reflect the counselor's stated preference.

PreviousPage 138 of 806Next