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

523 technology terms

report allowed amountrpt_alwd_amt

The maximum dollar amount a payer will reimburse for services documented within a clinical or administrative report, based on contracted rates or fee schedules. Used in claims adjudication and financial reconciliation to determine reimbursable costs associated with reported healthcare services.

report amountrpt_amt

The monetary value captured within a structured reporting summary, representing financial figures such as paid amounts, billed charges, or allowed amounts sourced from claims, PBM, or EHR billing systems. Used by data engineers to validate financial aggregations and reconcile report-level totals against transactional source records.

report approval statusrpt_appr_sts

Categorical value indicating the current authorization state of a clinical or administrative report, such as pending review, approved, or rejected. Used in clinical documentation workflows to enforce sign-off requirements before a report is finalized, released, or included in official patient records.

report approved byrpt_appr_by

Identifier or name of the credentialed user, such as an attending physician or supervisor, who authorized and finalized a clinical or administrative report. Used in audit trails and compliance workflows to establish accountability for report sign-off within EHR and health information systems.

report arrival timerpt_arrv_tm

Timestamp recording the time at which a clinical report, specimen, referral document, or patient-related submission was received by the destination system or department. Used to measure turnaround times, workflow efficiency, and service level compliance in clinical and administrative operations.

report arrived daterpt_arrv_dt

Calendar date on which a clinical report, patient document, or diagnostic result was received by the intended department, facility, or information system. Used in operational reporting to track document receipt timelines, identify processing delays, and support compliance with turnaround standards.

report assessmentrpt_asmt

The clinician's interpretive evaluation text documented within a structured clinical report, capturing diagnostic impressions, findings analysis, and clinical conclusions drawn from examination data, test results, or patient-reported information to support care decisions.

report balancerpt_bal

The outstanding or remaining financial obligation recorded within a structured reporting summary, reflecting unpaid claim amounts, member cost-share balances, or accounts receivable figures derived from claims or EHR billing systems. Critical for financial reconciliation pipelines and accounts receivable aging reports in healthcare data platforms.

report billed amountrpt_bill_amt

The total dollar amount invoiced to a payer or patient for services associated with a clinical report, reflecting gross charges before contractual adjustments, denials, or payments are applied within billing and revenue cycle management workflows.

report birth daterpt_birth_dt

The member or patient date of birth captured within a structured reporting summary, sourced from member enrollment files, EHR demographic records, or claims eligibility data. Used by data engineers to validate age-based eligibility rules, apply age band segmentation, and reconcile demographic consistency across reporting datasets.

report blood pressurerpt_bp

The systolic and diastolic arterial pressure reading documented within a clinical report, recorded in mmHg format as a vital sign measurement captured during a patient encounter to support cardiovascular assessment and chronic disease monitoring.

report cancelled daterpt_cncl_dt

The calendar date on which a clinical report was voided or withdrawn from active status, used to maintain an accurate audit trail of report lifecycle events and support reconciliation of incomplete or erroneous documentation in clinical systems.

report categoryrpt_cat

The high-level grouping classification assigned to a structured reporting summary, used to segment report outputs by clinical program, financial domain, or operational area within EHR, claims, or PBM platforms. Enables data engineers to partition report datasets and apply category-specific transformation logic in ETL pipelines.

report charge amountrpt_chrg_amt

The gross service charge assigned to a clinical report before payer adjudication or contractual adjustments, representing the standard fee for the documented service as recorded in the revenue cycle or hospital billing system at time of service.

report chief complaintrpt_cc

The primary symptom, condition, or reason for visit documented by the clinician at the start of a clinical report, reflecting the patient's own description of their presenting concern and serving as the foundational context for the clinical encounter narrative.

report childrpt_chld

The subordinate entity or record within a hierarchical reporting structure, representing a dependent element linked to a parent report record in healthcare data systems such as claims detail lines, member sub-groups, or encounter sub-records. Used by data engineers to model parent-child relationships in reporting schemas and summary rollups.

report cityrpt_city

The city name associated with the location referenced in a clinical report, such as the facility, patient address, or service delivery site, used to support geographic analysis, care coordination, and population health reporting across regional health systems.

report classrpt_cls

The classification tier assigned to a structured reporting summary that categorizes reports by type, regulatory purpose, or functional domain within EHR, claims adjudication, or PBM systems. Used by data engineers to apply class-specific business rules, access controls, and routing logic within healthcare data pipelines and reporting frameworks.

report coderpt_cd

The standardized classification code value associated with a structured reporting summary, referencing code sets such as ICD, CPT, HCPCS, or internal system identifiers within claims, EHR, or PBM platforms. Used by data engineers to join report records to reference tables and validate code conformance during data quality checks.

report commentrpt_cmt

The free-text notation or annotation field captured within a structured reporting summary, containing adjudicator remarks, clinical notes, or operational flags entered in claims, EHR, or PBM systems. Data engineers must handle this field as unstructured text requiring parsing, masking for PHI, or exclusion from standard aggregation logic.

PreviousPage 11 of 27Next