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 arrived daterslt_arrv_dt

The calendar date on which a clinical specimen, diagnostic result, or associated result data was received at the processing laboratory or clinical facility. Used alongside arrival time to establish chain of custody, calculate processing turnaround, and support regulatory compliance in laboratory information systems.

result assessmentrslt_asmt

The clinician's interpretive evaluation or narrative commentary associated with a diagnostic test outcome, summarizing clinical significance, abnormalities, or recommended follow-up. Captured in laboratory and clinical data systems to provide context beyond raw numeric values and support downstream clinical decision-making.

result balancerslt_bal

The remaining financial obligation associated with a clinical test or procedure result after payments and adjustments in claims and revenue cycle systems. Data engineers use this field to track outstanding receivables, reconcile remittance data, and support accounts receivable aging reports in healthcare finance pipelines.

result billed amountrslt_bill_amt

The total dollar amount invoiced to a payer or patient for services associated with a diagnostic test or clinical result. Represents the gross charge before contractual adjustments, discounts, or payer negotiations, and is used in revenue cycle management and financial reporting for laboratory and clinical services.

result birth daterslt_birth_dt

The patient date of birth recorded in association with a clinical test or procedure result in EHR and lab systems. Data engineers use this field for patient identity matching, age-based result interpretation, and deduplication logic when integrating result records across disparate source systems.

result blood pressurerslt_bp

The recorded systolic and diastolic arterial pressure measurement captured as a clinical result, typically expressed in mmHg. Stored in clinical data systems as a vital sign observation linked to a patient encounter, this value supports cardiovascular risk assessment, chronic disease management, and longitudinal health monitoring.

result cancelled daterslt_cncl_dt

The calendar date on which a pending or ordered diagnostic test result was formally cancelled, either by the ordering clinician, laboratory staff, or administrative personnel. Used in laboratory information systems to track order lifecycle management, support audit reporting, and reconcile unfulfilled test orders in billing workflows.

result categoryrslt_cat

A classification code or label grouping clinical test or procedure results by type, such as laboratory, radiology, or pathology, in EHR and lab information systems. Data engineers use this field to route results to appropriate downstream consumers, apply domain-specific processing logic, and support result-type analytics.

result charge amountrslt_chrg_amt

The gross service charge applied to a diagnostic test or clinical result before any payer adjustments, contractual allowances, or patient cost-sharing calculations. Used in healthcare revenue cycle systems to initiate the billing process and establish the basis for downstream adjudication and financial reconciliation of result-related services.

result chief complaintrslt_cc

The primary symptom or clinical concern reported by the patient or documented by the clinician that prompted the diagnostic test or clinical evaluation associated with this result. Captured in clinical data systems to provide encounter context and support diagnostic reasoning, coding accuracy, and outcomes analysis.

result childrslt_chld

A subordinate result record linked to a parent result in hierarchical clinical data structures within EHR and lab systems. Data engineers use this field to model panel-level test relationships, traverse parent-child result trees during ETL processing, and ensure complete result set extraction in analytics pipelines.

result cityrslt_city

The municipality name associated with the location where a clinical result was collected, processed, or reported, such as a laboratory site, clinic, or patient address. Used in clinical data systems for geographic analysis, facility identification, public health surveillance, and routing of result notifications to appropriate care settings.

result classrslt_cls

The classification tier assigned to a test or procedure outcome in EHR and laboratory systems. Used by data engineers to categorize results (e.g., normal, abnormal, critical) for downstream analytics, alerting workflows, and clinical decision support pipelines.

result coderslt_cd

The standardized code value representing a test or procedure outcome in LIS, EHR, and claims systems. Data engineers use this field to normalize results across LOINC, SNOMED, or proprietary coding systems for cross-platform reporting and interoperability.

result coinsurance amountrslt_coins_amt

The dollar amount representing the patient's proportional share of costs for a diagnostic test or clinical result service, calculated as a percentage of the allowed amount after the deductible is met. Used in claims adjudication and patient billing systems to determine patient financial responsibility for result-related services.

result commentrslt_cmt

The free-text notation appended to a test or procedure outcome in LIS and EHR systems. Data engineers must handle this unstructured field carefully in ETL pipelines, as it may contain clinically significant annotations requiring NLP processing or manual review workflows.

result completed daterslt_cmpl_dt

The calendar date on which a diagnostic test, laboratory analysis, or clinical procedure associated with a result was fully performed and finalized. Used in laboratory information systems and clinical data warehouses to measure turnaround times, ensure timely reporting, and support service level compliance for result delivery workflows.

result confidential indicatorrslt_conf_ind

A flag designating that a clinical test result contains sensitive information requiring restricted access, such as results related to behavioral health, substance use, HIV status, or genetic testing. Governs data visibility rules in clinical systems to ensure compliance with federal and state privacy regulations including 42 CFR Part 2 and HIPAA.

result contactrslt_cntct

The designated communication point associated with a test or procedure outcome in EHR and laboratory systems. Data engineers use this field to route critical result notifications to ordering providers, supporting automated alerting and care coordination workflows.

result copay amountrslt_cpay_amt

The fixed out-of-pocket dollar amount the patient is required to pay at the time of service for a diagnostic test or clinical result, as defined by their health plan benefit structure. Used in claims adjudication and patient billing workflows to calculate patient financial liability separate from coinsurance and deductible obligations.

PreviousPage 575 of 806Next