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

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

3,545 claims terms

review expiration datervw_exp_dt

Validity end date indicating when an evaluation assessment or its associated authorization determination is no longer active in payer or utilization management systems. Used by data engineers to expire prior authorization records, suppress stale review data, and enforce date-bound business rules in claims adjudication pipelines.

review external identifierrvw_ext_id

A reference identifier assigned by an external system, such as a trading partner, payer, or referring organization, to uniquely identify a clinical or utilization review. Used to reconcile and cross-reference review records across multiple healthcare platforms or interoperability exchanges.

review faxrvw_fax

The facsimile number associated with a party involved in a clinical or utilization review, such as a requesting clinician or facility. Used to route clinical documentation, prior authorization decisions, or review correspondence to the appropriate contact during the review process.

review feervw_fee

The charge or cost associated with conducting a clinical or utilization review, such as an independent medical review or peer review service. Used in financial tracking and vendor billing to account for review-related expenses within care management or quality management operations.

review first namervw_first_nm

The given name of the individual associated with a clinical or utilization review, typically the member or patient under review. Used to display identifying information in care management systems and to match review records to the correct individual across healthcare data systems.

review flagrvw_flg

Binary status marker applied to an evaluation assessment in utilization management, claims review, or care management systems to indicate a specific condition such as escalation, exception, or override. Used in payer and EHR platforms to trigger conditional processing logic and filter records in downstream data pipelines.

review frequencyrvw_freq

The scheduled interval at which a clinical or utilization review must recur, such as every 30, 60, or 90 days. Used in care management and chronic condition programs to define how often ongoing reviews, reassessments, or authorization renewals are required for a member's care plan.

review full namervw_full_nm

The complete name of the individual associated with a clinical or utilization review, combining first, middle, and last name fields. Used for display and identification purposes in care management systems to clearly identify the member or patient subject to the review.

review genderrvw_gndr

The gender of the member or patient associated with a clinical or utilization review. Captured to support clinically appropriate review criteria application, health equity reporting, and compliance with demographic data collection requirements in care management and utilization management programs.

review glucoservw_gluc

The blood glucose measurement recorded as part of a clinical review or health assessment for a member or patient. Used in disease management programs, particularly for diabetes monitoring, to evaluate metabolic control and inform care planning decisions within care management workflows.

review group numberrvw_grp_nbr

The insurance group number associated with the member's health plan coverage at the time of a clinical or utilization review. Used to link review records to the correct benefit plan, determine applicable coverage criteria, and support claims adjudication and reporting.

review hemoglobinrvw_hgb

The hemoglobin measurement, often HbA1c, recorded during a clinical review or health assessment for a member or patient. Used in chronic disease management programs, particularly for diabetes monitoring, to assess long-term glycemic control and guide care management interventions.

review identifierrvw_id

Unique alphanumeric key assigned to an evaluation assessment record in utilization management, prior authorization, or care management systems. Used as the primary or foreign key in payer and EHR data models to join review records across claims, member, provider, and authorization tables in ETL and analytics pipelines.

review indexrvw_idx

Positional number representing the sequence or order of an evaluation assessment within a series of related reviews in utilization management or care management systems. Used in payer and EHR platforms to order multiple review records for a single episode of care and support chronological analysis in data pipelines.

review indicatorrvw_ind

Boolean or coded value denoting the presence, absence, or status of a specific condition within an evaluation assessment in utilization management or claims review systems. Used in payer and EHR platforms to drive conditional logic in adjudication engines, compliance checks, and population health analytics pipelines.

review instructionrvw_instr

Guidance text associated with an evaluation assessment in utilization management, prior authorization, or care management systems, directing reviewers on required clinical criteria or process steps. Used in payer and EHR platforms to standardize review workflows and is parsed by data engineers for operational reporting and audit compliance.

review keyrvw_key

The unique primary key or surrogate identifier assigned to a clinical or utilization review record within the healthcare data system. Used to uniquely identify, index, and retrieve specific review records for case management, reporting, and integration with downstream clinical or administrative systems.

review languagervw_lang

The preferred spoken or written language of the member or patient associated with a clinical or utilization review. Used in care management systems to ensure review communications, notices, and clinical documentation are delivered in the individual's preferred language per regulatory requirements.

review last namervw_last_nm

The surname of the individual associated with a clinical or utilization review, typically the member or patient under review. Used to display identifying information in care management systems and to accurately match review records to the correct individual across healthcare data systems.

review legal namervw_legal_nm

The official legally registered name of the member or patient associated with a clinical or utilization review. Used to ensure accurate identity verification in care management systems, support compliance with legal documentation requirements, and match records across enrollment and clinical data sources.

PreviousPage 141 of 178Next