Participant Subledger Balances

The application tracks the earned commission, payment amount, adjustments, and outstanding balances for each participant, for each period, in a table called Subledger. The subledger creates and stores three types of records, which use unique keys.

The application creates these records for participants after you do these tasks:

Import the participants.
Assign them to at least one compensation plan.

Transaction processing always retains participant subledger records for audit purposes.

Unique Keys

Here are the unique keys in the subledger:

Participant Id
Period Id
Role Id
Quota Id
Credit Type Id

Record Types

The application creates three types of subledger records:

Detail records, which store participant details
Carry forward records, which hold outstanding balances for an inactive plan component
Summary records, which are an aggregate of the detail records and carry forward plan component records

The summary record is redundant data storage, which the application uses to enhance performance, as well as for reports.