How to delete/remove resource capacity/aggregates after employee has been terminated?

[Pranav_Thanedar]

Let us assume that we have an employee who was part of the organisation until 01 Feb. 2025 but his capacity and aggregates are generated until 31 Dec. 2025, using the related links on the employee record on sys_user table.

Now the resource_aggregate_monthly and resource_aggregate_weekly tables show the aggregates generated until 31 Dec. 2025.

After the employee is terminated, the Employment end date field on employee Profile (sn_employee_profile) table is updated to the employee termination date. After the date is updated, if we run a job/script to update employee capacity and aggregates again, this doesn't delete the capacity or aggregates generated for dates after employee termination date.

Is there a way to automatically delete these aggregates? 

The employee name still shows up while creating resource assignments because of this issue.

[Pranav_Thanedar · Accepted solution]

Hi @Alpa82 ,

Its "Resource Termination Handler" Scheduled Script Execution job.

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.

Regards,

Pranav Thanedar