Debt Collection System - Job Dashboard

🔧 Debug Interface 🔀 Debt Merging Tool

Available Jobs

Excel Processing Job

Processes Excel files and imports data into database

Required Parameters:
  • file_path

Debt Aggregation Job

Aggregates staging debts and merges into customer_debts with exclusion handling.

Excluded Account Processing Job

Processes excluded accounts and creates support tickets for them.

Debt Action Planning Job

Determines the next required collection action for each debt based on business rules and quotas.

Debt Action Execution Job

Executes planned collection actions for debts that are ready for processing.

Collection Sequence Management Job

Manages collection action sequences - insert, remove, and reorder actions.

Required Parameters:
  • action

File Cleanup Job

Cleans up old temporary files and logs

Populate Israeli Business Days Job

Populates the israeli_business_days table with business days and holidays from the Hebcal API.

Required Parameters:
  • start_year
  • end_year

Debug Job

Debug and testing job for QA purposes

HistoricalDiscoveryJob

Discovers historical Excel files from database tables matching DD.MM.YYYY pattern

HistoricalProcessingJob

Processes historical Excel files chronologically to build debt lifecycle tracking

HistoricalReportingJob

Generates reports and verifies data integrity for historical debt processing

Historical Data Cleanup

Cleans all processing data and resets files to pending status (keeps discovered files)

Required Parameters:
  • confirm

historical_reconciliation

Reconcile historical debts with current debts and cleanup excluded customers

Required Parameters:
  • Action to perform: compare|cleanup|stats|export
  • Name of current debts table (required for compare/cleanup)