fct_rate_bundle_term_availability


Description

Fact table listing which organization units can sell each rate bundle term per sales channel.

Columns

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

The primary key of this table. Surrogate key built from the bundle term, organization unit and sales channel.
rate_bundle_term_id int8 19 √ null
dim_rate_bundle_term.rate_bundle_term_id erp_v2_fct_rate_bundle_term_availability_rate_bundle_term_id__erp_v2_dim_rate_bundle_term_rate_bundle_term_id__63dbe9cd5551 R

The rate bundle term available in the organization unit.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id erp_v2_fct_rate_bundle_term_availability_organization_unit_id__erp_v2_dim_organization_unit_organization_unit__3321960f897f R

The organization unit (gym) where the bundle term is available.
sales_channel varchar 256 √ null

The sales channel through which the bundle term is available. Indicates how the rate bundle can be sold.
is_active bool 1 √ null

Whether the bundle term is active for the organization unit and sales channel based on the active rate bundle group configuration.
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