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

test timestamptst_ts

Combined date and time value recording the precise moment a diagnostic examination was performed, resulted, or transmitted in EHR and lab systems. Data engineers use this field for exact event sequencing, SLA monitoring, and audit trail construction in clinical data pipelines.

test titletst_ttl

The formal name assigned to a diagnostic or laboratory test within clinical systems, such as 'Complete Blood Count' or 'HbA1c Panel'. Used to standardize test identification across order entry, results reporting, and clinical documentation workflows.

test totaltst_tot

Aggregated numeric value representing the cumulative sum of scores, counts, or charges associated with a diagnostic examination in EHR, lab, or claims systems. Data engineers use this field to compute composite scores, validate panel completeness, and summarize utilization metrics.

test total counttst_tot_cnt

The cumulative number of times a specific diagnostic or laboratory test was ordered or performed within a defined period. Used in utilization reporting, quality metrics, and clinical analytics to assess testing frequency across departments, facilities, or patient populations.

test typetst_typ

Coded classification identifying the category of a diagnostic examination, such as laboratory, radiology, pathology, or functional assessment, in EHR and ancillary systems. Data engineers use this field to apply type-specific parsing rules, groupings, and reporting logic across clinical datasets.

test updated datetst_upd_dt

The most recent date on which a diagnostic test record was modified, including updates to results, status, or associated clinical data. Used in audit trails and data governance processes to track record changes across laboratory and clinical information systems.

test urgencytst_urg

The priority classification assigned to a diagnostic test order, indicating how quickly the test must be performed and results reported. Common values include STAT, urgent, and routine, and this field drives laboratory workflow prioritization and turnaround time expectations.

test versiontst_ver

A numeric or alphanumeric identifier that tracks the iteration of a diagnostic test record or test definition, capturing changes made over time to test protocols, reference ranges, or result interpretations within laboratory and clinical data systems.

test ziptst_zip

The postal code associated with the facility or location where a diagnostic test was ordered or performed. Used in geographic analysis, network reporting, and population health studies to map testing activity to specific service areas or regions.

therapist active indicatorthrp_actv_ind

A binary flag indicating whether a licensed therapy professional, such as a physical, occupational, or speech therapist, currently holds an active status within the credentialing or workforce management system, determining eligibility to provide and bill for patient services.

therapist active statusthrp_actv_sts

The current operational state of a licensed therapy professional's record within the credentialing or workforce system, such as active, inactive, or suspended. Determines whether the therapist is eligible to provide clinical services and receive reimbursement for patient care.

therapist addressthrp_addr

Physical location text for a licensed therapy professional stored in provider directories, EHR credentialing, and claims systems. Data engineers use this field to geocode provider locations, validate network participation, and support member-to-provider proximity matching in care access analytics.

therapist adjustment amountthrp_adj_amt

The dollar value of a financial adjustment applied to a therapy claim or service charge, such as a contractual write-off, payer discount, or billing correction. Used in revenue cycle management to reconcile billed amounts with allowed and paid amounts for therapy services.

therapist admission datethrp_admn_dt

Calendar date recording when a licensed therapy professional's patient was admitted to a facility, captured in EHR and claims systems. Data engineers use this field to calculate length-of-stay metrics, align therapy service timelines, and validate episode-of-care boundaries in clinical reporting workflows.

therapist agethrp_age

The current age in years of a licensed therapy professional, calculated from their date of birth. Used in workforce analytics, demographic reporting, and succession planning to assess age distribution and retirement risk across the therapy staffing population.

therapist allowed amountthrp_alwd_amt

The maximum dollar amount a payer will reimburse for therapy services rendered by a licensed therapist under a specific contract or fee schedule. This value drives payment calculations in the revenue cycle and represents the contractually negotiated rate for the service.

therapist amountthrp_amt

Monetary value representing charges, payments, or allowed amounts associated with a licensed therapy professional's services in claims and EHR billing systems. Data engineers use this field for cost analysis, reimbursement reconciliation, and therapy utilization reporting across PBM and payer platforms.

therapist approval statusthrp_appr_sts

The credentialing or administrative authorization state of a licensed therapy professional's application or service request, such as pending, approved, or denied. Used in provider enrollment and privileging workflows to govern which therapists are authorized to deliver billable services.

therapist approved bythrp_appr_by

The name or identifier of the individual, supervisor, or system that granted authorization for a licensed therapist's credentialing application, treatment plan, or service request. Used in audit trails and compliance workflows to document accountability within clinical approval processes.

therapist arrival timethrp_arrv_tm

The recorded time at which a licensed therapy professional arrived at the care setting, patient location, or home health visit site. Used in scheduling compliance, productivity tracking, and service delivery audits to verify adherence to appointment windows and visit timeliness standards.

PreviousPage 727 of 806Next