1. Implementing Incentive Compensation
  2. Purge Incentive Compensation Transactional Test Data

Purge Incentive Compensation Transactional Test Data

You can test your new implementation by creating transactions and taking them through to payment. When you're ready to go live, use this procedure to purge all of your transaction data.

Caution: The data will be completely purged and isn't recoverable.

Do this first to prevent errors:

  • Have other users sign out so they can't perform transactions while the purge is running.

  • Complete any paysheet approval requests.

  • Complete the approval process for any disputes.

  • Run the Deploy Incentive Plans process to make sure there are no unprocessed events.

To purge test transactional data:

  1. Click Navigator > Scheduled Processes.

  2. Click Schedule New Process.

  3. Search for the Purge Incentive Compensation Transactional Test Data process.

  4. Click OK.

  5. In the Parameters region, select at least one and up to three business units to be purged. If you have any transactions in one business unit that also have credits in a different business unit, then select both business units to be purged.

  6. Make sure all the transaction data in the selected business units is test data that no one will need in the future. Then select the I understand that purged data can't be retrieved check box.

  7. Click Submit.

These transaction tables are purged:

Table Name

Data Contained

CN_TP_TRANSACTIONS_ALL

Transactions

CN_TP_CREDITS_ALL

Credits

CN_TP_EARNINGS_ALL

Earnings

CN_TP_TRANSACTIONS_ALL_H

Transaction History

CN_TP_CREDITS_ALL_H

Credits History

CN_TP_EARNINGS_ALL_H

Earnings History

CN_TP_JOB_STATISTICS_ALL

Collect Statistics

CN_TP_EVENT_LOGS_ALL

Changed Event Log

CN_TP_MEASURE_RESULTS_ALL

Measure Results

CN_DISPUTES_ALL

Disputes

CN_EST_CMP_TRANSACTIONS_ALL

Estimated Compensation Transactions

CN_EST_CMP_EARNINGS_ALL

Estimated Compensation Earnings

CN_EST_CMP_MSR_RESULTS_ALL

Estimated Compensation Measure Results

CN_EST_CMP_SCENARIOS_ALL_B

Estimated Compensation Scenarios

CN_EST_CMP_SCENARIOS_ALL_T

Estimated Compensation Scenarios

CN_EST_CMP_SCENARIOS_TXNS_ALL

Estimated Compensation Scenarios

CN_SRP_SUBLEDGER_ALL

Participant Balances

CN_TP_PARTICIPANT_PAY_ALL

Payment Transactions

CN_TP_PAYRUNS_ALL

Payment Batches

CN_TP_PAYSHEETS_ALL

Paysheets

CN_SRP_PER_FORM_METRICS_ALL

Period target and draw amounts assigned to a salesperson's plan component