dim_idle_period_property


Description

Additional dimensional information about an idle period. A junk dimension containing the properties that describe how an idle period was configured and what its effects are on the customer’s contract and gym access.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idle_period_property_id varchar 256 null
fct_idle_period.idle_period_property_id fct_idle_period_idle_period_property_id_fkey R

The primary key of this table. Generated by MD5 hash of all property columns.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id dim_idle_period_property_organization_unit_id_fkey R

The gym (organization_unit) where this idle period configuration applies.
type varchar 256 √ null

Specifying how the idle period was created in the source system. One of: MEMBER_IDLE_PERIOD (Idle Period was set on the customer, likely by their request), CONTRACT_IDLE_PERIOD, CONTRACT_TRIAL_PERIOD (Idle Period was set on specific contract(s) of a customer, likely by their request), BONUS_PERIOD (Idle Period was set on a contract of a customer, likely as a ‘reward’ by the gym).
reduces_idle_period_contingent bool 1 √ null

Whether the contractually agreed on contingent of idle time of the customer is reduced.
extends_cancelation_period bool 1 √ null

Whether the contractually agreed on time, until the customer can cancel a related contract, is extended.
extends_contract_period bool 1 √ null

Whether the agreed on time until a related contract ends is extended.
permits_studio_entry bool 1 √ null

Whether the customer can still enter the gym (checkin). Always true for type=BONUS_PERIOD.
reason varchar 256 √ null

An explanation why this idle period is used (e.g., ‘Customer broke their leg’, ‘Free month as birthday present’).
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation