fct_idle_period


Description

A timeframe in which a customer does not have to pay for their contract(s). Includes member idle periods, contract idle periods, trial periods, and bonus periods.

Columns

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

The primary key of this table. System column calculated by the source System.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R

The gym (organization_unit) in which the customer went idle.
customer_id int8 19 √ null
dim_customer.customer_id Implied Constraint R

The person who went idle.
rate_id int8 19 √ null
dim_rate.rate_id Implied Constraint R

The rate of the (main) contract which is on idle, if this idle_period is about a specific contract.
contract_id int8 19 √ null
fct_contract.contract_id Implied Constraint R

The (main) contract which is on idle, if this idle_period is about a specific contract.
idle_period_property_id varchar 256 √ null
dim_idle_period_property.idle_period_property_id Implied Constraint R

Additional values describing this idle period.
start_date_id int4 10 √ null
dim_date.date_id Implied Constraint R

The first date at which the idle period is valid.
end_date_id int4 10 √ null
dim_date.date_id Implied Constraint R

The last date at which the idle period is valid.
charge_amount numeric 18 √ null

The fee charged for this period, instead of the usual contract fee.
currency_id varchar 256 √ null
dim_currency.currency_id Implied Constraint R

The system of money in which the charge amount is denominated.
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