🧭✨ Future Charge Member Costs (NEW)

✨ NEW TABLE - December 2025

🛠️ Partner API Alignment Migration

🧭 This table represents the post-migration state for charge_member_costs.

1️⃣ Migrate to this table by April 2026

2️⃣ Between April 2026 and July 2026, remove FUTURE__ prefix

Contains charge member cost records enriched with team price group validation status. This model tracks costs associated with charging sessions for members and includes a derived flag indicating whether the associated cost group has valid pricing configurations. Data is filtered to only include member cost types from the team price groups.

SQL: FUTURE__charge_member_costs

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	Primary key
Other IDs
charge_id	INTEGER	Foreign key referencing the specific charging session
cost_group_id	INTEGER	Foreign key referencing the cost group configuration used for pricing
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the charge member cost record was created
updated_at	TIMESTAMP_NTZ	Timestamp when the charge member cost record was last modified
deleted_at	TIMESTAMP_NTZ	Timestamp when the record was soft deleted, null if record is active
Attributes
cost	NUMBER	Calculated cost amount for the member's charging session
team_price_group_is_not_empty	BOOLEAN	Indicates whether the associated cost group has valid pricing rows available, true when pricing configurations exist

Changes from Last Version

Added columns(2):

deleted_at
legacy_team_price_group_is_not_empty

Removed columns (0):

no columns were removed

Renamed columns (1):

charge_member_cost_id → id

Data inclusion criteria

This table includes records where the team_price_group_id belongs to the operator or sub-operators

Data flow

Upstream tables	Downstream tables
FUTURE_team_price_groups	---

Alignment

`charge_member_costs` table

Must execute deleted records and records where the legacy_team_price_group_is_not_empty is false. The latter condition aligns team_price_groupstable

where deleted_at is null and legacy_team_price_group_is_not_empty = true

Updated 3 days ago