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 rangethrp_rng

Defined minimum and maximum value boundaries associated with a licensed therapy professional's metrics, such as session duration limits, reimbursement rate bands, or authorized visit counts in EHR and payer systems. Data engineers use this field to enforce business rules, detect outliers, and validate claims data within therapy benefit structures.

therapist ratethrp_rt

Unit reimbursement or billing rate associated with a licensed therapy professional in claims, fee schedule, or provider contract systems. Data engineers use this field to apply payer-specific fee schedule logic, calculate expected reimbursement for physical, occupational, and behavioral health therapy services, and validate adjudicated payment amounts in claims pipelines.

therapist ratingthrp_rtg

Numerical or categorical score assigned to a licensed therapist based on performance reviews, patient satisfaction surveys, or clinical outcome metrics. Used in quality management and credentialing systems to evaluate therapist effectiveness and inform staffing, supervision, and professional development decisions.

therapist ratiothrp_ratio

Proportional relationship between the number of licensed therapists and patients or caseload volume within a clinical setting. Used in workforce planning and staffing models to ensure adequate therapy coverage, maintain care quality standards, and comply with regulatory staffing requirements across therapy departments.

therapist reasonthrp_rsn

Coded or free-text explanation associated with a licensed therapy professional record change, referral decision, or authorization action in EHR, utilization management, or payer systems. Data engineers use this field to capture denial reasons, status change justifications, and clinical decision rationale in therapy claims and care management audit pipelines.

therapist received datethrp_rcvd_dt

The date a referral, order, or clinical document was received by the licensed therapist or therapy department. Used in care coordination workflows to measure referral-to-intake lag times and ensure timely therapy service initiation for patients.

therapist referencethrp_ref

External identifier or cross-system pointer linking a licensed therapy professional to related records in EHR, claims, credentialing, or payer network systems, such as NPI, state license number, or internal provider ID. Data engineers use this field for master data management, provider deduplication, and cross-source reconciliation in healthcare data integration pipelines.

therapist resolution datethrp_resol_dt

The date on which a therapy-related condition, problem, or treatment episode was resolved or closed by the licensed therapist. Used in clinical documentation to track the duration of therapeutic interventions and patient progress toward discharge goals.

therapist respirationthrp_resp

The respiratory rate measurement, in breaths per minute, recorded by a licensed therapist during a patient assessment. Captured in respiratory or physical therapy encounters to monitor patient breathing status and evaluate response to therapeutic interventions.

therapist resultthrp_rslt

Outcome measurement or assessment finding associated with a licensed therapy professional's clinical intervention in EHR or care management systems, such as functional improvement scores, goal attainment levels, or therapy session outcomes. Data engineers use this field in quality measure reporting, HEDIS analytics, and population health outcome tracking pipelines.

therapist review systemsthrp_ros

The review of systems (ROS) documentation completed by a licensed therapist, covering relevant body systems evaluated during a patient encounter. Supports clinical assessment by identifying symptoms across systems that may affect the therapy treatment plan and functional outcomes.

therapist revisionthrp_rev

The version or iteration number indicating updates made to a therapist's clinical documentation, treatment plan, or care record. Tracks modification history in therapy management systems to maintain audit trails and ensure the most current clinical information is applied to patient care.

therapist riskthrp_rsk

The clinical or administrative risk level assigned to a patient by a licensed therapist based on functional, safety, or fall-risk assessments. Informs therapy care planning, frequency of visits, and level of supervision required to safely progress the patient through their treatment program.

therapist routethrp_rte

The delivery method or care pathway through which therapy services are administered to the patient, such as inpatient, outpatient, home health, or telehealth. Used in therapy scheduling and billing systems to classify service setting and determine appropriate reimbursement codes.

therapist scorethrp_scr

Calculated numeric rating assigned to a licensed therapy professional in EHR quality, performance management, or payer value-based care systems, reflecting metrics such as patient outcomes, documentation compliance, or efficiency benchmarks. Data engineers use this field to build provider scorecards, quality incentive calculations, and network tiering models in payer analytics platforms.

therapist sequencethrp_seq

Numeric ordering value assigned to a licensed therapy professional within EHR, claims, or care coordination records. Used by data engineers to deduplicate therapist assignments, rank provider records, and maintain referential integrity across therapy episode datasets.

therapist service datethrp_svc_dt

The calendar date on which a licensed therapy professional delivered clinical services, captured in EHR and claims systems. Critical for data engineers validating claim adjudication timelines, episode-of-care analytics, and therapy utilization reporting in PBM and payer platforms.

therapist severitythrp_sev

A coded indicator reflecting the clinical severity of a patient condition as assessed or treated by a licensed therapy professional. Found in EHR and case management systems, this field supports risk stratification models and care intensity classification in healthcare analytics pipelines.

therapist sexthrp_sex

The biological sex of the licensed therapist as recorded in provider credentialing and workforce management systems. Used in provider directory maintenance, patient-provider matching workflows, and demographic reporting for workforce diversity and compliance purposes.

therapist sourcethrp_src

Identifies the originating system or referral pathway through which a licensed therapy professional record was generated, such as an EHR, claims feed, or care management platform. Data engineers use this field for data lineage tracking and source-system reconciliation in therapy provider datasets.

PreviousPage 733 of 806Next