Using the Human Resources delete utility set up window

Shortcut/mask: HRUTDT

The HR delete utility set up window is designed to select records from various windows in the HR system; in particular windows like HRTBHR and HRTBCE.

Below is an example that demonstrates the steps to complete on HRUTDT before running the HR Delete (HRUTDL) utility:

  1. Open the window by typing HRUTDT in the Search field and pressing Enter.
  2. Use the fields on the window to select the records you wish to delete by going into the window (such as, HRTBHR or HRTBCE) and reviewing the Code ID associated with the record.

HRDELTBL_SCREEN – HRTBHR: Records with this Code ID identify the window name to delete from. These records populate the HRUTDT “Window to Delete From” field menu.

HRDELTBL_FIELD – HRTBHR: Records with this Code ID identify the primary field name that will be used as selection criteria. These records populate the HRUTDT Selection Criteria field menu based on the entered Window to Delete From value.

Note: The HRTBHR Short Description must equal the corresponding window name in the Code Value field from the appropriate HRTBHR HRDELTBL_SCREEN record. More than one HRDELTBL_FIELD record may be associated with an HRDELTBL_SCREEN record.

HRDELTBL_TABLE – HRTBHR: Records with this Code ID identify the database table name associated with the window name of the appropriate HRDELTBL_SCREEN record. This value is used by the HRUTDL code.

Note: The required records must be first entered into the HRTBHR window, then the HRUTDT window. This is required before the HRUTDL window may be used to delete records from a particular window.

  1. On HRUTDT, add a record for HRCODE (HRTBHR) and HRENCODE (HRTBCE) for deleting based on the long description (LONG_DESC).
  2. On HRUTDU, create distribution information for the records that have been targeted for deletion. If you are deleting from HRTBCE use HRENCODE instead of HRCODE.
  3. Select Save Changes.

Result: You have complete selecting records so you can run the Delete Utility (HRUTDL).

Related Information: