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 agesmpl_age

The calculated age of a biological specimen from the time of collection to the current or reference date, used to assess specimen viability and testing validity. In laboratory information systems, sample age is critical for determining whether a specimen remains within acceptable stability windows for specific assays.

sample allowed amountsmpl_alwd_amt

The maximum reimbursable dollar amount approved by a payer for laboratory specimen collection, handling, or testing services associated with a specific sample. Used in revenue cycle and claims processing to determine the contractual payment ceiling before applying deductibles, co-insurance, or patient responsibility.

sample amountsmpl_amt

The physical volume or quantity of a collected biological specimen, such as milliliters of blood or grams of tissue, recorded at the time of collection. Used in laboratory information systems to verify that sufficient specimen quantity exists to complete all ordered tests without requiring recollection.

sample approved bysmpl_appr_by

The identifier or name of the authorized laboratory professional, pathologist, or clinician who reviewed and approved a biological specimen for testing or released associated results. Used in laboratory quality control workflows to maintain chain of custody and ensure accountability for specimen handling decisions.

sample arrival timesmpl_arrv_tm

The recorded timestamp indicating when a collected biological specimen was physically received at the laboratory or processing facility. Used in laboratory information systems to calculate turnaround times, assess specimen integrity based on elapsed time since collection, and meet regulatory accreditation requirements.

sample arrived datesmpl_arrv_dt

The calendar date on which a collected biological specimen was received at the laboratory or testing facility. Used in laboratory information systems to establish the beginning of the processing timeline, assess specimen viability, and support compliance reporting for turnaround time metrics.

sample assessmentsmpl_asmt

A clinical or laboratory technician's evaluation notes describing the condition, quality, or suitability of a collected biological specimen for testing. Assessments may document observations such as hemolysis, lipemia, insufficient volume, or improper labeling that could affect the validity of test results.

sample balancesmpl_bal

The remaining financial obligation associated with laboratory specimen collection or testing services after payments and adjustments have been applied. Used in revenue cycle management to track outstanding patient or payer balances tied to specific specimen-related claims or service encounters.

sample billed amountsmpl_bill_amt

The total dollar amount submitted to a payer or patient for laboratory specimen collection, handling, or testing services associated with a specific sample. Used in claims processing and revenue cycle systems to record the gross charge before contractual adjustments, denials, or payment are applied.

sample birth datesmpl_birth_dt

The date of birth of the patient from whom a biological specimen was collected, stored alongside the sample record to ensure proper patient identification and demographic matching. Used in laboratory information systems to prevent specimen mix-ups and support age-specific reference ranges for test result interpretation.

sample blood pressuresmpl_bp

The blood pressure measurement recorded for the patient at or near the time of biological specimen collection. Stored in clinical and laboratory systems to provide physiological context for test result interpretation, particularly for specimens where patient hemodynamic status may influence analyte levels or reference ranges.

sample cancelled datesmpl_cncl_dt

The date on which a previously ordered biological specimen collection or associated laboratory test was cancelled before completion. Used in laboratory information systems to track workflow interruptions, support order management auditing, and analyze patterns in test cancellations related to clinical or operational decisions.

sample categorysmpl_cat

A classification code or label identifying the type or grouping of a collected biological specimen, such as serum, plasma, whole blood, urine, or tissue. Used in laboratory information systems to route specimens to the appropriate testing department, apply relevant handling protocols, and support specimen management reporting.

sample chief complaintsmpl_cc

The primary clinical symptom or reason for the encounter documented by the ordering clinician at the time a biological specimen collection was requested. Stored in laboratory and clinical data systems to provide diagnostic context for test selection, result interpretation, and medical necessity validation for payer reimbursement.

sample childsmpl_chld

A derived or aliquoted specimen created from a parent biological sample, used in laboratory information systems to track the hierarchical relationship between an original collected specimen and any secondary containers prepared for specific testing workflows. Enables traceability across multiple tests performed from a single collection event.

sample citysmpl_city

The name of the city associated with the collection site, ordering facility, or patient address linked to a biological specimen record. Used in laboratory information systems and public health reporting to identify geographic origin of specimens, support outbreak surveillance, and manage logistics for specimen transport and result delivery.

sample classsmpl_cls

Categorizes a biological specimen into a classification tier such as serum, plasma, urine, or tissue within laboratory information systems. Drives specimen handling protocols, storage requirements, and routing rules for downstream analytical testing workflows.

sample codesmpl_cd

Standardized alphanumeric identifier assigned to a biological specimen to uniquely distinguish it across laboratory, clinical, and data warehouse systems. Used for specimen tracking from collection through processing, analysis, and result reporting in laboratory workflows.

sample commentsmpl_cmt

Free-text annotation field capturing supplementary notes about a biological specimen, such as collection difficulties, visual abnormalities, patient conditions at time of collection, or handling exceptions that may affect specimen integrity or test result interpretation.

sample completed datesmpl_cmpl_dt

Records the date on which all laboratory processing, analysis, and result verification activities for a biological specimen were finalized. Used to measure turnaround time, support quality metrics, and establish the temporal endpoint of the specimen lifecycle in laboratory systems.

PreviousPage 597 of 806Next