Space Management Purge Functionality

Modified on Thu, 6 Oct, 2022 at 9:56 AM

Steps to use Space Management

System > Space > Space Management

The stored procedure used for purging the EC_EMPLOYEE_YTD_ENTITY table is EC_SYS_SPACE_MANA_PURGE2

This deletes the record from the EC_EMPLOYEE_YRD_ENTITY table as per the below condition;

DELETE FROM EC_EMPLOYEE_YTD_ENTITY

WHERE EMP_GROUP_CODE = @TEMP_EMP_GROUP_CODE AND

YEAR = @TEMP_YEAR AND

ENTITY_TYPE !=’GARNISHEE’ AND

NOT (ENTITY_TYPE = ‘DEDUCTION’ AND ISNULL(SUBSTRING(COVERAGE_CODE,1,2),’$$’) = ‘AR’)

Note: Any records that are not deleted during the Purge simply means they DO NOT satisfy the above condition, hence are not deleted.

Below is the script that you can run both before and after running the purge to compare number of rows

Select * from EC_EMPLOYEE_YTD_ENTITY

Where YEAR <= ‘XXXX’