🧭✨ Future Operators (NEW)

✨ NEW TABLE - December 2025

🛠️ Partner API Alignment Migration

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

1️⃣ Migrate to this table by April 2026

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

Contains operator data filtered for specific operator relationships including direct matches and parent-child operator hierarchies. Enriches the base operator data with matching flags to identify the main operator and parent operator relationships for downstream processing.

SQL: FUTURE__operators

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	Primary key
Other IDs
parent_operator_id	INTEGER	References the parent operator when this operator is part of a hierarchical structure
country_id	INTEGER	Foreign key reference to the country where the operator is located
currency_id	INTEGER	References the primary currency used by the operator for transactions
language_id	INTEGER	References the default language setting for the operator
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the operator record was originally created in the system
updated_at	TIMESTAMP_NTZ	Timestamp of the most recent update to the operator record
deleted_at	TIMESTAMP_NTZ	Soft deletion timestamp indicating when the operator was marked as deleted
frozen_at	TIMESTAMP_NTZ	Timestamp when the operator account was frozen or suspended
negative_balance_at	TIMESTAMP_NTZ	Timestamp when the operator's balance first went negative
balances_updated_at	TIMESTAMP_NTZ	Timestamp of the last balance calculation or update for the operator
churned_at	TIMESTAMP_NTZ	Timestamp when the operator was marked as churned or inactive
Filters
is_main_operator_match	BOOLEAN	Indicates whether this record matches the specified operator ID directly
is_parent_operator_match	BOOLEAN	Indicates whether this record has the specified operator as its parent operator
Attributes
name	VARCHAR	Display name or business name of the operator
identifier	VARCHAR	Unique business identifier or code assigned to the operator
vat_number	VARCHAR	Value Added Tax registration number for the operator
tax_number	VARCHAR	Tax identification number assigned by local tax authorities
address1	VARCHAR	Primary street address line for the operator's business location
address2	VARCHAR	Secondary address line such as suite or apartment number
address3	VARCHAR	Additional address line for extended addressing requirements
city	VARCHAR	City or municipality where the operator is located
zip	VARCHAR	Postal or ZIP code for the operator's address
province	VARCHAR	Province, state, or administrative region of the operator's location
country_subdivision_code	VARCHAR	Standard code for the country subdivision such as state or province
email	VARCHAR	Primary email address for general operator communications
support_phone_number	VARCHAR	Phone number designated for customer support inquiries
finance_email	VARCHAR	Email address for financial and billing related communications
legal_email	VARCHAR	Email address for legal matters and official correspondence
company_name	VARCHAR	Official registered company name of the operator organization

Changes from Last Version

Added columns (29) Identifiers:

country_id
currency_id
language_id

Date/Time Fields:

updated_at
frozen_at
negative_balance_at
balances_updated_at
churned_at

API Fields - Core:

identifier
vat_number
tax_number

API Fields - Address:

address1
address2
address3
city
zip
province
country_subdivision_code

Contact Information:

email
support_phone_number
finance_email
legal_email
company_name

Computed Fields:

is_main_operator_match (boolean flag)
is_parent_operator_match (boolean flag)

Removed columns (0)

Renamed Columns (2)

operator_id → id
operator_name → name

Data inclusion criteria

This table works with operator_id or parent_operator_idmust match the operator's ID.

Data flow

Upstream tables	Downstream tables
---	`FUTURE__application_users`
---	`FUTURE__subscription_purchases`
---	`FUTURE__subscriptions`
---	`FUTURE__charge_point_sites`
---	`FUTURE__tariff_prices`
---	`FUTURE__tariff_racurring_preiods`
---	`FUTURE__tariff_period_groups`

Alignment

Partner API

Aligns with Partner API get/operators endpoint

`operators` table

exclude rows where deleted_at is not null

where deleted_at is null