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

technician oxygen saturationtech_o2sat

The recorded blood oxygen saturation (SpO2) measurement taken or monitored by a healthcare technician during patient care. Captured in clinical documentation systems to reflect respiratory monitoring activity performed by respiratory or clinical technicians during patient assessment.

technician paid amounttech_pd_amt

The dollar amount paid to or on behalf of a healthcare technician for services rendered, shifts worked, or claims processed. Used in payroll, contract management, and claims adjudication systems to track compensation or reimbursement associated with technician labor or service delivery.

technician paid datetech_pd_dt

The date on which payment was issued to or processed for a healthcare technician. Used in payroll and financial management systems to confirm disbursement timing, support reconciliation of technician compensation records, and meet regulatory reporting requirements.

technician parenttech_prnt

The identifier of the parent entity, such as a supervising technician, department, or organizational unit, to which a technician record is hierarchically linked. Used in workforce management systems to establish reporting structures and support rollup reporting across teams or facilities.

technician percentagetech_pct

A percentage value associated with a technician record, such as FTE allocation, productivity rate, or cost-sharing proportion. Used in workforce analytics and financial systems to quantify a technician's contribution, workload distribution, or reimbursement split across departments or cost centers.

technician periodtech_prd

The defined time interval associated with a technician's assignment, contract, evaluation cycle, or performance measurement. Used in scheduling, credentialing, and workforce analytics systems to bound the duration of a technician's active role, shift block, or reporting period.

technician phonetech_ph

The primary telephone number on record for a healthcare technician, used for workplace contact, scheduling notifications, and emergency communication. Maintained in staff directories and workforce management systems to support operational coordination across clinical and administrative departments.

technician preferred nametech_pref_nm

The name a healthcare technician has chosen to be identified by in workplace systems, which may differ from their legal name. Used in staff-facing applications, scheduling tools, and communications to ensure respectful and accurate identification of technicians in daily operations.

technician pricetech_prc

The established cost or billing rate associated with a technician's services, such as hourly labor cost or procedure-level charge. Used in financial management, contract pricing, and claims billing systems to calculate reimbursement or internal chargebacks for technician-performed services.

technician primary indicatortech_prim_ind

A flag identifying whether a technician is the primary assignee for a case, shift, patient, or procedure. Used in scheduling and clinical workflow systems to distinguish the lead technician from secondary support staff, ensuring clear accountability in care delivery and documentation.

technician prioritytech_prty

A ranking or urgency level assigned to a technician's task, case, or work queue item. Used in clinical operations and scheduling systems to sequence technician workloads, ensuring high-priority patient needs or time-sensitive procedures are addressed before lower-acuity assignments.

technician procedure datetech_proc_dt

The calendar date on which a healthcare technician performed a specific clinical procedure or diagnostic test. Used in clinical data systems to establish procedure timelines, support billing validation, and correlate technician-performed services with patient encounter records.

technician pulsetech_pulse

The pulse rate, measured in beats per minute, recorded by a healthcare technician during patient assessment or vital sign collection. Captured in clinical documentation systems to establish baseline cardiovascular metrics and monitor patient status across care episodes.

technician quantitytech_qty

The numeric count of units, supplies, tests, or procedures handled or processed by a healthcare technician during a given encounter or work session. Used in operational reporting, supply chain tracking, and workload analysis within clinical data management systems.

technician racetech_race

The self-reported racial identity of the healthcare technician as recorded in workforce demographic systems. Used for workforce diversity reporting, Equal Employment Opportunity compliance, and healthcare equity analyses across facility staffing records.

technician rangetech_rng

The defined minimum and maximum acceptable values for a measurement or test result recorded by a healthcare technician. Used in laboratory and diagnostic systems to flag results outside normal reference intervals and support clinical decision-making and quality review.

technician ratetech_rt

The established compensation or billing rate associated with services performed by a healthcare technician. Used in payroll systems, claims adjudication, and cost accounting workflows to calculate technician-level service costs and support reimbursement processing.

technician ratingtech_rtg

A standardized performance or competency score assigned to a healthcare technician based on skills assessments, quality audits, or supervisory evaluations. Used in workforce management systems to track professional development, credentialing status, and service quality benchmarks.

technician ratiotech_ratio

The calculated proportion representing the relationship between technicians and a comparison metric such as patients, procedures, or shifts. Used in staffing analytics and operational planning to assess workload distribution and compliance with regulatory staffing standards.

technician reasontech_rsn

A coded or free-text explanation provided by a healthcare technician to justify a clinical action, result modification, procedural deviation, or documentation correction. Used in audit trails, quality management systems, and clinical review workflows to ensure accountability.

PreviousPage 717 of 806Next