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 pricecnsl_prc

The contracted or billed price associated with a licensed mental health counselor's services, used in behavioral health claims and reimbursement processing to determine payment amounts for counseling sessions, assessments, or therapeutic interventions.

counselor primary indicatorcnsl_prim_ind

A flag identifying whether a licensed mental health counselor is designated as the primary behavioral health provider for a member's care, used in care coordination and managed behavioral health organization records to distinguish lead counselors from secondary or consulting practitioners.

counselor prioritycnsl_prty

A ranking value assigned to a licensed mental health counselor within a member's care team or referral workflow, used in behavioral health management systems to sequence counselor assignments, triage clinical tasks, or prioritize caseload allocation across treatment programs.

counselor procedure datecnsl_proc_dt

The date on which a licensed mental health counselor performed a specific clinical procedure or therapeutic service, used in behavioral health claims and clinical documentation to establish service timelines for billing, authorization verification, and treatment continuity tracking.

counselor pulsecnsl_pulse

The recorded heart rate measurement captured during a clinical encounter by or involving a licensed mental health counselor, used in integrated behavioral and physical health records where vital signs are documented alongside mental health assessments during wellness or intake evaluations.

counselor quantitycnsl_qty

The numeric count of counseling sessions, service units, or interventions delivered by a licensed mental health counselor within a defined period, used in behavioral health claims and utilization management to track authorized versus rendered service volumes for a member.

counselor racecnsl_race

The self-reported or recorded racial classification of a licensed mental health counselor, used in behavioral health workforce diversity reporting, cultural competency program management, and demographic analytics to support equitable care delivery and provider-member matching initiatives.

counselor rangecnsl_rng

The defined minimum and maximum boundaries applicable to a counselor-related measurement or service parameter, used in behavioral health data systems to establish acceptable value thresholds for clinical assessments, caseload limits, or reimbursement rate bands.

counselor ratecnsl_rt

The established reimbursement or billing rate per unit of service for a licensed mental health counselor, used in behavioral health contracting and claims adjudication to calculate payments based on session type, credential level, or payer-specific fee schedule agreements.

counselor ratingcnsl_rtg

A scored assessment value reflecting the performance, quality, or member satisfaction level associated with a licensed mental health counselor, used in behavioral health quality programs, network credentialing reviews, and value-based care arrangements to evaluate care effectiveness.

counselor ratiocnsl_ratio

The proportional relationship between licensed mental health counselors and a defined population metric, such as members per counselor or sessions per caseload, used in behavioral health workforce planning and network adequacy reporting to assess service accessibility and staffing sufficiency.

counselor reasoncnsl_rsn

The documented explanation or clinical justification associated with a counselor-related action, referral, or service decision, used in behavioral health authorization records and case management workflows to capture rationale for treatment changes, denials, or care transitions.

counselor received datecnsl_rcvd_dt

The date on which a referral, clinical document, or authorization request pertaining to a licensed mental health counselor was received by the processing entity, used in behavioral health workflows to track intake timelines, response obligations, and care coordination milestones.

counselor referencecnsl_ref

An external identifier or pointer linking a licensed mental health counselor record to a related entity such as a referral source, treatment episode, or authorization, used in behavioral health data systems to maintain relational integrity across clinical and administrative records.

counselor resolution datecnsl_resol_dt

The date on which a clinical issue, treatment episode, or open case managed by a licensed mental health counselor was formally closed or resolved, used in behavioral health case management systems to track episode duration, outcomes, and discharge milestone completion.

counselor respirationcnsl_resp

The recorded breathing rate measurement captured during a clinical encounter involving a licensed mental health counselor, used in integrated behavioral and physical health records where respiratory vital signs are documented alongside mental health screenings during comprehensive intake assessments.

counselor resultcnsl_rslt

The documented clinical outcome or measurement produced from a counselor-administered assessment, screening, or therapeutic intervention, used in behavioral health records to track progress toward treatment goals, standardized scoring outcomes, and member response to counseling services.

counselor revisioncnsl_rev

The version or iteration number reflecting updates made to a counselor's treatment plan, clinical documentation, or care record, used in behavioral health systems to maintain audit trails, track document amendments, and ensure the most current clinical guidance is applied to member care.

counselor riskcnsl_rsk

The assessed risk level associated with a member under the care of a licensed mental health counselor, capturing factors such as self-harm potential, substance use severity, or crisis likelihood, used in behavioral health risk stratification and care management prioritization workflows.

counselor routecnsl_rte

The designated care pathway or referral channel through which a member accesses services from a licensed mental health counselor, used in behavioral health network management and care coordination records to track how members are directed to counseling services within managed care programs.

PreviousPage 139 of 806Next