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 onset datesmpl_onset_dt

Date on which the patient first experienced symptoms associated with the condition prompting specimen collection. Critical for infectious disease surveillance, clinical trial eligibility determination, and correlating laboratory results with the clinical timeline of illness progression.

sample oxygen saturationsmpl_o2sat

Measured percentage of hemoglobin binding sites occupied by oxygen in a blood specimen at the time of collection. Used in clinical laboratory and respiratory care contexts to assess pulmonary function, guide oxygen therapy decisions, and monitor patients with cardiopulmonary conditions.

sample paid amountsmpl_pd_amt

Dollar amount reimbursed or received in connection with laboratory specimen collection, processing, or testing services. Used in revenue cycle management to reconcile laboratory billing claims, track payer payments, and identify underpayments or outstanding balances tied to specimen-related services.

sample paid datesmpl_pd_dt

Date on which payment was received or posted for laboratory specimen collection or testing services rendered. Used in revenue cycle and laboratory billing workflows to reconcile accounts receivable, monitor payer remittance timelines, and support financial reporting for lab operations.

sample parentsmpl_prnt

Reference identifier linking a derived or aliquoted specimen to its original source specimen in a laboratory information system. Enables traceability of secondary samples such as sub-aliquots or processed fractions back to the primary collected biological material for quality and audit purposes.

sample percentagesmpl_pct

Proportional value expressed as a percentage associated with a biological specimen attribute, such as percent composition, purity, viability, or analyte concentration relative to a reference standard. Used in laboratory analytics and quality control workflows to interpret specimen characteristics.

sample periodsmpl_prd

Defined time interval over which a biological specimen was collected, such as a 24-hour urine collection window or a timed blood draw series. Contextualizes laboratory results by establishing the duration of specimen accumulation relevant to timed diagnostic or monitoring tests.

sample phonesmpl_ph

Telephone contact number associated with the submitting clinician, ordering provider, or patient linked to a biological specimen. Used in laboratory operations to facilitate communication regarding collection instructions, critical result notifications, or specimen rejection and recollection requests.

sample preferred namesmpl_pref_nm

Preferred or standardized display name for a biological specimen type used within laboratory information systems to ensure consistent identification across departments. May differ from default system labels to reflect institutional naming conventions, study protocols, or clinician ordering preferences.

sample pricesmpl_prc

Monetary amount charged for collecting, processing, or testing a biological specimen, reflecting laboratory fee schedule rates. Used in laboratory billing, contract pricing analysis, and cost accounting to evaluate specimen-level revenue, payer contract compliance, and service line profitability.

sample primary indicatorsmpl_prim_ind

Boolean flag designating a specimen as the primary or principal sample among multiple related specimens collected from a patient encounter. Used in laboratory workflows to direct analysis, prioritize processing queues, and distinguish the authoritative specimen for result reporting purposes.

sample prioritysmpl_prty

Urgency classification assigned to a biological specimen indicating required processing and reporting speed, such as STAT, routine, or timed. Drives laboratory workflow sequencing, instrumentation queuing, and turnaround time expectations to align specimen handling with clinical urgency requirements.

sample procedure datesmpl_proc_dt

Date on which a clinical procedure associated with specimen collection was performed, such as a biopsy, surgical resection, or invasive draw. Used to correlate pathology or laboratory findings with procedural events in the patient record and support accurate clinical documentation.

sample pulsesmpl_pulse

Patient heart rate in beats per minute recorded at the time of biological specimen collection. Captured as a concurrent vital sign to provide clinical context for laboratory result interpretation, particularly relevant for specimens where hemodynamic status may influence analyte values.

sample quantitysmpl_qty

Measured volume, mass, or unit count of a collected biological specimen, such as milliliters of blood or grams of tissue. Used in laboratory information systems to verify specimen adequacy for ordered tests, manage aliquoting, and flag insufficient sample volumes before processing begins.

sample racesmpl_race

Racial or ethnic classification of the patient from whom a biological specimen was collected, as self-reported or documented in the medical record. Used in population health research, epidemiological studies, and clinical analytics to identify health disparities and contextualize laboratory reference ranges.

sample rangesmpl_rng

The acceptable minimum and maximum boundary values for a laboratory specimen measurement or test result. Used in clinical lab systems to flag results as normal, low, or high based on reference intervals established for patient age, sex, and specimen type.

sample ratesmpl_rt

The billable unit price or reimbursement rate associated with collecting, processing, or analyzing a laboratory specimen. Used in laboratory billing and revenue cycle systems to calculate charges for specimen handling, diagnostic testing, and pathology services submitted on claims.

sample ratingsmpl_rtg

A quality or priority assessment score assigned to a laboratory specimen that reflects its suitability for analysis, integrity upon receipt, or clinical urgency. Used in laboratory information systems to prioritize specimen processing and flag samples requiring recollection or special handling.

sample ratiosmpl_ratio

The proportional relationship between a specimen component and a reference value, such as a dilution factor, concentration ratio, or analyte-to-baseline comparison. Used in clinical laboratory analysis to normalize specimen measurements and ensure accurate quantitative test result interpretation.

PreviousPage 601 of 806Next