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 end datesmpl_end_dt

The calendar date marking the conclusion of a biological specimen collection period, particularly relevant for timed or multi-day collections such as 24-hour urine or serial blood draws. Used in laboratory systems to calculate collection duration and validate specimen completeness.

sample end timesmpl_end_tm

The precise timestamp marking the conclusion of a biological specimen collection, used alongside start time to calculate total collection duration. Critical for timed laboratory collections such as glucose tolerance tests, pharmacokinetic studies, and 24-hour urine specimens.

sample entered bysmpl_ent_by

The identifier or username of the healthcare staff member who recorded the biological specimen information into the laboratory or clinical information system. Used for audit trail purposes, quality assurance tracking, and accountability in specimen chain of custody documentation.

sample ethnicitysmpl_ethn

The self-reported or recorded ethnic background of the patient from whom a biological specimen was collected. Used in clinical research, population health studies, and laboratory reference range adjustments where ethnicity-specific biological variation affects diagnostic interpretation.

sample expiration datesmpl_exp_dt

The date after which a collected biological specimen is no longer considered viable or valid for laboratory testing due to degradation, storage time limits, or stability thresholds. Used in laboratory information systems to prevent analysis of compromised specimens and ensure result accuracy.

sample external identifiersmpl_ext_id

A unique reference code assigned to a biological specimen by an external system, such as a reference laboratory, health information exchange, or external EHR platform. Used to reconcile and track specimen records across multiple systems and organizations throughout the diagnostic workflow.

sample faxsmpl_fax

The facsimile number associated with the ordering provider, facility, or contact linked to a biological specimen record. Used in laboratory information systems to transmit specimen collection instructions, requisition forms, or test results to clinical sites without electronic ordering capability.

sample feesmpl_fee

The charge assessed for the collection, processing, or analysis of a biological specimen, recorded in laboratory or billing systems. Used to support revenue cycle management, patient invoicing, and cost tracking for diagnostic services rendered within clinical or reference laboratory settings.

sample first namesmpl_first_nm

The given name of the patient associated with a biological specimen, used to verify patient identity and prevent specimen mislabeling errors. Critical for patient matching in laboratory information systems to ensure test results are accurately attributed to the correct individual.

sample flagsmpl_flg

A status indicator applied to a biological specimen to denote a specific condition such as hemolysis, lipemia, insufficient volume, or quality concern. Used in laboratory information systems to communicate specimen integrity issues that may affect the validity or interpretation of test results.

sample frequencysmpl_freq

The defined interval or schedule at which biological specimens are to be collected from a patient, such as daily, weekly, or at specific time intervals. Used in laboratory and clinical systems to coordinate serial specimen collection protocols for monitoring chronic conditions or treatment response.

sample full namesmpl_full_nm

The complete legal name of the patient associated with a biological specimen, combining given, middle, and family name components. Used in laboratory information systems for definitive patient identification, specimen labeling compliance, and regulatory reporting requirements in diagnostic workflows.

sample gendersmpl_gndr

The biological sex or gender identity recorded for the patient from whom a specimen was collected. Used in laboratory information systems to apply sex-specific reference ranges for analytes such as hemoglobin, creatinine, and hormone levels when interpreting diagnostic test results.

sample glucosesmpl_gluc

The measured concentration of glucose in a biological specimen, typically blood or plasma, recorded as part of a laboratory test result. Used to assess glycemic status, diagnose diabetes or hypoglycemia, and monitor patients on insulin therapy or glucose management protocols.

sample group numbersmpl_grp_nbr

A numeric or alphanumeric code used to associate a biological specimen with a specific study cohort, collection batch, or clinical trial group. Used in research and laboratory information systems to organize specimens for grouped analysis, quality control batching, and population-level reporting.

sample hemoglobinsmpl_hgb

The measured concentration of hemoglobin protein in a blood specimen, expressed in grams per deciliter. Used in laboratory and clinical systems to assess oxygen-carrying capacity, diagnose anemia or polycythemia, and monitor patients undergoing chemotherapy, dialysis, or chronic disease management.

sample history present illnesssmpl_hpi

The narrative documenting the patient's current condition at the time a biological specimen was collected, including onset, duration, and relevant symptoms. Captured in LIS and EHR systems to provide clinical context for laboratory analysis and result interpretation.

sample identifiersmpl_id

The unique alphanumeric code assigned to a collected biological specimen such as blood, urine, or tissue at the point of collection. Used across laboratory information systems, pathology platforms, and clinical data warehouses to track chain of custody and link results to orders.

sample indexsmpl_idx

The sequential position number assigned to a biological specimen within a batch, run, or collection set in laboratory processing workflows. Used in LIS and clinical data systems to maintain specimen ordering, manage multi-sample runs, and ensure accurate result assignment.

sample indicatorsmpl_ind

A boolean or coded flag denoting a specific condition or status of a biological specimen, such as whether it is hemolyzed, lipemic, or rejected for processing. Used in laboratory information systems to trigger workflow actions or quality control alerts during specimen handling.

PreviousPage 599 of 806Next