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 notethrp_nt

Free-text or structured annotation associated with a licensed therapy professional in EHR clinical documentation or care management systems, capturing session observations, treatment updates, or administrative remarks. Data engineers process this field for NLP pipelines, audit trails, and longitudinal therapy outcome analytics.

therapist numberthrp_nbr

Unique alphanumeric reference identifier assigned to a licensed therapy professional in provider credentialing, claims, or EHR systems. Used by data engineers as a key for joining therapist records across physical therapy, occupational therapy, and behavioral health datasets, and for tracking NPI cross-references in payer systems.

therapist onset datethrp_onset_dt

Date on which a patient's condition or symptoms began, as documented by a licensed therapist during clinical assessment. Used in therapy care records to establish clinical timelines, support diagnosis coding, and measure time-to-treatment intervals for rehabilitation and behavioral health services.

therapist oxygen saturationthrp_o2sat

Blood oxygen saturation level measured or documented by a licensed therapist, particularly in respiratory or physical therapy settings. Recorded as a percentage of oxygenated hemoglobin and used to monitor patient tolerance during therapeutic exercises and rehabilitation sessions.

therapist paid amountthrp_pd_amt

Total dollar amount reimbursed or paid to a licensed therapy professional for services rendered, as recorded in claims or payroll systems. Used in revenue cycle management to reconcile therapy service billings against insurance reimbursements and contractual payment rates.

therapist paid datethrp_pd_dt

Date on which payment was issued to a licensed therapy professional for services rendered. Recorded in claims and revenue cycle systems to track reimbursement timing, reconcile accounts payable, and monitor payment lag for therapy service billing cycles.

therapist parentthrp_prnt

Reference to the supervising provider, practice group, or organizational entity associated with a licensed therapy professional in EHR or provider hierarchy systems. Data engineers use this field to construct provider affiliation trees, resolve billing group relationships, and enforce supervision rules in claims adjudication pipelines.

therapist percentagethrp_pct

Ratio or percentage value associated with a licensed therapy professional in claims, reimbursement, or workload distribution systems, such as cost-share allocation, productivity metrics, or therapy authorization utilization rates. Data engineers use this field in payer analytics, provider performance dashboards, and PBM benefit calculations.

therapist periodthrp_prd

Defined time span associated with a licensed therapy professional's activity, contract, or authorization window in EHR, payer, or care management systems. Data engineers use this field to scope therapy session counts, validate authorization date ranges, and calculate episode-of-care durations in claims and utilization management pipelines.

therapist phonethrp_ph

Contact telephone number for a licensed therapy professional stored in EHR provider directories, payer network databases, or member care team records. Data engineers use this field in provider data quality validation, member communication workflows, and care coordination platform integrations across physical and behavioral health systems.

therapist planthrp_pln

Documented treatment plan or clinical strategy developed by a licensed therapist outlining therapeutic goals, intervention methods, frequency of sessions, and expected outcomes. Used in EHR systems to guide ongoing care delivery and support continuity across therapy service encounters.

therapist policy numberthrp_pol_nbr

Insurance policy identifier associated with a licensed therapist's professional liability or malpractice coverage. Used in credentialing and provider enrollment records to verify active insurance status required for clinical privileging and payer contracting within healthcare networks.

therapist preferred namethrp_pref_nm

Name a licensed therapy professional prefers to use in clinical and administrative contexts, which may differ from their legal name. Stored in provider directories and scheduling systems to ensure accurate, respectful identification in patient-facing communications and care team documentation.

therapist pricethrp_prc

Billed or contracted rate associated with therapy services provided by a licensed therapist. Used in revenue cycle and fee schedule management to establish reimbursement expectations, support insurance claims processing, and analyze cost variation across therapy service lines and payer contracts.

therapist primary indicatorthrp_prim_ind

Flag identifying a licensed therapist as the primary clinician of record responsible for a patient's therapy care plan. Used in EHR and care coordination systems to assign accountability for treatment decisions, documentation requirements, and continuity of care across therapy episodes.

therapist prioritythrp_prty

Ranking value assigned to a licensed therapy professional in care team assignment, referral routing, or scheduling systems within EHR and care management platforms. Data engineers use this field to implement provider selection logic, preferred network routing rules, and triage workflows in utilization management and payer adjudication systems.

therapist procedure datethrp_proc_dt

Date on which a licensed therapist performed a specific therapeutic procedure or intervention for a patient. Recorded in clinical and claims systems to support accurate billing, service timeline tracking, and outcome measurement across physical, occupational, speech, and behavioral health therapy.

therapist pulsethrp_pulse

Heart rate measurement recorded by a licensed therapist during patient assessment or therapeutic activity, typically expressed in beats per minute. Used in rehabilitation and physical therapy documentation to monitor patient cardiovascular response to exercise and ensure safe progression of therapy protocols.

therapist quantitythrp_qty

Numeric count representing the number of licensed therapy professionals in a provider group, care team, or claims dataset within EHR, payer, or workforce management systems. Data engineers use this field for staffing ratio calculations, network adequacy assessments, and therapy service capacity reporting in population health pipelines.

therapist racethrp_race

Racial identity of a licensed therapy professional as self-reported and recorded in workforce demographic systems. Used in healthcare workforce diversity analytics, Equal Employment Opportunity reporting, and health equity research to assess representation across therapy disciplines and clinical settings.

PreviousPage 732 of 806Next