dim_inclusive_contingent


Description

A contingent defining how often a service can be used, included in a customer’s contract. An inclusive contingent belongs to one of five variety types: RATE (linked to a standard contract tariff), MODULE_RATE (linked to a module tariff), TAG (linked to a customer tag), RATE_CODE (linked to a rate code), or AGGREGATOR (linked to an external aggregator). Only RATE and MODULE_RATE varieties have a rate reference; TAG, RATE_CODE, and AGGREGATOR varieties have no associated rate.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
inclusive_contingent_id int8 19 null
fct_class_event.inclusive_contingent_id erp_v2_fct_class_event_inclusive_contingent_id__erp_v2_dim_inclusive_contingent_inclusive_contingent_id_fkey_94ae8bcc3b4a R
fct_customer_appointment.inclusive_contingent_id fct_customer_appointment_inclusive_contingent_id_fkey R
fct_service_usage.inclusive_contingent_id fct_service_usage_inclusive_contingent_id_fkey R

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

Name of the rate (contract tariff) this contingent belongs to. ‘UNKNOWN’ for contingents of variety type TAG, RATE_CODE, or AGGREGATOR which are not linked to a rate.
duration_type varchar 256 √ null

Duration period for which this contingent is active, e.g., DAY, MONTH, YEAR, etc.
unit varchar 256 √ null

Unit type: FLAT for unlimited usage or TIMES for a limited number of uses
num_of_usage int4 10 √ null

How many times this contingent can be used
validity_type varchar 256 √ null

How long this contingent is valid
archived bool 1 √ null

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