fct_rate_term_payment_frequency_price_adjustment


Description

Dynamic price adjustment rules configured on a rate term payment frequency. Each row represents one rule that modifies the membership fee under specific conditions (a calendar date, a contract extension, a recurring interval, or a limited period). Rules define the adjustment type and value relative to the base price of the payment frequency; they are not pre-resolved to a final charge.

Columns

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

The primary key of this table. System-generated identifier of the dynamic adjustment rule.
rate_term_payment_frequency_id int8 19 √ null
dim_rate_term_payment_frequency.rate_term_payment_frequency_id fct_rate_term_payment_frequency_price_adjustment_rate_term_payment_frequency_id_fkey R

The recurring payment frequency this adjustment rule is attached to.
rate_term_configuration_id int8 19 √ null
dim_rate_term_configuration.rate_term_configuration_id fct_rate_term_payment_frequency_price_adjustment_rate_term_configuration_id_fkey R

The rate term configuration that owns the payment frequency.
rate_id int8 19 √ null
dim_rate.rate_id fct_rate_term_payment_frequency_price_adjustment_rate_id_fkey R

The rate (tariff) for which this adjustment rule applies.
rule_type varchar 64 √ null

The type of trigger that activates this adjustment rule: DATE fires on a recurring calendar date, EXTENSION fires at contract renewal, INTERVAL fires after a fixed duration, PERIOD_LIMITED is active within a configured date range on the contract.
repetition varchar 32 √ null

Whether the rule fires once (ONCE) on the first eligible trigger date, or repeatedly (REPEAT) on every subsequent eligible trigger date.
charge_adjustment_type varchar 64 √ null

How the charge_adjustment_value is applied to the base price: RELATIVE adds or subtracts a percentage (value / 100), ABSOLUTE adds or subtracts a fixed amount, BASIC_AMOUNT overrides the charge entirely with the given value.
charge_adjustment_value numeric 19,2 √ null

The magnitude of the price adjustment. Interpreted according to charge_adjustment_type: a percentage for RELATIVE, a fixed currency amount for ABSOLUTE, or the exact override charge for BASIC_AMOUNT. Negative values represent discounts.
apply_during_paid_period bool 1 √ null

Whether this adjustment rule fires even when the payment period has already been paid (true) or is skipped in that case (false).
allow_at_contract_start bool 1 √ null

Whether the first trigger of this rule may fall on the contract start date itself. When false, the first eligible date is pushed forward by one trigger interval.
month_day varchar 7 √ null

For DATE rules only: the calendar day (as –MM-DD) on which the rule fires each year. Null for all other rule types.
interval_value int4 10 √ null

For INTERVAL rules only: the numeric quantity of the interval after which the rule fires. Null for all other rule types.
interval_unit varchar 16 √ null

For INTERVAL rules only: the time unit for the interval value.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

Relationships

Close relationships within degrees of separation