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

Technology

Systems, databases, interfaces and data standards

428 technology terms

report parentrpt_prnt

The identifier or reference pointing to the superior report record in a hierarchical clinical summary structure within EHR or claims systems. Data engineers use this field to reconstruct parent-child report trees, apply cascading logic, and aggregate child-level data to summary-level reporting outputs.

report percentagerpt_pct

A calculated ratio value within a structured clinical summary representing metrics such as plan coverage utilization, claim approval rate, or quality measure attainment. Found in claims and PBM reporting systems, this field is used in KPI dashboards and requires precision-scale handling in data warehouse schemas.

report periodrpt_prd

The defined time span covered by a structured clinical summary, such as a calendar month, plan year, or rolling 12-month window in claims, EHR, or member enrollment systems. Data engineers use this field to partition report tables, enforce date boundary logic, and align reports to regulatory submission cycles.

report phonerpt_ph

The telephone number associated with a contact entity or reporting organization within a structured clinical summary in EHR or claims systems. Used for provider directory validation, member outreach reporting, and regulatory contact disclosure; requires standardized formatting and masking rules in data pipelines.

report preferred namerpt_pref_nm

The name by which an individual prefers to be identified within a clinical report, which may differ from their legal name. Supports patient-centered care, accurate communication, and respectful documentation practices across health information systems.

report pricerpt_prc

The charged or listed cost amount for a healthcare service, item, or procedure captured within a financial or clinical report. Used in revenue cycle, cost analysis, and claims reporting to evaluate service pricing against reimbursed or contracted rates.

report primary indicatorrpt_prim_ind

A flag designating whether a record within a clinical or administrative report is the primary entry among multiple related records, such as a primary diagnosis, primary payer, or primary contact, ensuring correct prioritization in downstream processing and reporting.

report priorityrpt_prty

An importance ranking assigned to a structured clinical summary in EHR, claims, or PBM systems indicating urgency of processing, distribution, or regulatory response. Data engineers use this field to implement priority queuing in report generation pipelines and ensure SLA compliance for high-priority health plan deliverables.

report pulserpt_pulse

The recorded heart rate, measured in beats per minute, captured as a vital sign within a clinical report. Used to assess cardiovascular status, monitor patient stability, and support clinical decision-making across inpatient, outpatient, and emergency care settings.

report quantityrpt_qty

The numeric count or volume value associated with a structured clinical summary in claims, pharmacy, or EHR reporting systems, such as the number of claims processed or members included. Used by data engineers to validate report completeness, drive threshold alerting, and support actuarial and utilization analysis outputs.

report racerpt_race

The self-reported or recorded racial classification of an individual within a clinical or population health report. Used to support health equity analysis, demographic reporting, regulatory compliance, and identification of disparities in healthcare access and outcomes.

report raterpt_rt

A unit price, reimbursement rate, or calculated per-unit value included within a structured clinical summary in claims or PBM systems. Data engineers use this field for cost analysis, fee schedule validation, and contractual compliance reporting, requiring decimal precision handling and currency normalization in data models.

report ratingrpt_rtg

A numeric or categorical score assigned to evaluate a clinical measure, provider performance, patient satisfaction, or care quality metric within a report. Used in quality management, accreditation, and health plan performance tracking systems to benchmark outcomes.

report ratiorpt_ratio

A calculated proportional relationship between two values captured within a clinical or operational report, such as a risk ratio or staffing ratio. Used in population health analysis, clinical quality measurement, and operational performance reporting to compare relative metrics.

report reasonrpt_rsn

Descriptive explanation text recorded within a structured clinical summary to document why the report was generated, modified, or flagged in EHR, claims, or PBM systems. Used by data engineers in audit trail construction, exception handling workflows, and regulatory submission documentation requiring reason code traceability.

report received daterpt_rcvd_dt

The date on which a clinical report, referral, lab result, or healthcare document was received by the processing entity. Used to track turnaround times, manage workflows, and ensure timely clinical follow-up and administrative processing within health information systems.

report referencerpt_ref

An external pointer or cross-system identifier linking a structured clinical summary to related records in EHR, claims, or enrollment platforms, such as an authorization number or encounter ID. Data engineers use this field as a foreign key for inter-system joins and to maintain referential integrity across healthcare data domains.

report resolution daterpt_resol_dt

The date on which a reported clinical condition, complaint, adverse event, or case was formally resolved or closed. Used in care management, adverse event tracking, and disease surveillance to document episode duration and support outcomes analysis.

report respirationrpt_resp

The recorded respiratory rate, measured in breaths per minute, captured as a vital sign within a clinical report. Used to monitor patient breathing status, assess severity of illness, and inform clinical interventions across inpatient, emergency, and outpatient care settings.

report revisionrpt_rev

A sequential version or iteration number assigned to a clinical report each time it is updated or amended. Supports document control, audit trail compliance, and change tracking within health information systems, ensuring users can distinguish current from prior report versions.

PreviousPage 11 of 22Next