dim_idle_period_property

The primary key of this table.

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 his request), CONTRACT_IDLE_PERIOD, CONTRACT_TRIAL_PERIOD (Idle Period was set on specific contract(s) of a customer, likely by his request), BONUS_PERIOD (Idle Period was set on a contract of a customer, likely as a ‘reward’ by the gym).

Whether the contractually agreed on contingent of idle time of the customer is reduced.

Whether the contractually agreed on time, until the customer can cancel a related contract, is extended.

Whether the agreed on time until a related contract ends is extended.

Whether the customer can still enter the gym (checkin). Always True for type=BONUS_PERIOD

An explanation why this idle period is used. (eg Customer broke his leg, Free month as birthday present, ..)

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