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 keytech_key

A surrogate or natural key value used to uniquely reference a technician record in relational database schemas across pharmacy, laboratory, or clinical data systems. Enables efficient joins and lookups when linking technician activity to claims, orders, or encounter records.

technician labeltech_lbl

A human-readable display string associated with a technician record, used in user interface screens, printed reports, and audit logs within pharmacy dispensing systems, lab information systems, and clinical data warehouses to identify the technician contextually.

technician languagetech_lang

The primary or preferred spoken and written language of a pharmacy or clinical technician, recorded in workforce management and HR systems. Used to support multilingual communication, patient safety initiatives, and appropriate staff assignments in diverse healthcare settings.

technician last nametech_last_nm

The family surname of a pharmacy or clinical technician as recorded in staffing, credentialing, and dispensing systems. Used in combination with first and middle name fields to construct the full name for identification, reporting, and audit trail documentation.

technician legal nametech_legal_nm

The official government-registered name of a pharmacy or clinical technician, used for licensure verification, credentialing applications, payroll processing, and regulatory compliance. Must match the name on issued professional licenses and government-issued identification documents.

technician leveltech_lvl

The classification tier indicating a technician's rank, experience, or scope of authorized duties within a pharmacy, laboratory, or clinical department. Used in staffing models, pay grade structures, and task assignment logic to align duties with verified competency and certification status.

technician license numbertech_lic_nbr

The state-issued or nationally recognized license identifier assigned to a pharmacy or clinical technician upon successful credentialing. Used to verify active licensure status, meet regulatory compliance requirements, and link dispensing or procedural activities to a validated credentialed individual.

technician marital statustech_mar_sts

The recorded marital or domestic partnership status of a pharmacy or clinical technician, maintained in HR and benefits administration systems. Used to determine eligibility for dependent benefits, tax withholding classifications, and workforce demographic reporting across healthcare organizations.

technician master identifiertech_mstr_id

The enterprise-level master person index identifier assigned to a technician to uniquely resolve their identity across multiple systems, facilities, and departments. Enables consistent cross-platform matching of technician records in pharmacy, lab, HR, and clinical data environments.

technician maximumtech_max

The upper boundary value associated with a technician-specific metric or operational parameter, such as maximum allowable dispensing volume, patient load, or work hours. Used in pharmacy management and staffing systems to enforce safety thresholds and regulatory workload limits.

technician middle nametech_mid_nm

The middle name or initial of a pharmacy or clinical technician as stored in workforce and credentialing systems. Used alongside first and last name fields to disambiguate technicians with similar names in staffing records, licensure databases, and dispensing audit trails.

technician minimumtech_min

The lower threshold value associated with a technician record, such as minimum required hours, caseload, or competency score. Used in workforce management systems to enforce staffing standards and ensure technicians meet baseline operational or credentialing requirements.

technician mobiletech_mob

The mobile phone number on record for a healthcare technician, such as a pharmacy, radiology, or lab technician. Used in staff directories, scheduling systems, and urgent care coordination to enable direct contact with technicians for patient care or operational needs.

technician modified bytech_mod_by

The unique identifier of the user who last updated a technician's record in the healthcare system. Supports data governance and audit trail requirements by tracking which staff member or system process made the most recent change to technician profile or assignment data.

technician modified datetech_mod_dt

The calendar date on which a technician's record was most recently updated in the healthcare system. Used in audit logging, data quality monitoring, and change tracking workflows to establish when modifications to technician profile, credentials, or assignment data occurred.

technician modified timetech_mod_tm

The precise time at which a technician's record was last updated in the healthcare system. Combined with the modified date, this field provides a full timestamp for audit trail and data governance purposes, supporting compliance reviews and system change reconciliation.

technician nametech_nm

The full legal or display name of a healthcare technician, such as a pharmacy, surgical, or radiology technician. Used across scheduling, clinical documentation, and reporting systems to identify the individual performing technical procedures or supporting clinical care delivery.

technician notetech_nt

Free-text annotation associated with a technician's record, capturing relevant details such as scheduling exceptions, credentialing observations, or workflow instructions. Used by supervisors and administrators to document non-standard information that does not fit structured data fields.

technician numbertech_nbr

A unique numeric identifier assigned to a healthcare technician within a facility or enterprise system. Used to reference and track the technician across scheduling, payroll, credentialing, and clinical documentation systems without relying on name-based lookups.

technician onset datetech_onset_dt

The date on which a specific condition, assignment, role, or status became active for a technician record. Used in workforce management and credentialing systems to track when a technician's qualification, restriction, or employment status change took effect.

PreviousPage 716 of 806Next