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

lab targetlab_tgt

Reference destination value or system endpoint associated with a laboratory record, such as a receiving provider, reporting facility, or integration target system. Used in HL7 and FHIR-based lab result routing workflows to ensure accurate delivery across healthcare data networks.

lab taxonomy codelab_tax_cd

Contains the National Uniform Claim Committee taxonomy code identifying the specialty classification of the laboratory performing the test, such as clinical pathology or microbiology. Used in claims processing and credentialing to validate provider specialty and support accurate reimbursement routing.

lab temperaturelab_temp

Records a temperature value relevant to a laboratory context, which may include patient body temperature at time of specimen collection, required specimen storage temperature, or processing environment temperature. Critical for ensuring specimen integrity and valid test results.

lab termination datelab_term_dt

Records the date on which a laboratory order, test authorization, or associated lab agreement was ended or expired. Used in lab management systems to track order validity windows, stop active standing orders, and manage contract or panel test agreements with payers.

lab timelab_tm

Time-of-day component associated with a laboratory event such as specimen collection, result release, or order entry in EHR and LIS systems. Combined with lab service date to construct full datetime stamps used in turnaround time calculations and regulatory reporting pipelines.

lab timestamplab_ts

Full datetime value capturing the precise date and time of a laboratory event such as order placement, specimen collection, or result verification in EHR and LIS systems. Used in audit trails, SLA monitoring, and temporal join logic during ETL processing in clinical data warehouses.

lab titlelab_ttl

Contains the formal name or descriptor assigned to a laboratory test, panel, or service. Used in lab information systems and clinical documentation to clearly identify ordered diagnostics, populate patient-facing reports, and support accurate mapping to standardized coding systems such as LOINC.

lab totallab_tot

Aggregated sum of costs, units, or result values associated with a laboratory service or set of tests in claims and EHR systems. Used in financial reporting, utilization management, and population health analytics to measure total lab spend or cumulative clinical burden per member.

lab total countlab_tot_cnt

Represents the aggregate number of laboratory tests, specimens, results, or service instances within a defined dataset or encounter grouping. Used in utilization management, quality reporting, and operational analytics to measure lab service volume across populations or time periods.

lab typelab_typ

Classification category identifying the nature of a laboratory test, such as hematology, microbiology, chemistry, or pathology, in EHR, LIS, and claims systems. Mapped to LOINC or CPT code groupings to support analytical reporting, cost categorization, and clinical data normalization.

lab unitlab_unt

Standard unit of measure associated with a laboratory result value, such as mg/dL, mmol/L, or cells/uL, in EHR and LIS systems. Mapped to UCUM standards during FHIR-based data normalization to ensure consistency across source systems in clinical data warehouse pipelines.

lab updated datelab_upd_dt

Captures the most recent date on which a laboratory record, result, or order was modified within the health information system. Used for audit trail maintenance, data synchronization across integrated systems, and identifying amended or corrected lab results requiring clinical review.

lab urgencylab_urg

Designates the priority level assigned to a laboratory order, typically classified as routine, urgent, or STAT. Drives turnaround time expectations in lab information systems, guides specimen processing queues, and triggers escalation protocols when critical results require immediate clinician notification.

lab valuelab_val

Quantitative or qualitative measured data point returned from a laboratory test in EHR and LIS systems, representing the core clinical finding such as glucose level or culture result. Stored alongside LOINC codes, units, and reference ranges for use in clinical analytics and quality reporting.

lab versionlab_ver

Tracks the iteration number of a laboratory test record, incrementing each time the result or associated data is amended. Used in clinical data systems to distinguish original results from corrected or updated values, ensuring audit integrity and result traceability.

lab ziplab_zip

The five or nine-digit postal code of the laboratory facility where diagnostic testing is performed. Used in claims processing and provider network management to verify in-network status, calculate geographic reimbursement rates, and support laboratory service area analysis.

location admission dateloc_admn_dt

The date a patient was admitted to a specific physical service site, such as a hospital, SNF, or inpatient facility. Captured in EHR and claims systems to support LOS calculations, authorization tracking, and facility billing workflows.

location discharge dateloc_dsch_dt

The date a patient was formally released from a specific physical service site, such as a hospital, SNF, or rehabilitation facility. Captured in EHR and claims systems to calculate length of stay, trigger post-discharge workflows, and validate inpatient billing submissions.

location labelloc_lbl

The human-readable display name assigned to a specific physical care delivery site, such as a clinic, hospital wing, or outpatient facility. Used in scheduling, clinical documentation, and reporting systems to identify where services are rendered.

location procedure dateloc_proc_dt

The calendar date on which a clinical procedure was performed at a specific care site. Used in claims adjudication and clinical records to establish service timelines, verify coverage eligibility, and support coordination of benefits across payers for facility-based services.

PreviousPage 362 of 806Next