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 emergency indicatortech_emerg_ind

A flag identifying whether a technician is designated or available for emergency response duties, on-call assignments, or urgent procedural support. Used in scheduling and workforce management systems to ensure appropriate staffing coverage during critical or unplanned clinical situations.

technician end datetech_end_dt

Records the date a technician's assignment, contract, credential validity, or active status concludes within a healthcare workforce or credentialing system. Used to manage role transitions, terminate system access, and support workforce planning, compliance tracking, and historical reporting.

technician end timetech_end_tm

Captures the precise time a technician's shift, procedure participation, or scheduled assignment concludes. Used in workforce scheduling, time and attendance systems, and operational analytics to calculate worked hours, measure productivity, and ensure adequate clinical staffing coverage across departments.

technician entered bytech_ent_by

Identifies the user who created or submitted the technician's record within a workforce management, credentialing, or scheduling system. Used in audit trails to establish data accountability, support change management reviews, and maintain integrity of technician records across healthcare administrative systems.

technician ethnicitytech_ethn

Records the self-reported ethnic background of a pharmacy, radiology, or clinical support technician. Used in workforce diversity reporting, EEO compliance, and health equity analytics to monitor representation across technician roles and meet federal and state workforce demographic reporting requirements.

technician expiration datetech_exp_dt

Captures the date on which a technician's license, certification, background check, or system access authorization expires. Used in credentialing and workforce compliance systems to trigger renewal workflows, prevent lapses in authorized practice, and meet accreditation and regulatory requirements.

technician external identifiertech_ext_id

Stores a unique identifier assigned to a technician by an external system such as a state licensing board, pharmacy benefit manager, or third-party credentialing organization. Enables cross-system record matching, identity resolution, and data exchange between internal workforce systems and external regulatory or partner platforms.

technician faxtech_fax

Stores the fax number associated with a pharmacy, radiology, or clinical support technician or their department. Used in workforce directories and credentialing systems to support document transmission for licensing submissions, prior authorizations, and inter-facility communications requiring physical record exchange.

technician feetech_fee

Records the compensation amount or service charge associated with a technician's role, contracted services, or specific procedural involvement. Used in workforce cost management, vendor billing, and healthcare operational finance systems to track technician-related expenditures and support budgeting and reimbursement analysis.

technician first nametech_first_nm

Stores the legal given name of a pharmacy, radiology, or clinical support technician as recorded in workforce management or credentialing systems. Used for identification, directory listings, scheduling displays, and correspondence to distinguish individual technicians within shared departmental and cross-facility staffing databases.

technician flagtech_flg

A configurable binary indicator associated with a technician's record used to mark specific conditions such as restricted status, pending verification, special designation, or system alerts. Used in workforce and credentialing systems to trigger workflows, filter records, or highlight technicians requiring administrative attention or review.

technician full nametech_full_nm

The complete concatenated name of a pharmacy or clinical technician, including first, middle, and last name components. Used in pharmacy dispensing systems, lab workflows, and staffing records to identify the technician responsible for a task or procedure.

technician gendertech_gndr

The biological sex or gender identity classification recorded for a pharmacy or clinical technician in workforce management systems. Used in HR reporting, staff demographic analysis, and compliance tracking across healthcare staffing and credentialing platforms.

technician glucosetech_gluc

The measured blood glucose level recorded for a technician during an occupational health screening or employee wellness assessment. Captured in workplace health programs to monitor metabolic conditions and support preventive care initiatives for healthcare staff.

technician hemoglobintech_hgb

The measured hemoglobin concentration recorded for a technician during an occupational health screening or employee wellness exam. Used in workplace health monitoring programs to assess anemia risk and overall blood health status among healthcare staff.

technician history present illnesstech_hpi

The narrative description of a technician's current medical complaint or condition as documented during an occupational health or employee health visit. Captures onset, duration, and relevant clinical details to support diagnosis and treatment within workplace health programs.

technician identifiertech_id

The unique alphanumeric code assigned to a pharmacy or clinical technician within a healthcare system. Serves as the primary key for linking technician records across dispensing platforms, scheduling systems, lab information systems, and workforce management databases.

technician indextech_idx

A numeric position or sequence value assigned to a technician record within a dataset or processing queue. Used in pharmacy dispensing systems and laboratory workflows to order, sort, or reference technician entries during batch processing and reporting operations.

technician indicatortech_ind

A flag or boolean value that denotes a specific status or condition associated with a pharmacy or clinical technician, such as active certification, employment status, or shift availability. Used in staffing and credentialing systems to filter and route technician assignments.

technician instructiontech_instr

The written procedural guidance or task-specific directions associated with a technician's assigned duties in a pharmacy, laboratory, or clinical setting. Supports standardized workflows by documenting preparation steps, safety protocols, or dispensing procedures tied to a technician record.

PreviousPage 715 of 806Next