Salary Definition Utility - HRUTSU
The Human Resources (HR) Salary Definition Utility (HRUTSU) is used for adjusting dates and amounts on the HR Salary Definitions (HRTBSL) page. The page is separated into three areas: Options, Selection Criteria, and Adjustment Data.
The utility can be run in Add mode and in Browse mode if the Test checkbox had previously been marked. It is good practice to enter the desired data in Add mode, have the Test box checked, and then press enter. The utility will run but not affect any records in the database. Records will be generated and placed into the HR Salary Definition Utility List (HRUTSL) page, for each processed record, indicating the action taken including error messages. If everything looks okay at that time, then return to the same record in the utility page, clear the Test checkbox and press enter again. With the Test checkbox clear, the database records will be affected.
When Copy and Paste functionality is used on this page, the new record (pasted record) will have the Run By and Run Date fields updated to current user and date upon saving.
Pressing Enter to launch a job process. A job number will display which can be matched to the Show Jobs window. The tail sheet will contain information about the process.
Option: Utility option to use. Option 1 will update the HR Salary Definitions page for any selected records. Option 2 will create new HR Salary Definitions page assignments with the given dates and close the old/previous records. Code values are restricted to static system codes.
Round Salaries to # Decimals: Indicates the number of decimal places to which the salaries on the HR Salary Definitions page should be rounded.
Test: Select the checkbox if only a report is to be generated and no records on the HR Salary Definitions page are to be updated. Clear the checkbox if records should be updated or inserted into the HR Salary Definitions page.
Selection Criteria Section
Action: Indicates the action/purpose for entering or modifying a record. Code values are defined in the HR Non-Entity Specific Codes (HRTBHR) page under the Code ID of ACTION_CODE.
Entity: Indicates the entity ID of the records to be selected. 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.
Bargaining Unit: Indicates the bargaining unit of the records to be selected.
Schedule Type: Indicates the schedule type of the records to be selected.
Schedule Beg/End: Indicates the salary schedule or range of schedules of the records to be selected.
Col/Range/Grd Beg/End: Indicates the column/range/grade or range of grades of the records to be selected.
Step Beg/End: Indicates the step or range of steps of the records to be selected.
Concat Index Beg/End: Indicates the concatenated index key or range of index keys of the records to be selected.
Effective Beg Dt/End Dt: Indicates begin and end dates from the HR Salary Definitions page that is selected. If no end date is entered, all records with begin dates equal to or greater than this date will be selected.
As of Date: Indicates the date that is encompassed by the records to be selected.
Custom SQL: Custom SQL for use with selecting records. Examples of SQL statements are: 1) hr_schdtble.schedule='XYZ' or hr_schdtble.schedule='ABC', 2) hr_schdtble.schedule in ('XYZ', 'ABC').
New Information
New Schedule: This field is only functional with Run Option 2. If entered, then Run Option 2 becomes a copy utility. The records that match the entered selection criteria will have their Salary Schedule changed to this entered value and re-inserted either with their existing dates or with the newly entered dates in the Adjustment Data section. The original selected records are not modified.
The ability to perform a Dollar or Percent increase may also be performed when salary tables are copied.
New Col/Range/Grd: The column or range value associated with the schedule entry. The column can represent a level of education, skill, or simply a lateral seniority movement. Upon entering a value and the corresponding description, the Range Listings table (hr_rangtble) is automatically updated recognize this range if it is used for this schedule again in the future. This field is only functional with Run Option 2. If entered, then Run Option 2 becomes a copy utility. The records that match the entered selection criteria will have their Column/Range/Grade changed to the entered value and re-inserted either with their existing dates or with the newly entered dates in the Adjustment Data section. The original records are not modified.
Amount Increase: Indicates the amount by which the HR Salary Definitions records are to be increased.
Percent Increase: Indicates the percentage by which the HR Salary Definitions records are to be increased.
New Effective Beg/End: Indicates the new begin and new end date.
Set Amount to Zero: This field is only active for Option 2. If this field is checked, the new records in the HR Salary Definitions page will have amounts of zero.
Run Information
Run By: / Run Date: System generated with the User ID login and current transaction run date.
HR Salary Definition Utility List (HRUTSL)
The HR Salary Definition Utility List (HRUTSL) page will store one record for each record processed in the HR Salary Definition Utility. A message is placed into the Message field that indicates whether processing is/would be successful or if an error situation exists.