dim_inclusive_contingent


Description

A contingent how often a service can be used, that is included in a contract (rate) of a customer.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
inclusive_contingent_id int8 19 null
fct_class_event.inclusive_contingent_id fct_class_event_inclusive_contingent_id_fkey 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 contingent
duration_type varchar 256 null

For how long this contingent is active, e.g DAY, MONTH, etc
unit varchar 256 null

Is it FLAT or can be used limited number of times
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 behind source system).

Relationships

Close relationships within degrees of separation