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

810 laboratory terms

panel modified datepnl_mod_dt

The timestamp recording the most recent update made to a diagnostic test panel or care management panel record in EHR, LIS, or population health systems. Data engineers use this field to implement incremental load strategies, detect record changes during CDC processing, and audit data modification history.

panel modified timepnl_mod_tm

The timestamp recording when a clinical test panel record was last updated. Stored in laboratory information systems and clinical data warehouses to support audit trails, change tracking, data synchronization across integrated systems, and regulatory compliance documentation.

panel namepnl_nm

The human-readable display label assigned to a group of clinically related diagnostic tests in LIS, EHR, and order entry systems. Used by data engineers to map panel identifiers across lab result datasets, claims adjudication, and CPT grouping logic.

panel notepnl_nt

Free-text annotation attached to a diagnostic test panel record in LIS or EHR systems, capturing clinical instructions, specimen handling requirements, or result interpretation guidance. Data engineers use this field to parse supplemental context during lab result ingestion and HL7 message processing.

panel numberpnl_nbr

The unique numeric identifier assigned to a group of related diagnostic tests within LIS, EHR order management, or claims systems. Used by data engineers to join panel records across lab result tables, CPT code mappings, and insurance reimbursement datasets for accurate billing reconciliation.

panel onset datepnl_onset_dt

The date on which the patient's symptoms or clinical condition prompting a diagnostic test panel first began. Used in clinical documentation and laboratory systems to establish clinical context, support diagnosis coding accuracy, and inform result interpretation relative to disease progression.

panel oxygen saturationpnl_o2sat

The measured peripheral blood oxygen saturation level recorded as part of a clinical test panel, typically expressed as a percentage. Used in vital signs panels and respiratory assessments within EHR and clinical monitoring systems to evaluate patient oxygenation status and guide care decisions.

panel paid amountpnl_pd_amt

The dollar amount reimbursed or paid by a payer for a clinical test panel claim. Used in healthcare billing and claims adjudication systems to reconcile laboratory service payments against submitted charges, supporting revenue cycle management and financial reporting.

panel paid datepnl_pd_dt

The date on which payment was issued by a payer for a clinical test panel claim. Used in claims and revenue cycle systems to track reimbursement timelines, reconcile remittance advice, and monitor payer performance against contractual payment obligations for laboratory services.

panel parentpnl_prnt

The hierarchical superior panel record to which a sub-panel or individual test component belongs in LIS and EHR order catalog structures. Data engineers use this relationship field to build test hierarchy trees, support rollup aggregations, and resolve nested panel dependencies in laboratory data pipelines.

panel percentagepnl_pct

A ratio value representing a proportional metric associated with a diagnostic test panel, such as percent positivity, reimbursement rate, or result completion rate. Used by data engineers in LIS and claims analytics to calculate panel-level performance benchmarks and quality reporting metrics.

panel periodpnl_prd

The defined time span during which a diagnostic test panel is active, reportable, or covered under a payer contract in EHR, LIS, or claims systems. Data engineers use this field to apply date-range filters, manage panel lifecycle versioning, and align lab result records with corresponding benefit periods.

panel phonepnl_ph

The telephone contact number associated with a diagnostic test panel's ordering facility, reference laboratory, or result reporting department in LIS and EHR provider directory datasets. Data engineers use this field to link panel records to facility master data and support provider outreach workflows.

panel planpnl_pln

The documented clinical treatment or follow-up strategy associated with findings from a test panel. Recorded in EHR clinical notes and care management systems to communicate the ordering clinician's intended next steps based on panel results, supporting continuity and coordination of patient care.

panel policy numberpnl_pol_nbr

The insurance policy identifier linked to the patient's coverage at the time a clinical test panel was ordered. Used in laboratory billing and claims systems to route panel charges to the correct payer, verify eligibility, and ensure accurate adjudication of diagnostic service claims.

panel preferred namepnl_pref_nm

The chosen display name or alias preferred by the patient associated with a clinical test panel. Used in laboratory and patient-facing systems to ensure communications, result reports, and clinical documentation reflect the patient's preferred identity, supporting respectful and person-centered care.

panel pricepnl_prc

The total billed or contracted cost assigned to a diagnostic test panel, representing the bundled charge for all component tests ordered together. Used in laboratory billing systems to apply a single price to grouped tests such as metabolic panels or lipid profiles.

panel primary indicatorpnl_prim_ind

A flag identifying whether a diagnostic test panel is designated as the primary panel within a patient encounter or order set. Used in laboratory information systems to distinguish the principal panel when multiple panels are ordered, supporting accurate billing and result prioritization.

panel prioritypnl_prty

A coded ranking value indicating the clinical urgency or processing order of a diagnostic test panel in LIS and EHR order management systems, such as STAT, routine, or urgent. Data engineers use this field to drive result routing logic, SLA monitoring, and turnaround time analytics in lab data pipelines.

panel pulsepnl_pulse

The patient heart rate measurement recorded as part of a clinical panel in a patient encounter. Captured in beats per minute, this vital sign is stored alongside other panel components in EHR systems to provide a complete physiological snapshot at the time of assessment.

PreviousPage 28 of 41Next