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

sample instructionsmpl_instr

The handling, processing, or collection guidance associated with a specific biological specimen type, such as required temperature, centrifugation steps, or storage conditions. Referenced in LIS and clinical workflow systems to ensure proper pre-analytical specimen management.

sample keysmpl_key

The primary lookup or join reference value used to link a biological specimen record to related entities such as orders, patients, or test results in laboratory and clinical data systems. Supports relational data integrity across LIS, EHR, and data warehouse environments.

sample labelsmpl_lbl

The human-readable display text printed or affixed to a biological specimen container, typically including patient name, collection date, specimen type, and accession number. Used in LIS and specimen management systems to ensure correct identification throughout the testing process.

sample languagesmpl_lang

The language code associated with collection instructions, result reporting, or patient communication materials related to a biological specimen. Stored in LIS and clinical systems to ensure language-appropriate documentation is provided to patients and clinical staff during specimen collection.

sample last namesmpl_last_nm

The patient's family surname recorded at the time of biological specimen collection, used to link the specimen to the correct patient record. Stored in LIS and EHR systems to support patient matching, chain of custody verification, and accurate result delivery.

sample legal namesmpl_legal_nm

The patient's official registered full name as recorded on a government-issued identification at the time of biological specimen collection. Used in laboratory and clinical systems to satisfy regulatory requirements and ensure accurate patient identity verification during specimen processing.

sample levelsmpl_lvl

The hierarchical classification indicating where a biological specimen falls within a multi-tier sample structure, such as primary tube, aliquot, or sub-sample. Used in LIS and biorepository systems to manage specimen derivation chains and support accurate tracking of split or derived specimens.

sample license numbersmpl_lic_nbr

The professional or facility license identifier associated with the entity authorized to collect or process a biological specimen, such as a phlebotomist or clinical laboratory. Stored in LIS and compliance systems to support regulatory auditing and specimen collection accountability.

sample marital statussmpl_mar_sts

The recorded marital status of the patient from whom a biological specimen was collected, captured as part of demographic intake at collection. Stored in LIS and clinical data systems where patient demographics accompany specimen records for epidemiological reporting or research purposes.

sample master identifiersmpl_mstr_id

The enterprise-level master identifier linking a biological specimen to a patient's record across multiple systems, such as an EMPI-assigned number. Used in LIS, EHR, and data integration platforms to reconcile specimen data and ensure consistent patient identity resolution across the healthcare enterprise.

sample maximumsmpl_max

The upper threshold value defined for an acceptable biological specimen measurement, such as maximum volume, concentration, or reference range limit. Used in LIS and clinical data systems to flag specimens or results that exceed established limits, triggering quality review or reflex testing workflows.

sample middle namesmpl_mid_nm

The patient's middle name or initial recorded at the time of biological specimen collection to support accurate patient identity matching. Stored in LIS and clinical systems as part of the full name field set used during patient verification and specimen labeling processes.

sample minimumsmpl_min

The lower threshold value defined for an acceptable biological specimen measurement, such as minimum volume required for a valid test. Used in LIS and clinical data systems to identify insufficient specimens, reject inadequate collections, and ensure analytical quality standards are met before processing.

sample mobilesmpl_mob

The patient's mobile phone number captured at the time of biological specimen collection, used for result notification, appointment reminders, or follow-up communication. Stored in LIS and patient engagement systems to support outreach when specimen results are available or collection issues arise.

sample modified bysmpl_mod_by

The user identifier of the individual who last updated a biological specimen record in the laboratory or clinical data system. Captured in LIS and data warehouse audit logs to maintain chain of custody accountability, support compliance reviews, and track specimen record changes over time.

sample modified datesmpl_mod_dt

The date and timestamp recording the most recent update made to a biological specimen record in a laboratory or clinical data system. Used in LIS and data warehouse environments to support audit trail requirements, data reconciliation, and tracking of specimen status changes throughout the testing lifecycle.

sample modified timesmpl_mod_tm

Timestamp recording the most recent modification to a biological sample record in laboratory or clinical systems. Supports audit trail integrity, chain-of-custody tracking, and ensures downstream analytical systems reflect the latest sample metadata updates.

sample namesmpl_nm

Human-readable label assigned to a collected biological specimen such as blood, urine, or tissue in laboratory information systems. Used by clinicians and lab technicians to identify and reference the specimen during processing, testing, and results reporting workflows.

sample notesmpl_nt

Free-text annotation field capturing supplemental clinical or operational observations about a collected biological specimen. May document collection irregularities, handling instructions, patient conditions at time of collection, or quality concerns flagged by laboratory personnel during processing.

sample numbersmpl_nbr

Unique alphanumeric identifier assigned to a collected biological specimen at the point of collection or registration in a laboratory information system. Used to track the specimen across collection, transport, processing, testing, and results reporting throughout its lifecycle.

PreviousPage 600 of 806Next