dim_discount_campaign_localized


Description

Localized public names and descriptions for discount campaigns, one row per campaign per locale. Used to display campaign information in the member’s preferred language (e.g. in the MySports app or online checkout). Follows the same pattern as dim_rate_localized and dim_cancellation_reason_localized.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
discount_campaign_localized_id varchar 256 null

The primary key of this table. Surrogate key derived from (discount_campaign_id, locale).
discount_campaign_id int8 19 √ null
dim_discount_campaign.discount_campaign_id erp_v2_dim_discount_campaign_localized_discount_campaign_id__erp_v2_dim_discount_campaign_discount_campaign_id_88507be14e5c R

The discount campaign this translation belongs to.
locale varchar 256 √ null

The locale for this translation, formatted as ISO-639 language code + ISO-3166 country code (e.g. de_DE, nl_NL, en_GB).
public_name varchar 65535 √ null

The customer-facing name of the discount campaign for this locale. May be null if no translation has been configured.
description varchar 65535 √ null

The customer-facing description of the discount campaign for this locale. May be null if no translation has been configured.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation