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 emergency indicatorthrp_emerg_ind

A flag designating that a therapy service or clinical encounter involving a licensed therapist was delivered under emergency conditions. Used in claims processing, utilization management, and clinical documentation to apply appropriate reimbursement rules, bypass standard prior authorization requirements, and support emergency care reporting and analytics.

therapist end datethrp_end_dt

Captures the date a licensed therapy professional's record, contract, or network participation concludes within credentialing, EHR, and payer systems. Used by data engineers to enforce temporal filtering in provider lookups, close open records in SCD Type 2 models, and trigger claim rejection rules for out-of-period billing.

therapist end timethrp_end_tm

The recorded time at which a licensed therapist concluded a therapy session or clinical encounter. Used alongside start time to calculate session duration for timed billing codes, validate documentation accuracy, support scheduling system reconciliation, and enable productivity and utilization analysis across therapy service delivery settings.

therapist entered bythrp_ent_by

The identifier of the individual who manually entered or submitted a licensed therapist's clinical, credentialing, or administrative record into the healthcare information system. Retained for audit trail purposes, data quality oversight, and accountability tracking within provider enrollment, scheduling, and clinical documentation workflows.

therapist ethnicitythrp_ethn

The self-reported or administratively recorded ethnic background of a licensed therapist, captured in workforce demographic data. Used to support provider workforce diversity reporting, health equity analyses, compliance with federal and state diversity tracking requirements, and network composition reporting across therapy disciplines and service regions.

therapist expiration datethrp_exp_dt

Indicates the date a licensed therapy professional's credential, contract, or network affiliation lapses within credentialing and provider master systems. Critical for automated re-credentialing alerts, claim adjudication validity checks, and network directory suppression logic enforced by NCQA and CMS compliance workflows.

therapist external identifierthrp_ext_id

The unique identifier assigned to a licensed therapy professional by an external system, such as a referring hospital, payer, or health information exchange. Used to cross-reference therapist records across disparate clinical and administrative platforms, enabling accurate care coordination and claims reconciliation.

therapist faxthrp_fax

The facsimile number associated with a licensed therapy professional, used for transmitting clinical documents such as referrals, treatment authorizations, and session notes. Supports secure communication between therapy providers, payers, and referring clinicians within care coordination and utilization management workflows.

therapist feethrp_fee

The standard service charge billed by a licensed therapy professional for delivering therapeutic services such as physical, occupational, speech, or behavioral health therapy. Used in claims adjudication, fee schedule configuration, and provider contract management to ensure accurate reimbursement and cost analysis.

therapist first namethrp_first_nm

The given name of a licensed therapy professional as recorded in the provider directory or credentialing system. Used in member-facing directories, care team displays, referral workflows, and clinical documentation to identify and distinguish therapists providing physical, occupational, speech, or behavioral health services.

therapist flagthrp_flg

A binary or categorical indicator marking a specific status or condition for a licensed therapy professional within EHR, claims, and credentialing systems. Common uses include active/inactive status, telehealth eligibility, or sanction alerts; data engineers use this field in filter logic for network reporting and claim routing rules.

therapist frequencythrp_freq

The prescribed or authorized number of therapy sessions within a defined time period for a licensed therapy professional's treatment plan. Used in utilization management, prior authorization, and care plan tracking to monitor compliance with approved visit schedules across physical, occupational, or behavioral health therapy.

therapist full namethrp_full_nm

The complete name, including first, middle, and last name components, of a licensed therapy professional. Used in clinical documentation, provider directories, care team assignments, and correspondence to fully and unambiguously identify the therapist delivering physical, occupational, speech, or behavioral health services.

therapist genderthrp_gndr

The gender identity or sex classification recorded for a licensed therapy professional in the provider credentialing or directory system. Used in member-therapist matching workflows, particularly in behavioral health, where patient preference for a therapist's gender may be clinically relevant to treatment engagement and outcomes.

therapist glucosethrp_gluc

The blood glucose measurement recorded for a licensed therapy professional, typically captured in occupational health or employee wellness contexts. May be used in workplace health monitoring programs to track metabolic health indicators for clinical staff, including therapists, within employer-sponsored health management initiatives.

therapist group numberthrp_grp_nbr

The group practice or network affiliation identifier associated with a licensed therapy professional. Used in provider enrollment, claims billing, and network management to link individual therapists to their practice group, enabling accurate routing of reimbursements and group-level performance reporting across payer systems.

therapist hemoglobinthrp_hgb

The blood hemoglobin measurement recorded for a licensed therapy professional, typically captured within occupational health or employee wellness program contexts. Used to track hematological health indicators for clinical staff, including therapists, as part of employer-sponsored biometric screening or workforce health monitoring initiatives.

therapist history present illnessthrp_hpi

The structured narrative documenting a therapy patient's current condition, symptoms, and progression as recorded by the treating therapist during a clinical encounter. Used in physical, occupational, or behavioral health therapy documentation to support clinical decision-making, continuity of care, and medical record completeness.

therapist identifierthrp_id

A unique alphanumeric key assigned to a licensed therapy professional within EHR, claims, credentialing, and provider master systems. Maps to NPI, internal provider IDs, or taxonomy codes; serves as the primary join key across systems during ETL, enabling accurate provider attribution, claim adjudication, and network analytics.

therapist indexthrp_idx

Sequential position number assigned to a licensed therapy professional within EHR scheduling, claims, or care team rosters. Used by data engineers to order, sort, and join therapist records across physical therapy, occupational therapy, and behavioral health datasets.

PreviousPage 730 of 806Next