dim_rate


Description

A rate (Tarif) is a membership tariff template configured by a gym operator, defining pricing, billing frequency, and contract terms. Customers are signed up to contracts based on a rate.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rate_id int8 19 null
bridge_rate_to_rate_code.rate_id erp_v2_bridge_rate_to_rate_code_rate_id__erp_v2_dim_rate_rate_id_fkey_9ee2eae02ce4 R
dim_contract_voucher_definition.rate_id erp_v2_dim_contract_voucher_definition_rate_id__erp_v2_dim_rate_rate_id_fkey_c565bcfd10eb R
dim_contract_voucher_rate_discount_period.rate_id erp_v2_dim_contract_voucher_rate_discount_period_rate_id__erp_v2_dim_rate_rate_id_fkey_0f1b67906738 R
dim_rate_localized.rate_id erp_v2_dim_rate_localized_rate_id__erp_v2_dim_rate_rate_id_fkey_3be38d4e221e R
dim_rate_term_configuration.rate_id erp_v2_dim_rate_term_configuration_rate_id__erp_v2_dim_rate_rate_id_fkey_8aa80a16b5a9 R
dim_rate_term_payment_frequency.rate_id erp_v2_dim_rate_term_payment_frequency_rate_id__erp_v2_dim_rate_rate_id_fkey_24eaf2a75a7c R
dim_studio_starter_package_adjustment.rate_id erp_v2_dim_studio_starter_package_adjustment_rate_id__erp_v2_dim_rate_rate_id_fkey_e4f8e5600d4a R
fct_contract.rate_id erp_v2_fct_contract_rate_id__erp_v2_dim_rate_rate_id_fkey_6c24ad00ff02 R
fct_contract_cancellation.rate_id erp_v2_fct_contract_cancellation_rate_id__erp_v2_dim_rate_rate_id_fkey_58640f8358c5 R
fct_idle_period.rate_id erp_v2_fct_idle_period_rate_id__erp_v2_dim_rate_rate_id_fkey_bce65a5cca84 R
fct_invoice.rate_id erp_v2_fct_invoice_rate_id__erp_v2_dim_rate_rate_id_fkey_e147c9be7ad9 R
fct_rate_term_payment_frequency_price.rate_id erp_v2_fct_rate_term_payment_frequency_price_rate_id__erp_v2_dim_rate_rate_id_fkey_d81de4569261 R
fct_rate_term_payment_frequency_price_adjustment.rate_id erp_v2_fct_rate_term_payment_frequency_price_adjustment_rate_id__erp_v2_dim_rate_rate_id_fkey_4fa4778e2590 R
fct_revenue.rate_id erp_v2_fct_revenue_rate_id__erp_v2_dim_rate_rate_id_fkey_e8c4ce28fc0c R
fct_revenue_invoice_based.rate_id erp_v2_fct_revenue_invoice_based_rate_id__erp_v2_dim_rate_rate_id_fkey_3aa5475d9fe8 R

The primary key of this table. System column calculated by the source System.
contract_type varchar 256 √ null

Of which type contracts of this rate should be

  • CONTRACT: The main contract of a customer
  • MODULE: Services a customer can book additionally (eg a subscription for drinks)
  • FLAT_FEE: Fees to enable one-time access to a service
name varchar 256 √ null

The internal name given to this rate by a user.
active bool 1 √ null

(Temporarily) set to a non-functional state, pausing creation of new contracts using this rate.
archived bool 1 √ null

Permanently removed but kept for history.
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