🧭✨ Future Tariff Prices (NEW)

✨ NEW TABLE - December 2025

🛠️ Partner API Alignment Migration

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

1️⃣ Migrate to this table by April 2026

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

Contains detailed pricing information for tariff recurring periods with comprehensive deletion tracking. Enriches base tariff price data with deletion status from related tariff entities including recurring periods, tariffs, and tariff operators. Provides a complete view of pricing structure with temporal validity periods and hierarchical soft delete information for data lineage tracking.

SQL: FUTURE__tariff_prices

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	Primary key
Other IDs
tariff_recurring_period_id	INTEGER	Foreign key reference to the associated tariff recurring period
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the tariff price record was originally created
updated_at	TIMESTAMP_NTZ	Timestamp when the tariff price record was last modified
deleted_at	TIMESTAMP_NTZ	Timestamp when the tariff price was soft deleted, null if active
tariff_recurring_period_deleted_at	TIMESTAMP_NTZ	Deletion timestamp from the associated tariff recurring period record
tariff_deleted_at	TIMESTAMP_NTZ	Deletion timestamp from the parent tariff record in the hierarchy
tariff_operator_deleted_at	TIMESTAMP_NTZ	Deletion timestamp from the tariff operator record at the top of the hierarchy
Attributes
time_start	TIMESTAMP_NTZ	Timestamp when the tariff price becomes effective
time_end	TIMESTAMP_NTZ	Timestamp when the tariff price expires or is no longer valid
price	NUMBER	Monetary amount charged for the tariff during the specified time period
resolution	VARCHAR	Time resolution or granularity specification for the pricing period

Changes from Last Version

Summary

Filter Changes: Removed deleted_at is null filter; now exposes deleted records with deletion tracking columns
Deletion Tracking: Adds 4-level cascading deletion visibility (price → recurring_period → tariff → operator)

Added columns (4)

Timestamps:

deleted_at
tariff_recurring_period_deleted_at
tariff_deleted_at
tariff_operator_deleted_at

Removed columns (0)

Renamed Columns (2)

tariff_price_id → id

Data inclusion criteria

This table includes prices that belong to tariffs included in the operator's FUTURE__tariff_recurring_periods table

Data flow

Upstream tables	Downstream tables
`FUTURE__tariff_recurring_periods`	---

Alignment

`plans` table

exclude rows where any level in the join heirarchy is deleted (price → recurring_period → tariff → operator)

where deleted_at is null 
and tariff_recurring_period_deleted_at is null 
and tariff_deleted_at is null 
and tariff_operator_deleted_at is null