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

regulation enrollment statusreg_enrl_sts

Captures a member or plan's current enrollment standing relative to a specific regulatory compliance requirement, such as state Medicaid mandates or ACA provisions. Used in benefit administration systems to track adherence to governing rules affecting coverage eligibility and plan participation.

report coinsurance amountrpt_coins_amt

The member's coinsurance liability amount associated with a specific claims or utilization report. Used in benefit cost-sharing calculations to document the percentage-based out-of-pocket expense applied to reportable services after the deductible has been satisfied under the health plan.

report enrollment statusrpt_enrl_sts

Indicates the enrollment state of a member as captured within a specific reporting period or regulatory report submission. Used in health plan analytics and compliance reporting to reflect whether a member was actively enrolled, terminated, or pending during the reported timeframe.

report planrpt_pln

Identifies the specific health benefit plan associated with a reporting record or claims summary. Used in plan-level analytics, regulatory submissions, and financial reporting to attribute utilization, cost, and membership data to the correct benefit plan within a payer's book of business.

report policy numberrpt_pol_nbr

The insurance policy number recorded within a structured report, used to link the report data back to the member's specific health plan contract. Supports claims reconciliation, audit trails, and regulatory reporting by ensuring each report record is traceable to a valid policy.

requirement coinsurance amountreq_coins_amt

The coinsurance dollar amount tied to a specific coverage or benefit requirement, such as a mandatory cost-sharing provision under a health plan contract. Used in benefits administration and claims adjudication to apply the correct member cost-sharing obligation for required covered services.

requirement enrollment statusreq_enrl_sts

Reflects a member's enrollment status as it pertains to meeting a specific plan or regulatory requirement, such as a mandatory wellness program or credentialing obligation. Used in health plan administration to monitor compliance with enrollment-based conditions affecting benefits or coverage eligibility.

requirement planreq_pln

Identifies the health benefit plan associated with a specific coverage or compliance requirement. Used in plan administration systems to map mandatory benefit provisions, regulatory obligations, or contractual requirements to the applicable plan, supporting accurate adjudication and benefits configuration.

requirement policy numberreq_pol_nbr

The policy number linked to a specific coverage requirement, used to associate mandatory benefit conditions or regulatory obligations with the correct health plan contract. Supports claims processing, compliance auditing, and benefits administration by ensuring requirements are traceable to valid policies.

result enrollment statusrslt_enrl_sts

Indicates the enrollment state of a member at the time a clinical or administrative result was recorded, such as a lab outcome or prior authorization decision. Used in care management and population health systems to contextualize results within the member's active coverage and plan participation period.

review enrollment statusrvw_enrl_sts

Captures the membership enrollment state of a member at the time a clinical, utilization, or quality review was conducted. Used in utilization management and quality assurance workflows to confirm that the member held active coverage during the review period, affecting authorization and appeals decisions.

rheumatology coinsurance amountrheum_coins_amt

The member's coinsurance obligation for rheumatology specialty services, including treatment for autoimmune and musculoskeletal conditions such as rheumatoid arthritis and lupus. Applied during claims adjudication based on the health plan's specialist cost-sharing tier after the member's deductible has been met.

rheumatology enrollment statusrheum_enrl_sts

Reflects a member's enrollment state within a rheumatology-specific benefit program or specialty care plan, covering autoimmune and inflammatory disease management. Used in specialty benefit administration to determine eligibility for rheumatology services, disease management programs, and specialty drug coverage.

rheumatology planrheum_pln

Identifies the health benefit plan governing coverage for rheumatology specialty services, including diagnosis and treatment of autoimmune and musculoskeletal disorders. Used in claims adjudication and specialty benefit management to apply the correct cost-sharing rules, network requirements, and prior authorization criteria.

rheumatology policy numberrheum_pol_nbr

The insurance policy number associated with a member's rheumatology specialty benefit coverage. Used to link rheumatology claims, authorizations, and specialty pharmacy transactions to the correct health plan contract, ensuring accurate adjudication of autoimmune and musculoskeletal disease-related services.

room enrollment statusrm_enrl_sts

Indicates the enrollment or assignment status of a patient within a specific inpatient or facility room, used in hospital billing and utilization management systems. Tracks whether a room assignment is active, pending, or discharged to support accurate facility billing, bed management, and length-of-stay reporting.

route coinsurance amountrte_coins_amt

The member's coinsurance amount applied based on the route of administration for a drug or treatment, such as oral, intravenous, or injectable. Used in pharmacy and medical claims adjudication where cost-sharing obligations differ by administration pathway under the health plan's benefit design.

route enrollment statusrte_enrl_sts

Indicates the enrollment state associated with a specific drug administration route, such as specialty injectable programs or infusion therapy services. Used in pharmacy benefit management and specialty drug programs to determine a member's eligibility for coverage under administration-route-specific benefit provisions.

route planrte_pln

Identifies the insurance plan associated with a specific medication administration route, linking the delivery pathway (oral, IV, subcutaneous, etc.) to the corresponding benefit plan for claims adjudication and clinical documentation purposes.

route policy numberrte_pol_nbr

The unique insurance policy identifier linked to a medication administration route record, used to associate the delivery pathway with a specific coverage policy for claims processing, billing reconciliation, and benefit verification across payer systems.

PreviousPage 126 of 142Next