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 completed datetech_cmpl_dt

The date on which a technician formally completed an assigned clinical task, procedure, or service, such as specimen collection, imaging, or equipment setup. Used in workflow tracking systems to measure turnaround times, monitor productivity, and support billing cycle completion.

technician confidential indicatortech_conf_ind

A binary flag denoting that a technician's record or associated patient data contains sensitive information subject to restricted access controls. Used in EHR and clinical data systems to enforce privacy policies, limit record visibility, and maintain compliance with HIPAA confidentiality requirements.

technician counttech_cnt

A numeric value representing the total number of technicians, technician records, or technician-performed procedures within a defined dataset, time period, or organizational unit. Used in operational reporting and staffing analytics to assess workload distribution and resource allocation.

technician countrytech_ctry

The nation associated with a technician's practice location or credentialing address. Used in licensure verification, credentialing databases, and workforce management systems to confirm that a technician's certifications meet the regulatory requirements of the country where care is delivered.

technician created bytech_crtd_by

The system username or user identifier of the individual who initially created the technician's record in the clinical or administrative data system. Used for audit trail purposes to establish data provenance, support accountability, and enable investigation of data entry discrepancies.

technician created datetech_crtd_dt

The calendar date on which a technician's record was first entered into the clinical or administrative system. Used in credentialing, HR, and audit systems to establish the record's origin, track onboarding timelines, and support data governance and compliance review processes.

technician created timetech_crtd_tm

The timestamp indicating the precise time of day when a technician's record was initially created in the system. Used alongside the created date in audit logs and data governance workflows to establish an accurate chronological record of data entry and system activity.

technician creatininetech_cr

Serum or urine creatinine laboratory value recorded as part of a patient's metabolic assessment when collected or processed by a clinical technician. Used in clinical data systems to monitor kidney function, with the technician association enabling quality control and specimen chain-of-custody tracking.

technician datetech_dt

A generic date field associated with a technician record or technician-performed activity, capturing the relevant calendar date for a specific clinical or administrative event. The precise meaning is context-dependent and typically qualified by adjacent fields describing the nature of the dated event.

technician datetimetech_dttm

A combined date and time stamp associated with a technician-related event or record entry, capturing both the calendar date and time of day in a single field. Used in clinical workflow and audit systems to provide precise temporal sequencing of technician actions and documentation.

technician dea numbertech_dea_nbr

The Drug Enforcement Administration registration number assigned to a technician authorized to handle controlled substances, such as pharmacy technicians. Used in pharmacy management and regulatory compliance systems to verify authorization, track controlled substance dispensing, and satisfy federal DEA recordkeeping requirements.

technician death datetech_death_dt

Records the date of death for a pharmacy or radiology technician in workforce management systems. Used to terminate active records, update staffing rosters, and ensure compliance with licensing board notifications when a credentialed technician is deceased.

technician deleted datetech_del_dt

Captures the date a technician's record was logically removed from the healthcare workforce or credentialing system. Used in audit trails to track when technician profiles were deactivated, supporting data governance, compliance reviews, and historical staffing analysis.

technician deleted indicatortech_del_ind

A flag denoting whether a technician's record has been logically deleted from the workforce or credentialing system without physical removal. Enables filtering of inactive technician records from active rosters while preserving historical data for auditing and regulatory compliance purposes.

technician descriptiontech_desc

A free-text field capturing role-specific details about a pharmacy, radiology, or surgical technician, including specialty area, scope of duties, or certification type. Used in workforce directories, credentialing databases, and staffing systems to provide human-readable context for the technician record.

technician detailtech_dtl

Stores granular information associated with a technician's profile in workforce or credentialing systems, such as specialty certification, department assignment, or competency records. Supports scheduling, staffing analysis, and regulatory reporting across pharmacy, radiology, and surgical support departments.

technician discharge datetech_dsch_dt

Records the date a technician was formally separated, terminated, or released from employment or a contracted role within a healthcare organization. Used in workforce management systems to close active assignments, update staffing records, and support HR reporting and compliance documentation.

technician due datetech_due_dt

Captures a deadline associated with a technician's required action, such as license renewal, certification completion, competency assessment, or mandatory training submission. Used in credentialing and workforce compliance systems to track and enforce regulatory and organizational requirements.

technician durationtech_dur

Represents the length of time associated with a technician's assignment, shift, procedure involvement, or credential validity period. Used in scheduling, workforce analytics, and credentialing systems to measure active engagement, contract length, or the time span of a specific clinical support activity.

technician emailtech_eml

Stores the professional email address for a pharmacy, radiology, or clinical support technician. Used in workforce management and credentialing systems to facilitate direct communication, deliver compliance notifications, and support identity verification across healthcare operational and administrative platforms.

PreviousPage 714 of 806Next