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

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

wing policy numberwng_pol_nbr

The insurance policy number associated with a specific wing or section of a healthcare facility, used in billing and claims processing to attribute services rendered in that physical unit to the correct coverage agreement and payer contract.

workflow coinsurance amountwf_coins_amt

The dollar amount representing the member's coinsurance obligation within a specific claims processing or administrative workflow stage. Captures the patient cost-sharing portion after deductibles are met, used in revenue cycle management and remittance reconciliation.

workflow enrollment statuswf_enrl_sts

Indicates the current enrollment state of a member or case within a defined administrative or clinical workflow, such as active, pending, or terminated. Used in health plan operations to manage eligibility verification, authorization queues, and care management program tracking.

workflow planwf_pln

Identifies the health insurance or benefit plan associated with a specific administrative or clinical workflow instance. Used in claims processing and care management systems to route transactions, apply correct benefit rules, and ensure proper adjudication based on plan configuration.

workflow policy numberwf_pol_nbr

The unique insurance policy identifier linked to a specific administrative or clinical workflow instance. Used in claims and health plan systems to associate workflow transactions with the correct member coverage, enabling accurate benefit application and audit trail maintenance.

write off coinsurance amountwo_coins_amt

The coinsurance dollar amount that has been deemed uncollectible and written off from accounts receivable in the revenue cycle. Represents the patient cost-sharing balance a provider has forgiven, adjusted, or classified as bad debt after collection efforts have been exhausted.

write off enrollment statuswo_enrl_sts

The enrollment or membership status of a member at the time a balance was written off as uncollectible. Used in revenue cycle analytics to correlate write-off activity with coverage lapses, terminations, or eligibility gaps that contributed to the uncollected balance.

write off planwo_pln

The health insurance or benefit plan associated with a written-off balance in accounts receivable. Used in revenue cycle reporting to identify which plans contribute to write-off volumes, supporting payer contract negotiations and financial performance analysis.

write off policy numberwo_pol_nbr

The insurance policy number associated with a balance written off as uncollectible in the revenue cycle. Used to link write-off transactions back to the member's coverage record, supporting audit trails, bad debt reporting, and payer-level financial reconciliation.

xray coinsurance amountxr_coins_amt

The member's coinsurance cost-sharing amount applied to diagnostic X-ray imaging services after the deductible is met. Captured during claims adjudication to determine patient financial responsibility for radiology services billed under applicable imaging benefit categories.

xray enrollment statusxr_enrl_sts

The member's enrollment or eligibility status at the time X-ray imaging services were rendered. Used in claims adjudication and eligibility verification to confirm active coverage for diagnostic radiology benefits and ensure proper processing of imaging-related claims.

xray planxr_pln

The health insurance or benefit plan under which X-ray imaging services are covered for a member. Used during claims adjudication to apply the correct radiology benefit limits, coinsurance rates, and network rules specific to diagnostic imaging services.

xray policy numberxr_pol_nbr

The insurance policy identifier associated with a member's X-ray imaging claim or benefit. Used in claims processing and radiology billing systems to link diagnostic imaging services to the correct coverage record, enabling accurate benefit application and payer remittance.

PreviousPage 142 of 142