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 surgery datesmpl_surg_dt

The calendar date on which a surgical procedure was performed from which the associated biological specimen was collected, such as a tissue biopsy or intraoperative sample. Links the specimen record to the operative event in surgical pathology and clinical data systems.

sample targetsmpl_tgt

The intended analyte, organism, gene sequence, or biological marker that a collected specimen is being tested to detect or measure. Defines the diagnostic or research objective in laboratory information systems, guiding test ordering, instrumentation selection, and result interpretation.

sample taxonomy codesmpl_tax_cd

A standardized classification code identifying the biological or microbial category of a collected specimen, such as SNOMED or LOINC taxonomy values. Used in laboratory and clinical data systems to categorize specimen types for routing, processing protocol selection, and regulatory reporting.

sample temperaturesmpl_temp

The recorded storage or transport temperature of a collected biological specimen, measured in Celsius or Fahrenheit. Critical in laboratory information systems for ensuring specimen integrity, validating cold-chain compliance, and flagging samples that may have experienced temperature excursions compromising test validity.

sample termination datesmpl_term_dt

The date on which a collected biological specimen was formally retired, discarded, or removed from active use within a laboratory or biorepository system. Used to manage specimen lifecycle, support retention policy compliance, and maintain accurate inventory records in clinical data warehouses.

sample timesmpl_tm

The specific time of day at which a biological specimen was collected from the patient, recorded in 24-hour or AM/PM format. Clinically significant for time-sensitive tests such as fasting glucose, cortisol, therapeutic drug levels, and cultures where collection timing affects result interpretation.

sample timestampsmpl_ts

The precise date and time at which a key event occurred for a biological specimen, such as collection, receipt, processing, or resulting. Used in laboratory information systems to establish an auditable chronological record supporting turnaround time tracking, chain of custody, and regulatory compliance.

sample titlesmpl_ttl

The formal descriptive name or label assigned to a collected biological specimen, distinguishing it within a study protocol, clinical trial, or laboratory workflow. Used in research databases and laboratory information systems to provide human-readable identification alongside coded specimen identifiers.

sample totalsmpl_tot

The complete aggregated numeric value representing a summation of all measurements, counts, or quantities associated with a set of collected biological specimens in a batch, study, or reporting period. Used in laboratory analytics and clinical data warehouses for quality and throughput reporting.

sample total countsmpl_tot_cnt

The complete numerical count of all collected biological specimens included within a defined batch, study cohort, laboratory run, or reporting period. Used in laboratory information systems and clinical data warehouses to track volume metrics, capacity planning, and population-level specimen analysis.

sample typesmpl_typ

The categorical classification identifying the nature of a collected biological specimen, such as whole blood, serum, plasma, urine, cerebrospinal fluid, or tissue. Determines the applicable collection protocol, storage requirements, processing method, and permissible laboratory tests in clinical and laboratory information systems.

sample updated datesmpl_upd_dt

The most recent date on which a collected biological specimen record was modified in the laboratory or clinical data system, including changes to status, results, storage location, or metadata. Used for audit trail maintenance, data synchronization, and identifying recently amended specimen records.

sample urgencysmpl_urg

The clinical priority level assigned to a collected biological specimen indicating how quickly testing and results must be completed, such as routine, urgent, or STAT. Drives laboratory workflow prioritization, instrument queuing, and turnaround time expectations in laboratory information and order management systems.

sample versionsmpl_ver

The sequential version number assigned to a biological specimen record, incrementing each time the record is amended, corrected, or updated in the laboratory or clinical data system. Supports audit trail integrity, result correction tracking, and historical comparison across specimen record states.

sample zipsmpl_zip

The postal ZIP code associated with the collection site, patient address, or submitting facility from which a biological specimen originated. Used in laboratory and public health data systems for geographic tracking, disease surveillance, regional reporting, and specimen routing logistics.

satisfaction active indicatorsat_actv_ind

A binary flag designating whether a patient satisfaction survey record is currently active and valid for use in reporting and analysis. Inactive records may reflect superseded, withdrawn, or test submissions, allowing clinical quality teams to filter accurate data when measuring patient experience performance metrics.

satisfaction active statussat_actv_sts

Indicates whether a patient satisfaction survey record is currently active, inactive, or pending within the survey management system. Used to filter valid responses from voided or incomplete submissions when aggregating patient experience metrics and HCAHPS scores.

satisfaction admission datesat_admn_dt

The inpatient admission date associated with a patient satisfaction survey, linking the survey response to the specific hospital encounter being evaluated. Used to correlate experience scores with clinical episode data and measure satisfaction trends across admission periods.

satisfaction agesat_age

The patient's age at the time of the satisfaction survey submission or the associated care encounter. Used to segment patient experience scores by age cohort, supporting demographic analysis of satisfaction trends and identifying age-specific service improvement opportunities.

satisfaction allowed amountsat_alwd_amt

The maximum reimbursable amount associated with the care encounter linked to a patient satisfaction survey record. Used when connecting financial claims data to experience scores, enabling analysis of cost-of-care perceptions relative to payer-approved reimbursement amounts.

PreviousPage 603 of 806Next