dim_dunning_level


Description

Dimension table for dunning levels configured in the Magicline dunning engine. Each row represents one level in a dunning escalation ladder, as defined by a studio’s dunning configuration template.

Two level types exist (dunning_level_type): - DUNNING — a standard escalation step with configurable rules and actions. dunning_levels_order = 0 is the “No Dunning Level” baseline. - DEBT_COLLECTION — the terminal level representing handoff to an external debt collection agency. Has no configurable dunning rules.

Join from fct_dunning_step.dunning_level_id to obtain the level’s position in the escalation sequence and its type. Archived levels may appear on historical fct_dunning_step rows but are no longer assigned to new dunning steps.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dunning_level_id int8 19 null
fct_dunning_step.dunning_level_id fct_dunning_step_dunning_level_id_fkey R

Primary key of this table. Uniquely identifies this dunning level.
dunning_levels_order int4 10 √ null

Position of this level in the escalation sequence within its configuration template. 0 represents the “No Dunning Level” baseline (no dunning action triggered yet). Higher values indicate later stages in the escalation ladder.
dunning_level_type varchar 20 √ null

The type of this dunning level, derived from the JPA single-table inheritance discriminator column.

Values

  • DUNNING — a standard dunning escalation level with configurable rules
  • DEBT_COLLECTION — the terminal level for external debt collection handoff
dunning_configuration_template_id int8 19 √ null

The dunning configuration template that defines the escalation ladder this level belongs to.
is_archived bool 1 √ null

Whether this dunning level has been archived (soft-deleted). Archived levels are no longer assigned to new dunning steps but may still appear on historical fct_dunning_step rows.
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