fct_idle_period

-1 rows


Description

A timeframe in which a customer doesnt have to pay for his contract(s).

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 int8 19 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 19,2 null

The fee charged for this period, instead of the usual contract fee.

currency_id int8 19 null
dim_currency.currency_id fct_idle_period_currency_id_fkey R

The system of money in which income was generated.

last_updated timestamptz 35 null

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

Relationships