Table of Contents
WAGE SCALES#
Wage Scales are used to hold the exact value of an employee’s wage, and to maintain a historical record of the changes to these wages over time. Scales are linked to units which are usually union agreements. If a scale is the same for more than one unit, the system allows you to apply the scale to both units as separate independent scales. This allows you to later modify one scale without affecting the other. Wage scales may be created and updated through the Maintain Wage Scales/Steps (ISWS) form.
Wage Scales/Steps data is maintained on the P2K_SA_WAGE_SCALES, P2K_SA_WAGE_SCALE_STEPS and P2K_SA_WAGE_STEP_DETAILS tables.
- Wage Scale
- This field holds the name of the scale. Scale_Code is a 16-character alphanumeric mandatory field which you may fill manually.
- Description
- In this field, you may enter a description of the wage scale created. Description is a 50-character alphanumeric optional field that may be manually entered.
- Unit
- Each scale must be associated with a unit which may be identified in this field. Unit_Code is a 16-character alphanumeric mandatory field which must be filled by making a selection from the LOV provided. The values in this lexicon were created in the Define Units (IDUN) form.
- Entity
- Each scale must be associated with an entity which may be identify in this field. Entity_Code is a 16-character alphanumeric field. A value will be defaulted in once the Unit is selected. The values in this lexicon were created in the Define Entities (IDEN) form.
- Wage Step Rule
- The stepping rule for the wage scale may be identified here. For one unit, there may be more than one step rule which will be assigned to different groups within the unit. The employee will be assigned a step rule according to their group. This step rule will then be applied to their assignment scale/step. It is, however, possible to have different wage stepping rules within one group. This is accomplished by indicating the rule on the scale. Wage_Step_Rule is a 16-character alphanumeric mandatory field which you may fill with a selection from the LOV.
- Rate Matrix
- Enter the rate matrix code that allow you to associate a matrix cell with a step within the scale. This field may be updated later, after matrices have been discussed and created. Matrix is an optional 16-character mandatory field which you may fill with a selection from the LOV.
- Step
- Within this field, you will enter the actual name of the step you are creating. This name may be a numeric, alphanumeric, or descriptive value. Step_Code is a 16-character alphanumeric mandatory field which you must complete manually.
- Seq #
- This field will allow you to define the sequential order of the wage steps. This sequential order will be used by Wiki to process the steps in order. Step_Sequence is a 4-character numeric mandatory field which you must complete manually.
- Effective as of
- This field displays the date the wage is effective. Effective only be changed through the ‘Scale Modification’ area in this screen, in the Change Date field.
- Basis
- This field shows the time basis the rate is expressed in and how often it is earned. For example, is this rate earned monthly, weekly or daily?. Rate_Basis is a mandatory fixed field (X_RATE_BASIS) that must be filled with a value selected from the lexicon.
- Rate
- This is the rate, based on the rate basis (below), defined for the step. Enter a dollar amount in this field. Scale_Rate is a mandatory amount field that may be manually entered.
- Change Reason
- This field displays the reason for the rate change. This field may be used in mass update programs to insert a change reason into the new records (with the new rate) that will be created.
- Cell #
- Cells are a specific point on the Define Rate Matrices (ISRM) form. You may place this cell number on several different scales and but control its rate through the matrix.
- Effective/Expiry
- The Effective and Expiry fields indicate the dates through which a wage step is in effect. These fields have a default entry of the 01-Jan-0001 and 31-Dec-3999. Effective and Expiry dates can only be changed through the ‘Scale Modification’ area in this screen, in the Change Date field.
Note that this process does NOT allow a ‘trial’ run but the changes are not committed until the form is saved.
Mass Change#
You may update an entire scale within the Scale/Step form by using the Mass Change button.
- Change Date
- This field shows the date the change is to occur.
- Change Reason
- This field shows the reason for the rate change. This field may be used in mass update programs to insert a change reason into the new records (with the new rate) that will be created.
- Type
- This field indicates the type of change to be applied.
- Percent
- If the change is a percentage, this field holds the actual percentage amount to be changed.
- Amount
- If the change is a fixed amount, this field holds the actual amount to be changed.
Step Change#
You may update an entire scale within the Scale/Step form by using the Step Change button.- Change Date
- This field shows the date the change is to occur.
- Change Reason
- This field shows the reason for the step change.
- Type
- This field indicates the type of change to be applied. With the Cell Increase or Decrease, not only will the step be increased/decreased on the scale, but also its associated cell will be increased/decreased on the rate matrix.
- Percent
- If the change is a percentage, this field holds the actual percentage amount to be changed.
- Amount
- If the change is a fixed amount, this field holds the actual amount to be changed.
Modify Effective Date#
If the effective date split is correct but the date is wrong then it may be modified, one step at a time. This can be done by pressing the Modify Effective button.- Old Effective
- This is field displays the old date that the change was effective.
- Change Reason
- This field shows the reason for the change in effective date.
- New Effective
- This is field displays the new date that the change is effective.
Add New Step#
This action allows you to add a new step to the scale.- Amount
- This field indicates the percentage or amount increase or decrease.
- Step/Sequence
- These two fields will allow you to specify the step and sequence that are to be changed. Neither of these fields are accessible for the mass rate change.
