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 confidential indicatorsmpl_conf_ind

Boolean flag designating a biological specimen as requiring restricted access due to sensitive clinical context, such as HIV testing, substance abuse screening, or genetic analysis. Controls which personnel and systems can view specimen data in compliance with privacy regulations.

sample countsmpl_cnt

Numeric value representing the total quantity of biological specimens collected, received, or processed within a defined scope such as a patient encounter, laboratory batch, or reporting period. Used for inventory management, workload tracking, and laboratory throughput reporting.

sample countrysmpl_ctry

Identifies the country associated with the collection or origination of a biological specimen, particularly relevant in international research studies, reference laboratory workflows, and public health surveillance where specimen geographic origin affects testing or reporting requirements.

sample created bysmpl_crtd_by

Captures the username or system identifier of the user or process that initially registered a biological specimen record in the laboratory or clinical information system. Used for audit trail accountability, chain of custody documentation, and data quality tracking.

sample created datesmpl_crtd_dt

Records the calendar date on which a biological specimen record was first entered into the laboratory or clinical information system. Supports audit trail requirements, specimen lifecycle tracking, and differentiation between record creation date and actual physical collection date.

sample created timesmpl_crtd_tm

Captures the precise time of day when a biological specimen record was first entered into the laboratory or clinical information system. Combined with the created date, enables accurate timestamping for audit trails, chain of custody documentation, and turnaround time calculations.

sample creatininesmpl_cr

Measured concentration of creatinine in a biological specimen, typically urine or serum, used to assess kidney function or normalize urinary analyte concentrations in drug screening and toxicology. A key diagnostic marker for detecting renal impairment or specimen dilution in laboratory analysis.

sample datesmpl_dt

Records the calendar date on which a biological specimen was physically collected from a patient. Establishes the temporal reference point for result interpretation, longitudinal trend analysis, and clinical decision-making within laboratory and electronic health record systems.

sample datetimesmpl_dttm

Combined timestamp recording both the date and time at which a biological specimen was collected from a patient. Provides precise temporal context for time-sensitive analytes, serial specimen comparisons, pharmacokinetic monitoring, and regulatory chain of custody documentation.

sample dea numbersmpl_dea_nbr

Drug Enforcement Administration registration number associated with a biological specimen collected in the context of controlled substance monitoring, forensic toxicology, or pain management testing. Links specimen handling and chain of custody to DEA-regulated compliance and reporting requirements.

sample death datesmpl_death_dt

Records the date of a patient's death as it relates to a biological specimen, particularly relevant in post-mortem toxicology, forensic pathology, and research biobanking contexts. Used to correlate specimen findings with mortality data and support cause-of-death investigations.

sample deleted datesmpl_del_dt

Captures the date on which a biological specimen record was logically removed or voided from the laboratory or clinical information system. Supports audit trail integrity, regulatory compliance, and data governance by preserving a historical record of when the deletion action occurred.

sample deleted indicatorsmpl_del_ind

Boolean flag indicating that a biological specimen record has been logically voided or removed from active use in the laboratory information system without physically purging the data. Enables soft-delete functionality to preserve audit history while excluding the record from active processing and reporting workflows.

sample descriptionsmpl_desc

Human-readable text field providing a narrative explanation of a biological specimen, including its type, source, appearance, or collection method. Used by laboratory staff to communicate specimen characteristics in reports, requisitions, and clinical documentation systems.

sample detailsmpl_dtl

Granular supplementary information associated with a biological specimen, such as collection site specifics, volume collected, tube type, or patient preparation notes. Provides the contextual detail necessary for accurate laboratory processing, result interpretation, and clinical documentation.

sample discharge datesmpl_dsch_dt

Records the inpatient discharge date associated with a biological specimen collected during a hospital stay. Used to contextualize specimen results within the inpatient episode of care, support length-of-stay analytics, and link laboratory data to facility billing and clinical outcome records.

sample due datesmpl_due_dt

The deadline by which a collected biological specimen must be processed, analyzed, or delivered to the laboratory. Used in laboratory information systems to prioritize specimen handling, ensure timely test results, and maintain chain of custody compliance for clinical diagnostics.

sample durationsmpl_dur

The total elapsed time associated with a biological specimen collection process, such as the length of a timed urine collection or continuous blood draw period. Used in laboratory workflows to validate specimen integrity and ensure collection protocols were followed correctly.

sample emailsmpl_eml

The electronic mail address associated with the ordering provider, patient, or laboratory contact linked to a biological specimen record. Used in laboratory information systems to route result notifications, collection instructions, and specimen status updates to the appropriate recipient.

sample emergency indicatorsmpl_emerg_ind

A binary flag designating a biological specimen as requiring urgent or STAT processing priority within the laboratory workflow. When set, this indicator triggers expedited handling, analysis, and result reporting to support critical clinical decision-making in acute care settings.

PreviousPage 598 of 806Next