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 start datethrp_start_dt

The date on which a licensed therapy professional began an episode of care, treatment plan, or provider engagement, recorded in EHR and claims systems. Used by data engineers to calculate therapy episode duration, authorization windows, and care gap metrics in population health platforms.

therapist start timethrp_start_tm

The clock time at which a licensed therapist began a patient treatment session or clinical encounter. Captured in scheduling and billing systems to calculate session duration, support accurate CPT time-based billing, and monitor therapy department productivity and throughput.

therapist statethrp_st

The U.S. state or territory where the licensed therapist holds an active practice license and delivers care. Used in provider credentialing, licensure verification, and claims processing to confirm practice location compliance and validate state-specific billing requirements.

therapist statusthrp_sts

A coded value representing the current operational or clinical state of a licensed therapy professional record, such as active, inactive, suspended, or terminated. Used in provider directory management systems and credentialing databases to support network adequacy reporting and claims routing logic.

therapist street addressthrp_st_addr

The physical street address of the licensed therapist's primary practice location or clinic. Maintained in provider credentialing and directory systems to support accurate claims adjudication, patient referrals, and regulatory reporting for therapy service delivery sites.

therapist strengththrp_str

The drug concentration or dosage strength associated with a medication or therapeutic agent referenced in the licensed therapist's clinical documentation or treatment plan. Relevant in contexts such as hand therapy or rehabilitation where topical or prescribed agents are part of the care regimen.

therapist subtotalthrp_subtot

A partial sum of charges, units, or service counts attributed to a licensed therapist within a defined reporting period or claim grouping. Used in billing reconciliation and productivity reporting to aggregate therapy service costs before applying adjustments or combining with other provider totals.

therapist surgery datethrp_surg_dt

The date of a surgical procedure relevant to a patient's therapy treatment episode, as documented by the licensed therapist. Used to establish post-operative therapy timelines, determine protocol-driven rehabilitation milestones, and ensure care plan alignment with surgical outcomes.

therapist system identifierthrp_sys_id

The unique identifier assigned by a healthcare information system to a licensed therapist record. Used as the primary key to link therapist data across clinical, billing, and credentialing platforms, enabling consistent tracking of therapy services and provider activity enterprise-wide.

therapist targetthrp_tgt

A reference value identifying the intended destination system, patient population, or care goal associated with a licensed therapy professional's intervention. Used by data engineers in care management and EHR platforms to align therapy records with population health outreach and outcome tracking workflows.

therapist taxonomy codethrp_tax_cd

The National Uniform Claim Committee (NUCC) taxonomy code that classifies the licensed therapist's specialty, such as physical therapy (225100000X) or occupational therapy (225X00000X). Required on claims submitted to payers to validate provider type and determine coverage eligibility for therapy services.

therapist temperaturethrp_temp

The body temperature measurement recorded by a licensed therapist during a patient clinical assessment, typically expressed in degrees Fahrenheit or Celsius. Documented in therapy encounter records to monitor patient health status and identify contraindications that may affect the safety of therapeutic interventions.

therapist termination datethrp_term_dt

The effective date on which a licensed therapist's affiliation, contract, or active status with a healthcare organization ends. Used in provider credentialing, network management, and claims processing to enforce billing eligibility periods and prevent post-termination claim submissions.

therapist timethrp_tm

The specific time-of-day value associated with a licensed therapy professional's service or clinical event, recorded in EHR scheduling and encounter systems. Data engineers use this field for session-level utilization analysis, appointment adherence reporting, and temporal joins across care coordination datasets.

therapist timestampthrp_ts

A combined date and time value capturing when a licensed therapy professional's record was created, modified, or transmitted within EHR, claims, or care management systems. Essential for data engineers performing audit trails, event sequencing, and incremental data load processing in therapy-related pipelines.

therapist titlethrp_ttl

The professional title or credential designation of the licensed therapist, such as PT (Physical Therapist), OT (Occupational Therapist), or SLP (Speech-Language Pathologist). Displayed in clinical documentation, provider directories, and patient-facing communications to accurately represent the therapist's scope of practice.

therapist totalthrp_tot

An aggregated numeric value representing the sum of sessions, units, charges, or other measurable attributes associated with a licensed therapy professional's services. Used in claims adjudication, utilization management, and cost reporting systems to support authorization limit tracking and therapy spend analytics.

therapist total countthrp_tot_cnt

The aggregate count of therapy sessions, patient encounters, orders, or service units attributed to a licensed therapist within a reporting period. Used in workforce analytics, productivity dashboards, and utilization reporting to measure therapy department capacity and individual therapist caseload metrics.

therapist typethrp_typ

A classification code identifying the licensed therapy professional specialty, such as physical therapist, occupational therapist, speech-language pathologist, or behavioral health therapist. Found in EHR, claims, and provider directory systems, this field drives specialty-specific routing, credentialing, and utilization reporting logic.

therapist updated datethrp_upd_dt

The most recent date on which a licensed therapist's record was modified in the clinical system. Captures changes to credentials, contact details, specialization, or assignment data, supporting audit trails and ensuring current therapist information is used in care coordination and billing workflows.

PreviousPage 734 of 806Next