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

serology policy numbersero_pol_nbr

The unique insurance policy identifier linked to a member's serology testing encounter. Used in laboratory and claims data systems to associate serum antibody test orders and results with the correct insurance policy for adjudication and reimbursement.

service enrollment statussvc_enrl_sts

Indicates a member's current enrollment standing with respect to a specific covered healthcare service or service category. Reflects whether the member is actively eligible, pending approval, suspended, or terminated for that service under their health plan benefit structure.

session coinsurance amountsess_coins_amt

The dollar amount a member is responsible for paying as their coinsurance share for a single therapy or treatment session, such as a physical therapy or behavioral health visit. Calculated based on the plan's coinsurance rate applied to the allowed amount after the deductible is met.

session enrollment statussess_enrl_sts

Indicates the current enrollment or authorization status of a member for a structured series of therapy or treatment sessions. Reflects whether the session-based service, such as chemotherapy or rehabilitation, is actively authorized, pending, or closed under the member's health plan.

session plansess_pln

Identifies the health insurance or benefits plan under which a specific therapy or treatment session is covered and billed. Used in claims and utilization management systems to associate individual session encounters with the correct plan for adjudication and cost-sharing calculation.

session policy numbersess_pol_nbr

The unique insurance policy identifier associated with a member's therapy or treatment session encounter. Used in claims and utilization management data systems to link individual session-level services to the correct insurance policy for billing, authorization, and reimbursement tracking.

sign coinsurance amountsgn_coins_amt

The member cost-sharing amount owed as coinsurance for a clinical encounter where an observable sign, such as abnormal vital signs or physical findings, was documented and billed. Derived by applying the plan's coinsurance percentage to the allowed amount for that encounter.

sign enrollment statussgn_enrl_sts

Indicates the enrollment or coverage status of a member at the time an observable clinical sign was documented. Used in clinical and claims data systems to confirm active plan membership when a sign-based diagnosis or assessment triggers a billable or reportable healthcare event.

sign plansgn_pln

Identifies the health insurance or benefits plan associated with a clinical encounter where an observable sign was assessed and documented. Used in claims data systems to link sign-driven diagnoses and evaluations to the appropriate plan for reimbursement and population health reporting.

sign policy numbersgn_pol_nbr

The unique insurance policy identifier linked to a clinical encounter in which an observable sign was documented and billed. Used in claims and clinical data systems to associate sign-based assessments with the correct insurance policy for adjudication and coverage verification.

site coinsurance amountsite_coins_amt

The member cost-sharing amount owed as coinsurance based on the specific care delivery site where services were rendered, such as a hospital outpatient department versus an independent clinic. Site-of-service designations often affect allowed amounts and applicable coinsurance rates under health plans.

site enrollment statussite_enrl_sts

Indicates the active enrollment or network participation status of a care delivery location within a health plan or care management program. Used to confirm whether a facility site is currently credentialed, in-network, or approved to deliver covered services to enrolled members.

site plansite_pln

Identifies the health insurance or benefits plan associated with services rendered at a specific care delivery site, such as a clinic, hospital, or ambulatory surgery center. Used in claims systems to apply site-specific benefit rules, reimbursement rates, and cost-sharing calculations correctly.

site policy numbersite_pol_nbr

The unique insurance policy identifier linked to healthcare services delivered at a specific care site. Used in claims and facility billing systems to associate site-level service encounters with the correct insurance policy for adjudication, network validation, and reimbursement processing.

slot coinsurance amountslot_coins_amt

The member cost-sharing amount owed as coinsurance for a specific appointment slot or scheduled service time. Used in scheduling-integrated billing systems to capture the expected member financial responsibility associated with a booked appointment based on applicable plan coinsurance rates.

slot enrollment statusslot_enrl_sts

Indicates a member's enrollment or eligibility status at the time an appointment slot is scheduled or accessed. Used in scheduling and eligibility verification systems to confirm active plan membership before a specific time slot is reserved and services are authorized for delivery.

slot planslot_pln

Identifies the health insurance or benefits plan associated with a member's scheduled appointment slot. Used in scheduling and claims systems to link the booked service time to the correct coverage plan, enabling pre-authorization checks, cost-sharing estimates, and accurate billing upon service completion.

slot policy numberslot_pol_nbr

The unique insurance policy identifier associated with a member's scheduled appointment slot. Used in scheduling and eligibility systems to verify active coverage at the time of booking and to link the appointment slot to the correct insurance policy for authorization and subsequent claims billing.

specialist coinsurance amountspec_coins_amt

The dollar amount a member is responsible for paying when receiving care from an in-network specialist, calculated as a percentage of the allowed amount after the deductible is met. Captured on medical claims and defined within the member's benefit plan structure.

specialist enrollment statusspec_enrl_sts

Indicates whether a member's health plan benefits include active coverage for specialist visits, reflecting their current enrollment eligibility. Used in member benefit administration to determine access to specialist services and applicable cost-sharing requirements.

PreviousPage 128 of 142Next