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 total countcnsl_tot_cnt

The aggregate count of licensed counselors associated with a behavioral health program, care team, or facility. Used in workforce analytics and caseload management to monitor staffing ratios and ensure adequate mental health service capacity across care settings.

counselor typecnsl_typ

Classifies the licensure or specialty designation of a behavioral health counselor, such as Licensed Professional Counselor (LPC), Licensed Clinical Social Worker (LCSW), or Substance Abuse Counselor. Used in care coordination and credentialing workflows to match members with appropriately qualified mental health providers.

counselor updated datecnsl_upd_dt

The date on which a counselor's record was most recently modified in the behavioral health management system, including changes to licensure status, contact information, specialty, or assignment. Used for data integrity audits and tracking credential or roster maintenance activities.

counselor urgencycnsl_urg

Indicates the clinical urgency level assigned to a counselor referral or intervention request, such as routine, urgent, or emergent. Used in behavioral health triage workflows to prioritize scheduling and ensure members in crisis receive timely access to licensed mental health professionals.

counselor versioncnsl_ver

A sequential version number assigned to a counselor's record to track revisions over time within the behavioral health data system. Supports record auditing, change history retrieval, and ensures downstream systems consume the most current credentialing or assignment data.

counselor zipcnsl_zip

The five or nine-digit postal code associated with a licensed counselor's primary practice location. Used in network adequacy analysis, member-to-provider proximity matching, and behavioral health service area reporting to ensure geographic access standards are met.

coverage admission datecov_admn_dt

The date a member was admitted to an inpatient facility within the context of an active insurance coverage period. Used in claims adjudication and utilization management to validate that inpatient services rendered fall within the member's effective coverage dates and benefit eligibility window.

coverage discharge datecov_dsch_dt

The date a member was discharged from an inpatient facility within the context of an active insurance coverage period. Used in claims processing and utilization review to confirm the full inpatient stay occurred within the member's benefit coverage period and to calculate covered length of stay.

coverage emergency indicatorcov_emerg_ind

A flag indicating whether a service was rendered under emergency conditions within a member's insurance coverage context. Used in claims adjudication to apply emergency benefit rules, waive prior authorization requirements, and ensure appropriate cost-sharing is applied regardless of network status.

coverage history present illnesscov_hpi

A narrative description of the member's current condition or chief complaint captured in relation to an active coverage episode. Used in utilization management and prior authorization workflows to document clinical justification for services and support medical necessity determinations under the member's benefit plan.

coverage labelcov_lbl

A human-readable display name or identifier assigned to a specific insurance coverage plan or benefit tier, such as 'Gold PPO' or 'Medicare Advantage HMO'. Used in member portals, explanation of benefits documents, and enrollment systems to clearly communicate plan identity to members and administrators.

coverage procedure datecov_proc_dt

The date on which a clinical procedure was performed in relation to an active member coverage period. Used in claims adjudication to confirm that services were rendered within benefit eligibility dates and to apply the correct plan year deductible, copay, and out-of-pocket accumulations.

coverage rangecov_rng

Defines the minimum and maximum boundaries of covered benefits under a member's insurance plan, such as covered days of inpatient care or visit limits for specialty services. Used in claims adjudication and benefit configuration to enforce plan-level utilization thresholds and member cost-sharing calculations.

coverage resultcov_rslt

The outcome of a coverage determination or eligibility verification inquiry, indicating whether a requested service or benefit is covered, partially covered, or excluded under the member's active insurance plan. Used in prior authorization, claims adjudication, and member communication workflows.

coverage surgery datecov_surg_dt

The date on which a surgical procedure was performed within an active member coverage period. Used in claims adjudication and utilization management to validate surgical benefit eligibility, apply correct cost-sharing rules, and ensure prior authorization requirements were satisfied before the operative date.

cpt active indicatorcpt_actv_ind

A binary flag indicating whether a Current Procedural Terminology (CPT) code is currently active and valid for use in claims submission and clinical documentation. Used in claims editing and fee schedule management to prevent adjudication of services billed with retired or invalid CPT codes.

cpt active statuscpt_actv_sts

Describes the current lifecycle state of a CPT code within the AMA procedural code set, such as active, deleted, or temporarily suspended. Used in claims adjudication, provider billing systems, and fee schedule maintenance to ensure only valid codes are accepted and reimbursed during the applicable code year.

cpt admission datecpt_admn_dt

The facility admission date associated with a CPT-coded service, used to link procedural billing to an inpatient or observation encounter. Used in claims processing and DRG grouping to establish the clinical episode context for procedure codes and validate sequencing within the inpatient stay timeline.

cpt assessmentcpt_asmt

A clinical evaluation narrative or structured finding associated with a CPT-coded encounter, capturing the clinician's interpretation of diagnostic workup results. Used in clinical documentation and medical necessity review to support the appropriateness of billed CPT procedures and justify utilization management decisions.

cpt discharge datecpt_dsch_dt

The date a patient was discharged from a facility in relation to a CPT-coded inpatient or observation service. Used in claims adjudication and length-of-stay analysis to calculate the full episode duration, validate per diem payments, and ensure procedural codes align with the documented inpatient encounter period.

PreviousPage 141 of 806Next