dim_rate_bundle


Description

Rate bundle (offer) header that defines which contract package can be sold and the contract timing rules tied to it.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rate_bundle_id int8 19 null
bridge_rate_bundle_payment_choice.rate_bundle_id Implied Constraint R
bridge_rate_bundle_to_company.rate_bundle_id Implied Constraint R
dim_rate_bundle_term.rate_bundle_id Implied Constraint R

The primary key of this table. System column calculated by the source System.
is_archived bool 1 √ null

Whether the rate bundle is archived.
limited_offering_start_date date 13 √ null

Start date for when the offer can be presented.
limited_offering_end_date date 13 √ null

End date for when the offer can be presented.
contract_start_type varchar 256 √ null

How the contract start date is determined for this offer.
start_date_of_use_type varchar 256 √ null

How the start date of use is determined for this offer.
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