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

Laboratory

Lab results, specimens, LOINC codes and pathology

901 laboratory terms

microbiology zipmicro_zip

The postal code associated with the facility, collection site, or patient location linked to a microbiology specimen or test order. Used in public health and epidemiological reporting to geographically map infection clusters, track outbreak patterns, and support regional antimicrobial resistance surveillance.

minimum inhibitory concentrationmic

The lowest concentration of an antimicrobial agent that inhibits visible growth of a microorganism after overnight incubation, expressed in mcg/mL, used to characterize the degree of antimicrobial susceptibility and guide dose optimization in serious infections. MIC values are compared against CLSI or EUCAST breakpoints to determine susceptible, intermediate, or resistant categorization.

order to collection time minutesord_to_coll_min

The elapsed time in minutes between when a laboratory order was placed and when the specimen was collected from the patient, a laboratory operations metric used to monitor phlebotomy response time, identify delays in specimen collection workflows, and measure compliance with stat order turnaround time standards requiring collection within defined intervals of order placement for time-sensitive tests.

oxygen saturationspo2

A measurement of the percentage of hemoglobin saturated with oxygen, measured non-invasively by pulse oximetry or from blood gas analysis. SpO2 below 94% indicates hypoxemia requiring clinical assessment and below 90% typically triggers supplemental oxygen therapy. Resting SpO2 measurements are quality metrics in post-discharge care protocols for pneumonia and heart failure readmission prevention programs.

panel active indicatorpnl_actv_ind

A flag denoting whether a laboratory test panel, such as a comprehensive metabolic panel or respiratory pathogen panel, is currently available for ordering within a clinical or laboratory information system. Inactive panels are typically retired or replaced by updated test groupings.

panel active statuspnl_actv_sts

The current operational state of a laboratory test panel within a clinical or laboratory information system, indicating whether the panel is available, suspended, or retired. Used by lab administrators to control test ordering workflows and ensure clinicians access only currently validated panel configurations.

panel addresspnl_addr

The physical location identifier associated with a laboratory or diagnostic test panel in EHR and LIS systems, used to route specimen collection, link results to performing facilities, and support geographic analytics in claims and clinical data warehouse environments across multi-site healthcare organizations.

panel adjustment amountpnl_adj_amt

The dollar amount applied to modify the original billed or allowed charge for a laboratory test panel on a claim or remittance. Adjustments may reflect contractual discounts, coordination of benefits reductions, or payer-specific fee schedule differences applied during claims adjudication.

panel agepnl_age

The age of the patient at the time a laboratory test panel was ordered or resulted, used to apply age-specific reference ranges, clinical decision rules, or payer coverage criteria. Accurate age capture ensures appropriate interpretation of panel results across pediatric, adult, and geriatric populations.

panel allowed amountpnl_alwd_amt

The maximum dollar amount a payer will reimburse for a laboratory test panel under a contracted fee schedule or benefit plan. Used in claims adjudication to establish the payment ceiling before applying deductibles, copays, or coinsurance, directly impacting member cost-sharing and provider reimbursement.

panel amountpnl_amt

The total monetary value assigned to a grouped set of laboratory or diagnostic tests ordered and billed as a single panel unit in EHR, LIS, and claims systems. Used in charge capture, fee schedule validation, and revenue cycle reporting to reconcile panel-level reimbursement against individual component CPT code pricing.

panel approval statuspnl_appr_sts

The authorization or prior approval state of a laboratory test panel order, indicating whether the panel has been approved, pended, or denied by a payer or utilization management process. Used in revenue cycle and clinical workflows to prevent claim denials and ensure medically necessary testing proceeds without delay.

panel approved bypnl_appr_by

Identifies the credentialed user, typically a physician or authorized clinician, who approved a diagnostic test panel in the laboratory or clinical ordering system. Captured in EHR audit trails to ensure accountability and compliance with clinical authorization protocols.

panel arrival timepnl_arrv_tm

Records the exact time a patient physically arrived for a scheduled diagnostic test panel encounter. Used in laboratory and clinical workflow systems to measure patient throughput, calculate wait times, and monitor service delivery performance against operational benchmarks.

panel arrived datepnl_arrv_dt

Records the calendar date a patient arrived for a scheduled diagnostic test panel encounter. Used in laboratory information systems and clinical scheduling workflows to track patient flow, confirm appointment adherence, and support operational reporting on panel utilization.

panel assessmentpnl_asmt

Contains the clinician's narrative clinical evaluation or interpretive findings associated with a diagnostic test panel. Captured in EHR clinical documentation to summarize the provider's conclusions drawn from panel results, supporting care planning and downstream clinical decision-making.

panel balancepnl_bal

The remaining unpaid monetary amount associated with a laboratory or diagnostic panel after partial payments, adjustments, or insurance remittances have been applied. Tracked in revenue cycle management and claims adjudication systems to support accounts receivable reporting and patient billing workflows in healthcare data environments.

panel billed amountpnl_bill_amt

Represents the total dollar amount submitted to a payer or patient for a diagnostic test panel on a healthcare claim. Used in revenue cycle management systems to track gross charges billed, reconcile remittance advice, and support accounts receivable reporting for laboratory services.

panel birth datepnl_birth_dt

The date of birth associated with a patient record linked to a laboratory or diagnostic test panel in EHR and LIS systems, used for age-based clinical decision support, eligibility verification, and demographic validation during panel order creation and claims submission in healthcare data pipelines.

panel blood pressurepnl_bp

Records the systolic and diastolic arterial pressure measurement captured as part of a diagnostic test panel or clinical encounter. Stored in EHR vital signs modules and clinical data warehouses to support patient monitoring, chronic disease management, and longitudinal cardiovascular risk tracking.

PreviousPage 26 of 46Next