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

therapist indicatorthrp_ind

Boolean flag in EHR, claims, or member enrollment records that identifies whether a provider is a licensed therapy professional. Used by data engineers to filter therapy-specific encounters, authorizations, and billing records from general provider datasets in PBM and payer systems.

therapist instructionthrp_instr

Structured or free-text guidance associated with a licensed therapy professional in EHR or care management platforms, capturing treatment protocols, session directives, or documentation requirements. Data engineers use this field to extract clinical workflow rules and therapy plan compliance data.

therapist keythrp_key

The primary surrogate key assigned to a licensed therapy professional within a clinical or administrative data system. Used as an internal lookup reference for joining therapist records across relational database tables in provider management, claims processing, and care coordination reporting environments.

therapist labelthrp_lbl

The human-readable display text or descriptive tag associated with a licensed therapy professional's record in a clinical or administrative system. Used in user interfaces, reports, and care team displays to present therapist information in a clear, standardized format across provider directories and scheduling platforms.

therapist languagethrp_lang

The spoken or written language in which a licensed therapy professional can deliver clinical services and communicate with patients. Used in member-therapist matching, provider directory searches, and care coordination workflows to connect patients with therapists who can provide culturally and linguistically appropriate behavioral or clinical therapy services.

therapist last namethrp_last_nm

The family surname of a licensed therapy professional as recorded in the provider credentialing or enrollment system. Used in provider directory searches, clinical documentation, referral workflows, and care team identification to accurately distinguish therapists delivering physical, occupational, speech, or behavioral health services.

therapist legal namethrp_legal_nm

The officially registered name of a licensed therapy professional as it appears on state licensure, credentialing documents, and regulatory filings. Used in provider enrollment, claims billing, and compliance verification to ensure the therapist's identity aligns with licensing board records and payer contract agreements.

therapist levelthrp_lvl

Hierarchical classification of a licensed therapy professional within provider credentialing or care team structures in EHR and payer systems, such as assistant, associate, or senior therapist. Used by data engineers to apply role-based access rules and reimbursement tier logic in claims processing pipelines.

therapist license numberthrp_lic_nbr

The unique alphanumeric identifier issued by a state licensing board to a credentialed therapy professional, such as a physical therapist, occupational therapist, or licensed clinical social worker. Used in provider credentialing, enrollment verification, claims validation, and regulatory compliance to confirm the therapist's authorization to practice.

therapist marital statusthrp_mar_sts

The recorded marital or domestic relationship status of a licensed therapy professional, typically captured during provider enrollment or human resources onboarding. Used in workforce management, benefits administration, and employee records to support HR reporting and benefits eligibility determinations for therapy staff.

therapist master identifierthrp_mstr_id

The enterprise-level master record identifier assigned to a licensed therapy professional, used to uniquely and persistently identify the therapist across all integrated clinical, administrative, and claims systems. Supports provider data governance, duplicate record resolution, and cross-platform identity matching within a provider master data management framework.

therapist maximumthrp_max

The upper threshold value defined for a licensed therapy professional's authorized services, such as the maximum number of visits, billable units, or reimbursable charges within a benefit period. Used in utilization management, prior authorization, and claims adjudication to enforce plan-level or contract-level service limits for therapy benefits.

therapist medical record numberthrp_mrn

Unique identifier assigned to a licensed therapist within a healthcare facility's medical record system. Used to link therapy session documentation, treatment notes, and clinical outcomes to the specific credentialed therapist across EHR and clinical data systems.

therapist middle namethrp_mid_nm

Middle name or initial of a licensed therapy professional, including physical, occupational, speech, or behavioral health therapists. Used in credentialing records, provider directories, and clinical documentation to distinguish therapists with similar first and last names.

therapist minimumthrp_min

Lower boundary threshold value associated with a licensed therapist's metric, caseload, or performance measure. Used in workforce management and staffing analytics to define acceptable minimums for patient assignments, session counts, or productivity benchmarks within therapy departments.

therapist mobilethrp_mob

Mobile phone number for a licensed therapy professional used for direct contact in clinical care coordination, on-call scheduling, and urgent patient communication. Stored in provider directories and staffing systems to facilitate rapid outreach across therapy service lines.

therapist modified bythrp_mod_by

Username or system identifier of the user who last updated a licensed therapist's record in the healthcare information system. Supports audit trail compliance and data governance by tracking accountability for changes to therapist credentials, assignments, or clinical documentation.

therapist modified datethrp_mod_dt

Timestamp recording the most recent update to a licensed therapy professional's record in EHR, provider directory, or credentialing systems. Critical for data engineers building incremental ETL pipelines to detect changes in therapist credentials, licensure status, or network participation across payer and provider datasets.

therapist modified timethrp_mod_tm

Timestamp recording when a licensed therapist's record was most recently updated in the healthcare information system. Used in audit logging, data governance workflows, and change tracking to maintain record integrity across credentialing, scheduling, and clinical documentation systems.

therapist namethrp_nm

Full display name of a licensed therapy professional stored in EHR provider directories, claims, and member care team records. Data engineers use this field for provider master data management, deduplication across physical therapy, occupational therapy, and behavioral health source systems, and rendering provider name resolution in claims adjudication.

PreviousPage 731 of 806Next