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 countthrp_cnt

Represents the aggregate number of licensed therapy professionals within a defined scope, such as a practice, network, or region, in provider analytics and network adequacy systems. Used by data engineers to validate panel size thresholds, staffing ratios, and access-to-care reporting for regulatory submissions.

therapist countrythrp_ctry

The nation in which a licensed therapist's practice address or credentialing jurisdiction is located. Used in provider enrollment, credentialing verification, and claims processing to establish regulatory compliance, support cross-border service reporting, and validate licensure jurisdiction for therapy service reimbursement.

therapist created bythrp_crtd_by

The unique identifier of the system user or administrator who originally created the licensed therapist's record in the healthcare information system. Captured for audit trail purposes, supporting data governance, credentialing workflow accountability, and compliance tracking within provider management and enrollment platforms.

therapist created datethrp_crtd_dt

Captures the timestamp when a licensed therapy professional's record was first instantiated in EHR, credentialing, or provider master systems. Essential for data lineage tracking, audit trail compliance, and identifying stale or duplicate provider records during ETL reconciliation and master data management processes.

therapist created timethrp_crtd_tm

The timestamp recording the exact date and time a licensed therapist's record was first entered into the healthcare information system. Used for audit trail integrity, data lineage tracking, and credentialing workflow monitoring to establish when the therapist profile became active within provider enrollment systems.

therapist creatininethrp_cr

The serum or urine creatinine laboratory value documented in a licensed therapist's patient clinical record, serving as a biomarker of renal function. Used in therapy care planning contexts, particularly for patients undergoing rehabilitation where kidney function may influence medication management, hydration protocols, or treatment intensity decisions.

therapist datethrp_dt

A generic calendar date attribute associated with a licensed therapy professional's record in EHR, credentialing, or claims systems. Context-dependent and must be mapped carefully during ETL, as it may reference licensure, onboarding, or service dates depending on the source system schema.

therapist datetimethrp_dttm

A combined date and time timestamp tied to a licensed therapy professional's record in EHR, scheduling, or claims systems. Precision is critical for event sequencing, audit logging, and encounter-level analytics; data engineers must normalize timezone offsets across source systems during integration pipelines.

therapist dea numberthrp_dea_nbr

The Drug Enforcement Administration registration number assigned to a licensed therapist who holds prescriptive authority for controlled substances. Used in credentialing verification, prescription monitoring programs, and provider enrollment records to validate lawful authority to prescribe or handle scheduled medications within applicable therapy practice scopes.

therapist death datethrp_death_dt

Records the date of death for a licensed therapy professional within provider credentialing, EHR, and network management systems. Triggers provider deactivation workflows, claim rejection logic for post-death billing, and directory updates to maintain compliance with CMS provider data accuracy mandates.

therapist deductible amountthrp_ded_amt

The dollar amount applied toward a member's annual deductible for therapy services rendered by a licensed therapist. Tracked during claims adjudication to determine when cost-sharing obligations shift from full member responsibility to coinsurance or copay structures for physical, occupational, speech, or behavioral therapy services.

therapist deleted datethrp_del_dt

The calendar date on which a licensed therapist's record was marked as deleted or inactivated within the healthcare information system. Used in provider data governance, credentialing lifecycle management, and audit trail reporting to document when a therapist profile was removed from active rosters or network directories.

therapist deleted indicatorthrp_del_ind

A flag identifying that a licensed therapist's record has been logically deleted or inactivated in the healthcare information system without physical removal from the database. Supports data integrity, historical reporting, and audit compliance by preserving the record while excluding it from active provider directories and credentialing workflows.

therapist descriptionthrp_desc

A textual field providing descriptive context about a licensed therapy professional's role, specialty, or credentials within EHR, provider directories, and credentialing systems. Used by data engineers during catalog documentation and for populating member-facing provider search attributes in health plan portals.

therapist detailthrp_dtl

Contains granular provider-level attributes for a licensed therapy professional, such as subspecialty, languages spoken, or treatment modalities, within EHR and provider master systems. Supports network adequacy reporting, member-provider matching algorithms, and care coordination workflows in managed care platforms.

therapist discharge datethrp_dsch_dt

Records the date a licensed therapy professional was formally released from a facility, program, or care episode within EHR and claims systems. Used to calculate length of stay, validate claim billing periods, and trigger post-discharge care coordination events in utilization management platforms.

therapist due datethrp_due_dt

The date by which a payment, authorization renewal, credentialing revalidation, or clinical documentation submission associated with a licensed therapist is required. Used in revenue cycle management, utilization management, and provider credentialing workflows to trigger follow-up actions and ensure timely compliance with billing or regulatory deadlines.

therapist durationthrp_dur

The measured length of time for a therapy session, treatment episode, or clinical intervention delivered by a licensed therapist. Captured in clinical documentation and claims data to support billing accuracy for timed therapy procedure codes, utilization review, productivity reporting, and outcomes measurement across therapy service lines.

therapist effective datethrp_eff_dt

Marks the start date of a licensed therapy professional's active status within credentialing, network contracting, and provider master systems. Governs claim eligibility windows, network participation validity, and authorization approvals; data engineers use this field in slowly changing dimension logic for provider history tracking.

therapist emailthrp_eml

Stores the electronic mail address for a licensed therapy professional within provider directories, EHR, and credentialing platforms. Used for secure clinical communications, referral notifications, and portal access provisioning; requires validation and deduplication logic during ETL to ensure directory accuracy and regulatory compliance.

PreviousPage 729 of 806Next