dim_rate_term_payment_frequency


Description

Payment frequency options available for rate terms, including price, cadence, and calculation settings.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rate_term_payment_frequency_id int8 19 null
dim_contract_voucher_rate_discount_period.rate_term_payment_frequency_id erp_v2_dim_contract_voucher_rate_discount_period_rate_term_payment_frequency_id__erp_v2_dim_rate_term_payment__f347a8726f1b R
dim_rate_bundle_term.rate_term_payment_frequency_id erp_v2_dim_rate_bundle_term_rate_term_payment_frequency_id__erp_v2_dim_rate_term_payment_frequency_rate_term_p_47bf3f42eb8b R
fct_rate_term_payment_frequency_price.rate_term_payment_frequency_id erp_v2_fct_rate_term_payment_frequency_price_rate_term_payment_frequency_id__erp_v2_dim_rate_term_payment_freq_54f1456d7341 R
fct_rate_term_payment_frequency_price_adjustment.rate_term_payment_frequency_id erp_v2_fct_rate_term_payment_frequency_price_adjustment_rate_term_payment_frequency_id__erp_v2_dim_rate_term_p_f114d3930fb7 R

Primary key of the payment frequency configuration.
rate_term_configuration_id int8 19 √ null
dim_rate_term_configuration.rate_term_configuration_id erp_v2_dim_rate_term_payment_frequency_rate_term_configuration_id__erp_v2_dim_rate_term_configuration_rate_ter_f9b701626c3d R

The rate term configuration this payment frequency belongs to.
rate_id int8 19 √ null
dim_rate.rate_id erp_v2_dim_rate_term_payment_frequency_rate_id__erp_v2_dim_rate_rate_id_fkey_24eaf2a75a7c R

The rate connected to this payment frequency.
payment_frequency_type varchar 256 √ null

Type of payment frequency. Possible values: FREE, NON_RECURRING, RECURRING, TERM_BASED, MONTH_DAY.
payment_frequency_price numeric 19,2 √ null

Standard price for this payment frequency
payment_frequency_value int4 10 √ null

Value associated with the frequency unit
payment_frequency_unit varchar 256 √ null

Unit of the payment frequency. Possible values: DAY, WEEK, MONTH, YEAR.
is_archived bool 1 √ null

Whether this configuration is archived
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()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation