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

result noterslt_nt

Free-text annotation appended to a diagnostic test or procedure outcome in EHR and LIS systems. May contain pathologist comments, technical qualifications, or interpretive remarks. Data engineers process rslt_nt fields for NLP pipelines, ensuring unstructured clinical commentary is captured alongside structured result values.

result numberrslt_nbr

Numeric reference identifier assigned to a specific test or procedure outcome record in LIS, EHR, and claims systems. Used to uniquely track individual results within an order or encounter. Data engineers use rslt_nbr as a join key when linking result records across laboratory, clinical, and billing data sources.

result onset daterslt_onset_dt

Date on which the patient's symptoms or condition related to a diagnostic test result first began, providing clinical context for interpreting the result's significance, supporting differential diagnosis, and documenting disease progression in EHR and clinical data systems.

result oxygen saturationrslt_o2sat

Measured peripheral blood oxygen saturation percentage recorded as a diagnostic or vital sign result, typically captured via pulse oximetry during clinical encounters, used to assess respiratory status and monitor patient oxygenation in EHR and clinical data systems.

result paid amountrslt_pd_amt

Monetary amount paid by a payer or patient toward the claim or service associated with a diagnostic test result, used to reconcile reimbursements, track cost attribution, and support financial reporting in healthcare billing and revenue cycle management systems.

result paid daterslt_pd_dt

Date on which payment was received or posted for the claim or service associated with a diagnostic test result, used to track reimbursement timelines, reconcile accounts receivable, and support financial auditing in healthcare billing and revenue cycle systems.

result parentrslt_prnt

Identifier referencing the superior panel or order to which a discrete test result belongs within EHR and LIS hierarchical data models. Establishes parent-child relationships in result trees. Data engineers use rslt_prnt to reconstruct panel groupings and maintain referential integrity in clinical data warehouse schemas.

result percentagerslt_pct

Ratio-based numeric value expressing a diagnostic test or procedure outcome as a proportion in EHR, LIS, and clinical analytics systems. Common in hematology differentials, pathology grading, and pulmonary function tests. Data engineers use rslt_pct to normalize proportional results for population health and quality measure calculations.

result periodrslt_prd

Time span or duration associated with a diagnostic test or procedure outcome, such as a 24-hour urine collection window or monitoring interval, stored in EHR and LIS systems. Data engineers use rslt_prd to contextualize time-dependent results and align them correctly within longitudinal patient data models.

result phonerslt_ph

Telephone contact number associated with the laboratory, department, or provider responsible for a test or procedure outcome in EHR and LIS systems. Used for critical value notifications and result inquiries. Data engineers map rslt_ph to facility or provider reference tables during data integration and master data management processes.

result planrslt_pln

The documented treatment or follow-up strategy associated with a specific clinical test outcome. Captures clinician-directed next steps in response to lab, imaging, or diagnostic results, supporting care coordination and clinical decision-making within EHR and care management systems.

result policy numberrslt_pol_nbr

The insurance policy identifier linked to a specific clinical result record, used to associate diagnostic or lab findings with the correct member coverage for claims adjudication, prior authorization tracking, and payer reporting across health plan and clinical data systems.

result preferred namerslt_pref_nm

The standardized or clinician-designated display label for a specific test or diagnostic result, used to present findings in a consistent, human-readable format across clinical interfaces, patient portals, and reporting tools within EHR and health information systems.

result pricerslt_prc

The monetary cost associated with a specific diagnostic test, lab procedure, or clinical result event. Used in revenue cycle management, claims billing, and cost analysis workflows to track charges generated from result-producing services within healthcare financial and clinical systems.

result primary indicatorrslt_prim_ind

A flag identifying whether a specific result record is the primary or principal finding among multiple results for the same encounter, order, or condition. Supports result prioritization, clinical summarization, and reporting logic in lab, imaging, and diagnostic data workflows.

result priorityrslt_prty

Importance or urgency ranking assigned to a test or procedure outcome in EHR, LIS, and order management systems, distinguishing routine, stat, or critical result statuses. Data engineers use rslt_prty to drive alerting logic, SLA monitoring, and prioritized data routing in clinical integration and notification pipelines.

result procedure daterslt_proc_dt

The calendar date on which the clinical procedure that generated a specific result was performed. Used to establish the temporal relationship between service delivery and outcome reporting, supporting claims processing, longitudinal care tracking, and quality measurement workflows.

result pulserslt_pulse

The recorded heart rate measurement, in beats per minute, captured as part of a clinical result or vital signs assessment. Used in patient monitoring, chronic disease management, and clinical documentation workflows to track cardiovascular health status over time within EHR systems.

result quantityrslt_qty

Numeric count or measured volume associated with a diagnostic test or procedure outcome in EHR and LIS systems, such as colony counts or specimen volume. Data engineers use rslt_qty alongside unit-of-measure fields to ensure dimensional accuracy during result normalization and FHIR Observation resource mapping.

result racerslt_race

The patient-reported or administratively assigned racial identity associated with a specific clinical result record. Used in population health analytics, health equity reporting, and epidemiological research to identify disparities in diagnostic outcomes and clinical service utilization across member groups.

PreviousPage 579 of 806Next