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

panel datepnl_dt

The calendar date associated with a diagnostic test panel event or care management panel assignment in EHR and LIS systems. Data engineers use this field to anchor panel records to temporal reporting windows, enabling trend analysis and time-series aggregation across clinical datasets.

panel datetimepnl_dttm

The combined date and time value capturing when a diagnostic test panel was ordered, collected, or resulted in EHR and LIS systems. Data engineers rely on this timestamp for precise event sequencing, SLA measurement, and joining panel records across clinical and claims data sources.

panel dea numberpnl_dea_nbr

Stores the Drug Enforcement Administration registration number associated with a prescribing clinician linked to a diagnostic or medication panel order. Required in controlled substance ordering workflows to verify prescriber DEA authorization, ensure regulatory compliance, and maintain auditable records for controlled substance oversight.

panel death datepnl_death_dt

The recorded date of patient death associated with a care management panel or population health panel in EHR and population health platforms. Data engineers use this field to close active panel assignments, exclude deceased members from outreach workflows, and support mortality analytics.

panel deductible amountpnl_ded_amt

Captures the portion of a diagnostic test panel's cost applied toward a patient's annual insurance deductible before plan benefits take effect. Used in healthcare billing and revenue cycle systems to calculate patient financial responsibility, generate accurate patient statements, and reconcile payer adjudication details on explanation of benefits documents.

panel deleted datepnl_del_dt

The date on which a laboratory or diagnostic test panel was marked as deleted within the clinical information system. Supports audit trails and data governance by preserving when ordered test groupings were removed, enabling reconciliation of panel ordering history.

panel deleted indicatorpnl_del_ind

A flag indicating whether a laboratory or diagnostic test panel has been deleted from the clinical system. Enables filtering of active versus removed panel orders, supporting accurate reporting of current test requisitions and preventing processing of cancelled panel workflows.

panel descriptionpnl_desc

The human-readable textual label or explanation defining the clinical purpose or composition of a diagnostic test panel or care management panel in EHR, LIS, and population health systems. Used by data engineers to map panel codes to standardized terminology and support display logic.

panel detailpnl_dtl

Granular-level information describing the individual components, results, or attributes of a diagnostic test panel or care management panel in EHR and LIS systems. Data engineers parse panel detail records to normalize component-level data for downstream clinical analytics and reporting pipelines.

panel due datepnl_due_dt

The date by which a laboratory or diagnostic test panel is expected to be completed or resulted. Used in clinical workflow management to track overdue panels, prioritize specimen processing, and ensure timely delivery of grouped test results to ordering clinicians.

panel durationpnl_dur

The total elapsed time between the initiation and completion of a laboratory or diagnostic test panel. Used in clinical operations to measure turnaround performance, identify bottlenecks in specimen processing, and benchmark efficiency across laboratory testing workflows.

panel effective datepnl_eff_dt

The date on which a diagnostic test panel definition or care management panel assignment becomes active in EHR, LIS, or population health systems. Data engineers use this field to apply correct panel logic within date-ranged queries and to manage slowly changing dimension records in data warehouses.

panel emailpnl_eml

The electronic mail address associated with a provider, care team member, or contact linked to a care management panel in EHR or population health platforms. Data engineers use this field to support outreach automation, notification routing, and provider directory reconciliation across integrated systems.

panel emergency indicatorpnl_emerg_ind

A flag designating that a laboratory or diagnostic test panel has been ordered on an urgent or STAT basis requiring expedited processing. Triggers priority handling in laboratory information systems to ensure critical grouped test results are resulted and reported without standard processing delays.

panel end datepnl_end_dt

The date marking the conclusion or deactivation of a diagnostic test panel order or care management panel assignment in EHR and population health systems. Data engineers use this field to define active membership windows, filter historical records, and support time-bounded cohort analysis.

panel end timepnl_end_tm

The timestamp recording when all tests within a laboratory or diagnostic panel were completed and results finalized. Used in laboratory turnaround time calculations, workflow analysis, and reporting to measure the full duration from panel initiation to result availability.

panel entered bypnl_ent_by

The identifier of the clinician, technician, or staff member who entered the laboratory or diagnostic test panel order into the clinical information system. Supports accountability tracking, order verification workflows, and audit reporting for panel requisition data entry.

panel ethnicitypnl_ethn

The self-reported or administratively assigned ethnicity of the patient associated with a laboratory or diagnostic test panel. Used in population health analytics, health equity reporting, and clinical research to identify disparities in testing patterns and outcomes across ethnic groups.

panel expiration datepnl_exp_dt

The date after which a diagnostic test panel definition, standing order, or care management panel assignment is no longer valid in EHR, LIS, or population health systems. Data engineers use this field to enforce validity filters, purge stale records, and manage panel lifecycle in data pipelines.

panel external identifierpnl_ext_id

A unique identifier assigned to a laboratory or diagnostic test panel by an external system, such as a reference laboratory, health information exchange, or interfacing EHR. Enables cross-system tracking, result reconciliation, and interoperability for panel orders processed outside the primary clinical system.

PreviousPage 28 of 46Next