Salary Definitions - HRTBSL

All salary schedules, ranges, and step amounts are set up on the Human Resources (HR) Salary Definitions (HRTBSL) page. This is where the salary index is created. The salary index is the key value assigned to the employee that ties back to this table in order to retrieve the correct salary amounts. The HR Salary Schedule Codes (HRTBSC) page must be set up before entering information into HR Salary Definitions.

If a Salary Definitions record is deleted and it contains the only reference to a Range Listings table record (hr_rangtble), that record will be deleted as well.

Entity*: Indicates the entity to identify security clearance. Code values are defined in the HR Entity Codes (HRRQEN) page.

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.

Salary Schedule*: Indicates the salary schedule code. Typically, this is a code representing the salary schedule title. For example, TEAC (Teacher), ADMN (Administration), etc. Code values are defined in the HR Salary Schedule Codes (HRTBSC) page.

Index Description: Indicates a salary index to establish the amount value. Valid index values will be contained within the specified effective dates.

Eff Beg Dt / Eff End Dt: Effective date range for the salary schedule. System derived from HR Salary Schedule Codes, based on the salary schedule.

Schedule Type: System derived from HR Salary Schedule Codes, based on the salary schedule.

Range*: Enter the range value associated with the schedule entry. The range can represent a level of education, skill, or simply a lateral seniority movement. If the Range Lisings Table (hr_rangtble) already contains the entered value, then the associated description is reflected in the Range Description field. Upon saving the record, the Range Listings table is updated. The hr_rangtble is not represented by a physical screen.

Range Description*: Enter the range description or if the range already exists in the hr_rangtble, the corresponding description will be displayed. The hr_rangtble stores each range with one description so whatever is entered//used last in HRTBSL, is what is added/updated in the hr_rangtble.

Salary Eff Beg Dt / Salary Eff End Dt*: Effective dates for the salary amounts.

Axp*:The amount expressed as code indicates how the dollar figure/amount is to be interpreted in payroll.

Board Approval Dt: System derived from HR Salary Schedule Codes, based on the salary schedule.

Bargaining Unit: System derived from HR Salary Schedule Codes, based on the salary schedule. Code values are defined in the HR Entity Specific Codes (HRTBCE) page, Bargaining Unit tab.

Rounding Code: Indicates whether to round the hourly and daily rates on the HR Pay Assignments, when an index from this HR Salary Definitions entry is assigned. The hourly and daily rates on the Pay Assignments hold up to five characters to the right of the decimal. If a code of "1" is entered, the system will automatically round up to two decimals to the right. Otherwise, for greater accuracy, leave this field blank or enter "N". Code values are defined in static system codes.

Salary Details

The salary detail records are displayed in a grid. One salary table master record per one or more salary detail records.

Step*: Indicates the step value. The step can represent, for example, years or level of experience. If a Step value is less than 10, the system will automatically add a leading zero to it. This is for sorting purposes. If the Step is a fraction value and is under 10 (i.e. 5.4), a leading zero must manually be added.

Step Description: Represents a description of the salary step.

Amount: Indicates a salary index amount. This is the amount which will be used in a range comparison (if mid-min-max type) or which will be derived (if full-index type) when assigned to an employee.

Index Key*: System derived. The salary index is derived based on the "Salary Index Code Use" entry found on the HR Salary Schedule Codes (HRTBSC) page. Depending upon the code used, the index will be either Salary Schedule/ Range/Step or Bargaining Unit/Salary Schedule/Range/Step. The salary index is the most important field on the page and is the value assigned to the employee on various payroll interface/update pages in the payroll and employee modules.

Misc: Miscellaneous data, such as a special code. The maximum length of the field is four characters. If the Percent Salary Increase function (see below) is to be used, any Step record containing an "X" in the associated Misc field will be skipped, meaning the associated salary will not increase.

Other Information

Misc 1-8: Miscellaneous data associated with each salary index record for this salary schedule and range. The values apply to each of the Index Keys, not just one.

First Step: The First Step field represents the first step in the range to be increased.

Last Step: The Last Step field represents the last step in the range to be increased.

% Increase: The percentage to increase the step amounts. The percentage increase will be applied to all steps within the First and Last Step range where there is no "X" already stored/saved in the Misc field.

Asterisk (*) denotes a required field.
The HR Salary Definitions page ties back to other HR pages, such as HR Salary Schedule Codes (HRTBSC) and HR Entity Codes (HRRQEN).
If a Salary Definitions record is deleted and it is the only reference to a Range Listings table record, that record will also be deleted.
The echo_desc field is used throughout HR for Salary Index lookups and is affected by the length of salary schedule and range descriptions.

Percent Salary Increase Functionality

Processing example:
Step C Misc field = "X" (already saved with the record)First Step = A, Last Step = C, Step A salary = 10,000, Step B salary = 11,000, Step C salary = 12,000, % Increase = 5
After tabbing from the % Increase field, steps A and B are recalculated. A message displays indicating the records need to be refreshed. Select Refresh from the top Navigation bar. A message asking to save the records will appear. Click Yes. The records, with their new amounts, are displayed to the page.
Step A salary = 10,500 Step B salary = 11,550 Step C salary = 12,000

Tools for Salary Table

Global Processing Salary Table

The Global Processing tool populates the hidden echo_desc column in the database. This field is also populated when new entries are added manually.
The echo_desc is formulated as follows:
'$'
    Salary Amount (decimal precision is based on Round Code)
    blank space
    'Desc:'
    Salary Schedule Short Description
    '-'
    Range Description
The echo_desc value is used throughout HR for Salary Index lookups. Due to width limitations in system lookup columns, having a shorter Salary Schedule Short Description and Range Description is important to see more detail.