mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator

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 engineers & architects.

Back to Glossary

Domain

Laboratory

Lab results, specimens, LOINC codes and pathology

810 laboratory terms

specimen levelspec_lvl

A coded or numeric value representing the hierarchical classification of a biological specimen within a testing taxonomy in LIS and EHR systems. Data engineers use this field to build specimen hierarchy models, support parent-child relationship navigation, and enable drill-down analytics in lab reporting platforms.

specimen modified datespec_mod_dt

The date on which a biological specimen record was last updated in LIS, EHR, or lab data warehouse systems. Data engineers use this field to drive incremental data loads, detect record changes in CDC pipelines, and maintain audit trails for specimen data governance and compliance reporting.

specimen namespec_nm

The standardized or display label assigned to a biological specimen type, such as whole blood or urine culture, in LIS and EHR systems. Data engineers use this field for specimen classification, mapping to standard terminologies like LOINC or SNOMED, and building user-facing lab analytics dashboards.

specimen notespec_nt

Free-text annotation associated with a biological specimen record, capturing collection observations, handling exceptions, or clinician comments in LIS and EHR systems. Data engineers use this field for NLP processing, quality flag derivation, and supplemental context in lab result and claims analytics pipelines.

specimen numberspec_nbr

A numeric reference assigned to a biological specimen for tracking and identification within LIS, EHR, and lab claims systems. Data engineers use this field as a secondary join key, deduplication anchor, and cross-system reconciliation identifier when integrating lab data across disparate source platforms.

specimen parentspec_prnt

The identifier or reference linking a derived or aliquot specimen to its originating parent specimen in LIS and EHR systems. Data engineers use this field to construct specimen lineage hierarchies, trace aliquot chains, and support parent-child relational models in lab data warehouse and analytics environments.

specimen percentagespec_pct

Represents a ratio or proportional value associated with a biological specimen in laboratory systems. Used in LIS and EHR platforms to express concentration, purity, or composition metrics such as percent saturation or cell differential percentages in diagnostic workflows.

specimen periodspec_prd

Defines the time span associated with biological specimen collection or validity in LIS and EHR systems. Captures intervals such as 24-hour urine collection windows or timed blood draws, critical for accurate lab result interpretation and downstream claims adjudication in PBM and payer platforms.

specimen phonespec_ph

Stores the telephone contact number associated with a biological specimen record, typically linked to the ordering provider, collecting facility, or patient in LIS and EHR systems. Used by data engineers to support result routing, specimen tracking inquiries, and audit trail compliance in laboratory workflows.

specimen priorityspec_prty

Indicates the urgency ranking assigned to a biological specimen in LIS and EHR systems, such as STAT, routine, or ASAP. Drives processing queues and turnaround time SLAs in laboratory workflows, and is critical for data engineers building real-time alerting pipelines and operational dashboards.

specimen quantityspec_qty

Records the measured volume, mass, or count of a biological specimen collected in LIS and EHR systems. Values may be expressed in mL, mg, or unit counts depending on specimen type. Critical for sufficiency validation logic, rejection workflows, and downstream lab result accuracy in clinical data pipelines.

specimen rangespec_rng

Captures the minimum and maximum acceptable value limits for a biological specimen measurement in LIS and EHR systems. Used to define reference intervals for lab results, supporting data engineers in building result flagging logic, outlier detection, and clinical decision support alert pipelines.

specimen ratespec_rt

Represents the unit price or reimbursement rate associated with processing a biological specimen in claims, LIS, and PBM systems. Used by data engineers in cost analysis, lab billing reconciliation, and fee schedule validation workflows across payer and provider data platforms.

specimen reasonspec_rsn

Captures the clinical justification or explanation for specimen collection in LIS and EHR systems, often aligned with ICD diagnosis codes or provider-documented indications. Used by data engineers to support medical necessity validation, prior authorization workflows, and claims audit processes in payer platforms.

specimen referencespec_ref

Stores an external identifier or pointer linking a biological specimen to related records across LIS, EHR, and claims systems, such as accession numbers, order IDs, or requisition references. Enables data engineers to perform cross-system joins, traceability mapping, and specimen lifecycle tracking in integration pipelines.

specimen resultspec_rslt

Contains the quantitative or qualitative outcome measurement produced from analyzing a biological specimen in LIS and EHR systems. Values may include numeric lab values, interpreted findings, or coded results mapped to LOINC or SNOMED. Central to clinical decision support, quality measure reporting, and claims adjudication pipelines.

specimen scorespec_scr

Represents a calculated or derived rating assigned to a biological specimen or its result in LIS and EHR systems, such as a pathology grading score or risk stratification index. Used by data engineers in analytics pipelines supporting quality metrics, population health programs, and clinical outcome reporting.

specimen sequencespec_seq

Defines the ordinal position of a biological specimen within a series of collections or processing steps in LIS and EHR systems. Critical for timed specimen protocols such as glucose tolerance tests, enabling data engineers to correctly order records in result aggregation and longitudinal lab data pipelines.

specimen service datespec_svc_dt

Records the date on which a biological specimen was collected or processed as a laboratory service in LIS, EHR, and claims systems. Used by data engineers to align lab events with encounter timelines, validate claims date fields, and support episode-of-care grouping in payer and provider analytics platforms.

specimen severityspec_sev

Indicates the clinical seriousness level associated with a biological specimen's findings or collection context in LIS and EHR systems, such as critical, abnormal, or normal severity designations. Used by data engineers to build result prioritization logic, critical value alerting workflows, and risk stratification models in clinical data platforms.

PreviousPage 40 of 41Next