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 deleted indicatorlab_del_ind

A flag indicating whether a laboratory record has been logically removed from active use within the clinical data system. Used to filter out voided, cancelled, or inactivated lab records from reporting and clinical workflows without permanently purging the underlying data.

lab descriptionlab_desc

A textual explanation of a laboratory service or test, including its clinical purpose, methodology, or specimen requirements. Used in LIS, EHR, and claims systems to support test catalog management, provider ordering interfaces, patient-facing portals, and coding documentation workflows.

lab detaillab_dtl

Granular information associated with a specific laboratory service or test, such as methodology, specimen type, reference ranges, or result components. Captured in LIS and EHR systems to support clinical interpretation, quality control processes, and detailed reporting in downstream analytics environments.

lab discharge datelab_dsch_dt

Date on which a patient was discharged from a facility in the context of a laboratory service encounter, captured in EHR and claims data systems. Used to calculate length of stay, reconcile inpatient lab service timelines, and support revenue cycle and utilization management reporting workflows.

lab due datelab_due_dt

The expected date by which a laboratory result, specimen, or payment associated with a lab service must be completed or received. Used in lab workflow management to track turnaround time compliance, billing deadlines, and specimen collection scheduling requirements.

lab durationlab_dur

The total elapsed time associated with a laboratory test or procedure, from initiation to completion. Used in laboratory workflow analysis to measure test processing efficiency, monitor turnaround time benchmarks, and identify bottlenecks in clinical specimen handling and result reporting.

lab effective datelab_eff_dt

Date on which a laboratory service, test contract, or lab reference record becomes active and valid within EHR, LIS, or payer data systems. Used to enforce date-range filtering in eligibility checks, fee schedule lookups, and lab order processing to ensure only current lab configurations are applied.

lab emaillab_eml

Electronic mail address associated with a laboratory provider, facility, or contact record in provider directories, EHR systems, or payer data platforms. Used for result delivery coordination, provider outreach, and electronic communication routing between ordering physicians and reference laboratory systems.

lab emergency indicatorlab_emerg_ind

A flag designating a laboratory test or specimen as requiring urgent or STAT processing priority. Used in laboratory information systems to route critical specimens ahead of routine workload, ensuring timely results for emergency department patients or critical care clinical decisions.

lab end datelab_end_dt

Date marking the conclusion of a laboratory service period, test authorization, or lab record validity within EHR, LIS, or claims data systems. Used in conjunction with effective dates to define active service windows, supporting accurate lab claim adjudication and contract term management in payer platforms.

lab end timelab_end_tm

The timestamp recording when a laboratory test, procedure, or processing activity was completed. Used to calculate test turnaround time, measure laboratory operational performance, and support clinical workflows that depend on result availability for timely patient care decisions.

lab enrollment statuslab_enrl_sts

The current participation or certification status of a laboratory within a health plan network, accreditation program, or regulatory body. Used to determine whether a lab is eligible to receive referred specimens, process claims, or participate in contracted laboratory service agreements.

lab entered bylab_ent_by

The identifier of the user or system that manually entered or submitted a laboratory record, order, or result into the clinical information system. Used for data accountability, audit tracking, and identifying the source of data entry in laboratory workflow and quality control processes.

lab ethnicitylab_ethn

The self-reported or recorded ethnicity of the patient associated with a laboratory test. Used in population health analytics, clinical research, and public health reporting to identify health disparities, disease prevalence patterns, and demographic trends across laboratory result datasets.

lab expiration datelab_exp_dt

Date after which a laboratory service authorization, reagent lot, test panel configuration, or lab contract record is no longer considered valid in EHR, LIS, or payer systems. Used to enforce business rules preventing expired lab services from being ordered, billed, or reimbursed in downstream data workflows.

lab external identifierlab_ext_id

A unique identifier assigned to a laboratory record by an external system, reference lab, or trading partner. Used to correlate laboratory data across disparate systems, support interoperability with external reference laboratories, and reconcile results during health information exchange workflows.

lab faxlab_fax

The facsimile telephone number associated with a laboratory facility or contact. Used in clinical workflows to transmit laboratory orders, results, and reports to referring physicians, hospitals, or other healthcare entities when electronic data exchange methods are unavailable or not supported.

lab feelab_fee

The billed charge amount for a laboratory test or service rendered to a patient or payer. Used in healthcare billing and claims processing to represent the laboratory's standard or contracted fee before insurance adjustments, discounts, or patient cost-sharing amounts are applied.

lab first namelab_first_nm

The given or first name of the patient, clinician, or contact person associated with a laboratory record. Used in laboratory information systems to identify individuals linked to specimen collection, test ordering, or result delivery, supporting accurate patient matching and demographic verification.

lab flaglab_flg

Binary or categorical status marker applied to a laboratory service or test record in LIS, EHR, or claims data systems to indicate abnormal results, critical values, processing exceptions, or quality control alerts. Used by data pipelines to trigger downstream review workflows, notification routing, and result interpretation logic.

PreviousPage 357 of 806Next