Purging System Extract Results

When you run the Extract Process, the application writes the output to the results tables. To free table and disk space, you should periodically purge this data.

Run the Extract Results Data Purge process to delete extract results in batch mode. If you want to delete a specific extract record, you can do so from the Extract Results window.

Prior to purging extract results, confirm that you no longer need the results or that you have written the output to a file using the Extract Write Process.

arrow icon   To purge a specific extract:

  1. Open the Extract Results window.

  2. Query the result that you want to delete.

  3. Choose the Delete icon from the toolbar.

  4. Confirm the deletion.

  5. Save your work.

arrow icon   To purge extracts in batch mode:

  1. Navigate to the Submit Requests window.

  2. Select the Extract Results Data Purge process.

  3. Open the parameters window.

  4. In the Validate field, select whether to Commit or Rollback the results of the purge process.

  5. Optional: select an Extract Name to purge the results of a single extract.

  6. Set the effective date of the process.

    Note: The purge process deletes all extract results on or before the effective date.

  7. Choose Submit.