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

study planstdy_pln

The documented clinical or research protocol outlining the objectives, methodology, procedures, and imaging schedule for a diagnostic imaging study. Recorded in radiology information systems and clinical research platforms to guide imaging workflows and ensure adherence to study protocols.

study policy numberstdy_pol_nbr

The unique identifier assigned to the insurance policy under which a diagnostic imaging study is authorized and billed. Links the imaging study to the member's health plan coverage record, enabling claims adjudication, prior authorization tracking, and reimbursement reconciliation in radiology billing systems.

subscriber account numbersubscr_acct_nbr

The unique account identifier assigned by a health plan or insurer to the primary policyholder. Used in member enrollment systems and claims processing to link the subscriber's coverage, dependents, premium billing, and claims activity to a single account record across the insurance lifecycle.

subscriber active indicatorsubscr_actv_ind

A binary flag indicating whether a primary insurance policyholder currently holds active coverage with the health plan. Used in member enrollment and eligibility systems to control claims adjudication, benefits access, and eligibility verification responses submitted to providers and clearinghouses.

subscriber active statussubscr_actv_sts

Describes the current enrollment activity state of a primary insurance policyholder, such as active, terminated, suspended, or cobra-enrolled. Used in health plan membership systems to manage eligibility verification, premium billing cycles, and downstream claims processing rules based on coverage status.

subscriber addresssubscr_addr

The physical or mailing address of the primary insurance policyholder stored in member enrollment and claims systems. Includes street, city, state, and ZIP fields used for EOB mailing, eligibility verification, and demographic matching across EHR, PBM, and payer platforms.

subscriber adjustment amountsubscr_adj_amt

The dollar value applied to modify a subscriber's premium, claim, or account balance due to retroactive enrollment changes, rate corrections, or payment reconciliations. Captured in health plan billing and claims systems to maintain accurate financial records for the policyholder's coverage account.

subscriber admission datesubscr_admn_dt

The inpatient admission date associated with the primary insurance policyholder, captured in claims and hospital billing systems. Used by data engineers to correlate subscriber-level claims with facility encounter records and validate coordination of benefits across payer adjudication platforms.

subscriber agesubscr_age

The calculated age in years of the primary insurance policyholder, typically derived from date of birth at the time of enrollment or as of a specific reference date. Used in health plan systems for premium rating, actuarial risk stratification, age-based benefit eligibility, and underwriting decisions.

subscriber allowed amountsubscr_alwd_amt

The maximum dollar amount a health plan will reimburse for services rendered to a primary policyholder or their dependents, based on contracted rates or fee schedules. Drives cost-sharing calculations including coinsurance, deductible application, and out-of-pocket accumulator updates during claims adjudication.

subscriber amountsubscr_amt

A monetary value associated with the primary insurance policyholder in claims, enrollment, or billing systems. May represent premium contributions, out-of-pocket payments, or cost-sharing obligations. Data engineers use this field to reconcile subscriber-level financials across PBM, payer, and EHR platforms.

subscriber approval statussubscr_appr_sts

Indicates the authorization or approval state of a primary policyholder's enrollment application, coverage change request, or prior authorization submission, such as approved, denied, or pending review. Tracked in health plan enrollment and utilization management systems to govern benefits activation and access.

subscriber approved bysubscr_appr_by

Identifies the user, reviewer, or system that granted approval for a primary policyholder's enrollment, coverage modification, or authorization request. Captured in health plan administrative systems to maintain an audit trail of approval decisions for compliance, dispute resolution, and regulatory reporting purposes.

subscriber arrival timesubscr_arrv_tm

The recorded time at which the primary insurance policyholder arrived at a healthcare facility for a scheduled or unscheduled encounter. Used in patient registration and scheduling systems to calculate wait times, measure operational efficiency, and support encounter documentation tied to the subscriber's insurance record.

subscriber arrived datesubscr_arrv_dt

The calendar date on which the primary insurance policyholder presented at a healthcare facility for care. Captured during patient registration and linked to the subscriber's insurance record to establish the encounter date of service for claims billing, eligibility verification, and visit tracking purposes.

subscriber assessmentsubscr_asmt

The clinical evaluation or health status assessment documented for the primary insurance policyholder during a healthcare encounter or health plan onboarding process. May include risk stratification scores, health risk assessment responses, or care management findings used to guide benefit design and population health programs.

subscriber balancesubscr_bal

The outstanding financial amount owed by or credited to the primary insurance policyholder in claims adjudication and billing systems. Used by data engineers to track unpaid premiums, deductible balances, or overpayments across payer, PBM, and member enrollment platforms for financial reconciliation.

subscriber billed amountsubscr_bill_amt

The total dollar amount invoiced to the primary insurance policyholder for healthcare services rendered, representing the provider's submitted charges before contractual adjustments, plan payments, or cost-sharing are applied. Recorded in claims and billing systems as the starting point for adjudication and explanation of benefits processing.

subscriber birth datesubscr_birth_dt

The date of birth of the primary insurance policyholder stored in enrollment, claims, and EHR systems. Critical for age-based eligibility validation, Medicare coordination, and member deduplication. Data engineers use this field as a key matching attribute across payer, PBM, and provider data sources.

subscriber cancelled datesubscr_cncl_dt

The effective date on which a primary insurance policyholder's health plan coverage was terminated or cancelled, whether due to non-payment, voluntary disenrollment, employer group termination, or loss of eligibility. Used in enrollment systems to close coverage periods and update downstream eligibility verification and claims processing rules.

PreviousPage 130 of 142Next