dim_rate_term_payment_frequency_age_based_adjustment


Description

Age-based price adjustments for payment frequencies.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
age_based_adjustment_id varchar 256 null

Primary key of the age-based adjustment.

payment_frequency_id varchar 256 null

The payment frequency this age adjustment applies to.

min_age varchar 256 null

Minimum age (in years) for this adjustment band.

max_age varchar 256 null

Maximum age (in years) for this adjustment band.

adjustment_price varchar 256 null

Adjusted price applied for this age range.

adjustment_type varchar 256 null

How the adjustment is applied. Possible values: ABSOLUTE, PERCENTAGE.

last_updated timestamptz 35 null

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

Relationships