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

coinsurance license numbercoins_lic_nbr

The professional license identifier associated with a provider or entity linked to a coinsurance cost-sharing record. Used in health plan credentialing and claims systems to verify that services generating coinsurance obligations were rendered by a properly licensed and credentialed healthcare professional.

coinsurance marital statuscoins_mar_sts

The marital status of the member or subscriber associated with a coinsurance cost-sharing arrangement. Used in benefits administration to determine applicable family coinsurance rates and cost-sharing tiers within health plan benefit structures.

coinsurance master identifiercoins_mstr_id

The enterprise-wide unique identifier assigned to a specific coinsurance cost-sharing rule or record. Enables consistent tracking and cross-referencing of coinsurance configurations across claims processing, benefits administration, and member enrollment systems.

coinsurance maximumcoins_max

The maximum allowable coinsurance percentage or dollar amount a member is required to pay for covered services under a health plan benefit. Once this threshold is reached, the plan typically covers remaining eligible costs at 100% for the benefit period.

coinsurance medical record numbercoins_mrn

The medical record number of the patient linked to a specific coinsurance cost-sharing record. Used to associate coinsurance payment obligations with clinical encounters and reconcile member cost-sharing responsibilities against patient account records.

coinsurance middle namecoins_mid_nm

The middle name or initial of the member or subscriber associated with a coinsurance cost-sharing record. Used in member identity verification and matching processes within benefits administration and health plan enrollment systems.

coinsurance minimumcoins_min

The minimum coinsurance percentage or dollar amount applicable to a covered service under a health plan benefit. Defines the floor of member cost-sharing responsibility and is used in benefits configuration and claims adjudication processing.

coinsurance mobilecoins_mob

The mobile phone number of the member or subscriber associated with a coinsurance cost-sharing record. Used for member outreach, cost-sharing notifications, and billing communications within health plan member services operations.

coinsurance modified bycoins_mod_by

The user identifier of the individual who last updated a coinsurance cost-sharing record. Supports audit trail requirements and change management tracking within benefits administration and health plan configuration systems.

coinsurance modified datecoins_mod_dt

The calendar date on which a coinsurance cost-sharing record was most recently updated. Used in audit logging, benefits configuration change tracking, and effective date management within health plan administration systems.

coinsurance modified timecoins_mod_tm

The timestamp indicating when a coinsurance cost-sharing record was most recently updated. Provides granular audit trail data for benefits configuration changes and supports sequencing of updates within health plan administration systems.

coinsurance namecoins_nm

Human-readable name for coinsurance within Member processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

coinsurance notecoins_nt

A free-text annotation attached to a coinsurance cost-sharing record documenting exceptions, special conditions, or administrative context. Used by benefits administrators to capture non-structured information relevant to a coinsurance rule or member arrangement.

coinsurance numbercoins_nbr

Reference number for coinsurance within Eligibility processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

coinsurance onset datecoins_onset_dt

The effective date on which a coinsurance cost-sharing arrangement begins applying to a member's health plan benefits. Used in benefits administration to manage coinsurance applicability windows and align cost-sharing rules with plan year or enrollment period boundaries.

coinsurance oxygen saturationcoins_o2sat

The recorded blood oxygen saturation level associated with a clinical encounter linked to a coinsurance cost-sharing event. Used when coinsurance records are tied to specific clinical service records requiring vital sign documentation for billing or clinical validation purposes.

coinsurance paid amountcoins_pd_amt

The dollar amount of coinsurance actually paid by the member for a covered healthcare service. Captured during claims adjudication and payment processing to reflect the member's fulfilled cost-sharing obligation and reconcile against expected coinsurance liability.

coinsurance paid datecoins_pd_dt

The date on which the member's coinsurance payment was received or processed for a covered healthcare service. Used in claims payment reconciliation, member account management, and accounts receivable tracking within health plan financial systems.

coinsurance parentcoins_prnt

The parent record or higher-level benefit configuration to which a coinsurance cost-sharing rule is subordinate. Used in hierarchical benefits plan structures to link coinsurance rules to their governing plan, benefit tier, or coverage category within health plan administration systems.

coinsurance percentagecoins_pct

The specific percentage of an allowed healthcare service cost that a member is responsible for paying after the deductible is met. A core cost-sharing parameter used during claims adjudication to calculate member liability under medical, dental, or vision health plan benefits.

PreviousPage 31 of 142Next