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.
EntityEntity: Indicates the entity to identify security clearance. Code values are defined in the HR Entity Codes (HRRQEN) page.: 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.
Schedule Effective Dates Dates: Indicates the effective dates for the amount values. System derived from HR Salary Schedule Codes, based on the salary schedule.
ScheRangeduulee TypTypeSche: System derived from HR Salary Schedule Codes, based on the salary schedule.
: Enter the range value associated with the schedule entry. The rarangege can represent a level of education, skill, or simply a lateral seniority movement. If the RaIf the Rangege ListiListings gs tablable (h (hr_ra_rangtble)tble) already contains the enteredlready contains the entered value,, thethen the associated descricriptition is reflecte is reflected in the Ran the Rangee DDescription field. Upon saving the record field. Upon saving the record, the Range Listings table is updated. The is updated. The hr_rangtble is not renot representeresented by by a physical scre physical screen.
Rangen: EntEnter the range range description or, if, if thee range alreadyalready exexissts inin ththe hr_hr_rangtble,angtble, thee corresponspondining descr descriptioption will be dispisplayayed. d. Thhe hr_rangtble hr_rangtble stororess each ach range wange with onth one descescriptiiptionn soso whwhatevetever is is enterentered//ussedd lalast in HRTBSLt in HRTBSL, is whis what it is added/updat added/updated iin the hr_rangtbr_rangtble.
Dates Approval Dt
:: 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. Indicates how the amount is expressed. Code values are defined in static system codes.
BoardApprovalDt: 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.
AmountIndex 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.
Range
DescripDescriptiion
BoardSalary Effective Datesassciated dn.
: orr: Indicates the effective dates for the salary details. These dates must be within or equal to the Schedule Effective dates.willbBargaining UnitAxp
: System derived from HR Salary Schedule Codes, based on the salary schedule.
SalaryDetails
The salary detail records are displayed in agrid. One salary table master record per one or more salary detail records.
:Indicatesa 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.
OtherInformation
Percent Salary Increase Functionality
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.
Processing example:
Step C Misc field = "X" (already saved with the record)First Step = ALast Step = CStep A salary = 10,000Step B salary = 11,000Step 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,500Step B salary = 11,550Step 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.