dim_contract_voucher_rate_discount_period


Description

A period during which a discount is applied for a certain rate in the context of a contract voucher. This defines the discount structure (e.g., 100% off for the first 3 months).

Columns

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

The primary key of this table. System column calculated by the source system.
contract_voucher_definition_id int8 19 √ null
dim_contract_voucher_definition.contract_voucher_definition_id dim_contract_voucher_rate_discount_period_contract_voucher_definition_id_fkey R

The voucher definition this discount period belongs to. Null if linked only to a specific voucher.
contract_voucher_id int8 19 √ null
fct_contract_voucher.contract_voucher_id dim_contract_voucher_rate_discount_period_contract_voucher_id_fkey R

The specific redeemed voucher this discount period is linked to. Null if linked only to the definition.
rate_id int8 19 √ null
dim_rate.rate_id dim_contract_voucher_rate_discount_period_rate_id_fkey R

The specific rate this discount applies to. Null if the discount applies to all rates.
effective_period varchar 256 √ null

Description on how long this discount period is effective for.

One of: * TIME_BASED: The discount is effective for a specific time period defined by effective_period_time_based_term_value and effective_period_time_based_term_unit. * UNLIMITED: The discount is effective indefinitely. * INITIAL_TERM: The discount is effective for the initial term of the contract.
effective_period_time_based_term_value int8 19 √ null

The numeric value of the time-based term for this discount period (e.g., 3 for 3 months). Only applicable if effective_period is TIME_BASED.
effective_period_time_based_term_unit varchar 256 √ null

The unit of the time-based term (e.g., MONTHS, WEEKS, DAYS). Only applicable if effective_period is TIME_BASED.
discount_position int8 19 √ null

The position/order of this discount in a sequence of multiple discount periods.
discount_type varchar 256 √ null

The type of discount: ABSOLUTE (fixed amount) or PERCENTAGE.
discount_absolute_amount numeric 18 √ null

The absolute discount amount if discount_type is ABSOLUTE.
discount_percentage numeric 18 √ null

The percentage discount if discount_type is PERCENTAGE. E.g., 100.00 for free.
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