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 fct_idle_period_organization_unit_id_fkey R

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

The person who went idle.
rate_id int8 19 √ null
dim_rate.rate_id fct_idle_period_rate_id_fkey 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 fct_idle_period_contract_id_fkey 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 fct_idle_period_idle_period_property_id_fkey R

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

The first date at which the idle period is valid.
end_date_id int4 10 √ null
dim_date.date_id fct_idle_period_end_date_id_fkey 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 fct_idle_period_currency_id_fkey 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