dim_studio_starter_package_adjustment


Description

Studio-specific overrides for the one-time starter package fee charged at membership sign-up. Each row defines a custom fee for a specific gym and rate term configuration, overriding the default fee on the rate term (dim_rate_term_configuration.starter_package). Only gyms with an explicit override have a row here; the absence of a row means the rate term default applies.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
studio_starter_package_adjustment_id int8 19 null

The primary key of this table. System-generated identifier of the adjustment per studio.
rate_id int8 19 √ null
dim_rate.rate_id erp_v2_dim_studio_starter_package_adjustment_rate_id__erp_v2_dim_rate_rate_id_fkey_e4f8e5600d4a R

The rate (tariff) for which this adjustment rule applies.
rate_term_configuration_id int8 19 √ null
dim_rate_term_configuration.rate_term_configuration_id erp_v2_dim_studio_starter_package_adjustment_rate_term_configuration_id__erp_v2_dim_rate_term_configuration_ra_af781dd95291 R

The rate term configuration for which this starter package amount applies.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id erp_v2_dim_studio_starter_package_adjustment_organization_unit_id__erp_v2_dim_organization_unit_organization_u_711bef1b21d1 R

The organization unit (gym) where this starter package amount applies.
amount numeric 19,2 √ null

The studio-specific override for the one-time starter package fee. Overrides the default fee defined on the rate term configuration. A value of 0.0 means the studio has explicitly waived the fee.
valid_from date 13 √ null

The date from which this studio-specific starter package adjustment applies.
valid_until date 13 √ null

The date until which this studio-specific starter package adjustment applies.
is_archived bool 1 √ null

Whether this studio-specific starter package adjustment has been archived.
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