Delete Utility - HRUTDL

The Human Resources Delete Utility (HRUTDL) page is used to mass delete old or unwanted data from any table in the HR system. To run the utility, the table to delete from is entered along with the primary selection criteria field. Then a comparison operator and data is entered for the primary selection criteria field. If more detailed selection criterion is needed, there is a 546-character Custom SQL field that may be used. All fields on the page are used to create the SQL statement that the utility runs.

Entity: Entity is used to further define selection criteria for deletion of records. If a table is entity-specific and records from only one entity are to be deleted, place an entity in this field. Leave blank if either the table does not contain an Entity field (there is no entity on the page), or if all entities are to be considered in the delete action. If the table from which records are being deleted does not contain an Entity field, leave this field blank. The field will default to the entity associated with the logged in user on HRRQUS, if a record exists. Code values are defined in the HR Entity Codes (HRRQEN) page.

From Table: Choose a table from the pick list from which to delete data. Only those tables entered in the HR Delete Utility Setup (HRUTDT) page are displayed. If the table does not contain an Entity field (there is no entity on the page), or if all entities are to be considered in the delete, leave the Entity field blank.

Where: Choose a column from the pick list to use as primary selection criteria. Available columns are those associated with the selected table.

Op: Choose an arithmetic operator from the pick list to use with the column in the Where field. Codes are predefined in the system and not available for modification.

Delete Date: If the column entered in the Where field is a date type, enter a date to be used as the comparison date for the utility.

Example:
From Table Where Op Delete Date
HR_BENEFINFO BENE_END < 01/01/2013
This command deletes all entries from the hr_beneinfo table (HR Pay Assignments (HRPYBE) page, Benefit Assignments tab) with a benefit end date that is less than 01/01/2013.
Or Delete String: If the column entered in the Where field is not a date type, enter a value to be used as a comparison value for the utility.

Example:
From Table Where Op Or Delete String
HR_EMPPAY FISCALYR =2012-13
This command deletes all entries from the hr_emppay table (HR Pay Assignments page) with a Fiscal Year equal to 2012-13.

Custom SQL: Additional selection criteria may be entered to further limit the records to be deleted.

Notes: Enter any desired notes.

Run By: System-derived and represents the user running the utility.

Run Date: System-derived and represents the date and time the utility was run.