Supplementary Purge (Employee)

The Supplementary Purge removes data from the Transportation Manager database that is not managed by the transactional purge utility.

This utility purges data that is older than a user-provided cutoff date.

The Supplementary Purge supports the following functions:

Operational Data

• Purge Dock Commitments
• Purge Load Planning Data
• Purge Load Denormalized Tables
• Purge Monitoring Data
• Purge Event Notification Data
• Purge Tender Requests
• Purge Non-Processed Shipments
• Purge Driver Assignments

Financial Data

• Purge Financial Runs
• Purge Non-Operational Freight
• Purge Invoices and Freight Bills
• Purge Orphan G/L Entries

Setup Data

• Purge Domicile Equipment Types and Vehicle Availability
• Purge Exchange Rates
• Purge Fixed Date Timetables
• Purge Location Throughput Group Capacity
• Purge Lane Constraints / Equipment Availability
• Purge Distance Engine Cache
• Purge Skeleton Routes

Miscellaneous

• Purge Audit Data
• Purge Orphan Entries
• Purge Rate Quotations
• Purge Non-Financial Requests
• Purge Integration Requests
• Purge Resources
• Purge Transactional Orphan Entries

Note: Supplementary Purge is restricted to systems administrators.

Trigger Supplementary Purge

1. Click Environment > System >Supplementary Purge. The Purge Supplementary Data page is displayed.
2. Specify a cutoff date to remove the data that is older than this date.
3. Select the required supplementary purge utilities to invoke. If applicable, provide additional data for the selected purge.
4. Under the Request section, enter Start Date and select the Priority.

   Note:

   • The purge process does not start prior to the designated date/time. After that time, the asynchronous job will be triggered once all submitted jobs with a higher priority are completed.
5. Click Submit. The jobs are placed on the Request Queue.

Note: You can access the information related to any of the jobs initiated by Purge Supplementary Data using Miscellaneous > Batch Requests in the navigation pad. See List of Batch Requests (Employee).

There is no detailed reporting on the purge results. Summary information is available in the Request Message Log (for example, user, options, cut off date/time and the number of entries deleted per table).

Note: It is recommended that the jobs triggered by Purge Supplementary Data be scheduled to execute during off hours.