Understanding Leave Purging
You can use the Purge Leave Request report (R07520) to delete records from the F07620 table. In some instances, this table might contain approved requests for leave time that the employee did not take. In such an instance, the employee might not be aware that the leave request is still active.
The table might also contain denied requests that you want to remove. When requests are denied, the record remains in the system so that the leave request originator can review the record, including any notes that the manager includes in the response.
When you process this program, you select a date range. You can then delete any of these types of records that meet the date criteria:
Denied leave requests.
Completed requests for leave time that the employee takes.
Approved leave requests.
You can run this program in proof mode or update mode. When you run this program in the proof mode, the system generates a report so that you can view the records that the system will purge. When you run the program in update mode, the system deletes those records from the table. You should run this program in proof mode before running it in update mode to ensure that you delete the correct records from the system.