(JPN) Updating Salaries for Japan

This chapter provides an overview of Japanese salary updating methods and shows you how to:

Click to jump to parent topicUnderstanding Updating Salaries for Japan

The methods for updating salaries in Japan involve some functionality-specific setup and, depending on the salary increase method your organization uses, some or all of the following:

The three salary increase methods are:

The final processes associated with each of these methods produce new compensation records for each worker with an action of Pay Rt Change and a reason of Salary Increase by Step, Salary Increase by Amount, or Salary Increase by Percent.

All the salary increase processes include worker review results in their calculation. Because review IDs are actually effective dates and the system automatically retrieves the results of the latest salary review after you specify the review ID for the process, you can be sure the system will use correct review results.

Prerequisites

All three salary increase methods must be based on worker reviews that have been resolved into a review band, meaning that worker reviews for these salary increase methods must be based on a review rating scale that has a scale type of Review Band.

Load Process

The load processes that are associated with each of the three salary increase methods—load steps, load amount, and load percentage increase—include a check of the worker’s job record effective dates, action and action reason, and job code. The load process terminates for the worker and reports the worker on the error list if either of these conditions exists:

Click to jump to top of pageClick to jump to parent topicCommon Elements Used in This Section

Language

Required because, although this batch process is a load process, there may be an error list that you need to read.

SetID

Enter the setID for the review ID that the system should use to calculate the worker’s review-based salary increase. Because you can link a single review ID to multiple setIDs, you must identify the review by its setID and its own ID.

Review ID

Enter the ID of the review on which the selected process is to base its load.

Click to jump to parent topicUpdating Salaries by Step Increase

To update salaries by step increase use the Step Increase JPN (STEPINC_TBL_JPN_GBL) component.

This section provides an overview of the step increase process and describes how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Step Increase Process

Updating salaries by step increase requires that you set up a Step Increase Table in which you associate several salary steps with a review band. Each worker’s review band is derived from the points awarded by single or multiple reviewers using weighted or nonweighted reviews. After you have the salary step increase for each review band and each worker’s review band, you can run a process to load the salary step increases for each worker.

Note. To run the update process for this method of salary increase, select the Multi-Step Grade check box on the Installation Table - HRMS Options page.

To update salaries by step increase:

  1. Set up review bands and the number of steps to increase.

  2. Run the JPN Load Salary Steps process.

Click to jump to top of pageClick to jump to parent topicPages Used to Update Salaries by Step Increase

Page Name

Object Name

Navigation

Usage

Step Increase Table JPN

STEPINC_TBL_JPN

Compensation, Base Compensation, Step Increase JPN, Define Step Increase, Step Increase Table JPN

Associate several salary step increases with a rating model and review rating.

Load Salary Steps JPN

RUN_STEP_JPN

Compensation, Base Compensation, Step Increase JPN, Load Salary Steps, Load Salary Steps JPN

Update the salary step and associated compensation on the job record for workers who have a fixed amount Plan/Grade/Step-based salary component.

Click to jump to top of pageClick to jump to parent topicSetting Up Step Increases

Access the Step Increase Table JPN page.

Rating Model and Review Rating

Enter the rating model and review rating.

Number of Steps to Increase

Enter the number of salary step increases to associate with the rating model that you entered. Workers in this rating model receive the salary that’s associated with the step they move to. For example, if they increase three steps for being in Rating Model A, they increase from the salary for step 2 to the salary for step 5.

Click to jump to top of pageClick to jump to parent topicProcessing Step Increases

Access the Load Salary Steps JPN page.

Calculation As Of Date

The effective date the system uses to determine which job compensation record it should use to obtain the worker’s current data to calculate the new data. For example, if the worker’s review band earns the worker a three-step increase, the system must use the existing step to calculate the new step.

Salary Increase Date

This becomes the effective date of the new job record that the system inserts for the worker for the review-based increased amount. The action and reason are Pay Rate Change and Salary Increase by Step.

Group ID

Enter specific groups for the system to process. If you select no groups, the system processes all workers who have a salary plan, grade, and step on their compensation record with a compensation rate code that’s defined in the Salary Rate Code Table.

Click to jump to parent topicUpdating Salaries by Salary Amount Increase

To update salaries by salary amount increase use the Salary Increase Amount JPN (SALINC_AMT_TBL_JPN_GBL) component.

This section provides an overview of the salary amount increase process and describes how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Salary Amount Increase Process

Using the updating salaries by salary amount increase method requires that you set up a Salary Increase Amount Table in which you associate a compensation rate code with review bands and monetary increase amounts with each review band. Each worker’s review band is derived from the points awarded by single or multiple reviewers using weighted or nonweighted reviews. After you have the salary increase amount for each review band and each worker’s review band, you can run a process to load the salary increase for each worker.

When you set up the Salary Increase Amount Table, you can select only compensation rate codes that are flat amount types and not of class GRPPAY or SENPAY.

To update salaries by salary amount:

  1. Set up rate codes, review bands, and increase amounts.

  2. Run the JPN Load New Salary Amount process.

Click to jump to top of pageClick to jump to parent topicPages Used to Update Salaries by Salary Amount Increase

Page Name

Object Name

Navigation

Usage

Sal Inc Amount Table JPN page (salary increase amount table JPN)

SALINC_AMT_TBL_JPN

Compensation, Base Compensation, Amount Increase JPN, Define Salary Increase Amount, Sal Inc Amount Table JPN

Define the salary increase amount for a particular compensation rate code, rating model, and review rating.

Load New Salary Amount JPN page

RUN_UPSALAMT_JPN

Compensation, Base Compensation, Amount Increase JPN, Load Salary Increase, Load New Salary Amount JPN

Execute the salary update process using the values that you’ve set in the Sal Inc Amount Table.

Click to jump to top of pageClick to jump to parent topicSetting Up Salary Amount Increases

Access the Sal Inc Amount Table JPN page.

To do so, enter the compensation rate code whose value you’re updating. The comp rate code must not be of class SENPAY and must be of type Flat Amount.

Rating Model and Review Rating

Enter the rating model and review rating for which to enter a salary increase amount.

Amount of Salary Increase

Enter the amount of the salary increase for workers whose review results put them in the rating model that you specified.

Click to jump to top of pageClick to jump to parent topicProcessing Salary Amount Increases

Access the Load New Salary Amount JPN page.

Calculation As Of Date

The effective date that the system uses to determine from which job compensation record it should get the worker’s current data to calculate new data. For example, if the worker’s review band earns the worker a ¥N increase, the system must get the existing rate code amount to calculate the new rate code amount.

Salary Increase Date

Becomes the effective date of the new job record that the system inserts for the worker for the review-based increased amount. The action and reason are Pay Rate Change and Salary Increase by Amount.

Rate Code

Enter the rate codes for which you defined a salary increase to include in this load process. The system displays the short description, currency, and compensation frequency associated with each rate code.

Note. You defined your salary increases by comp rate code and review band. You can run the process for multiple rate codes.

Group ID

Enter group IDs for workers to be included in this process. Leave this blank to have job compensation records updated for all workers who have the rate code that you specified. If a worker in a group that you specify doesn’t have the comp rate code that you specified for processing, the system skips the worker without processing.

Click to jump to parent topicUpdating Salaries by Percentages

To update salaries by percentages use the Salary Increase ID JPN (SALINC_ID_TBL_JPN_GBL) and Salary Increase Matrix JPN (SALARY_MATRIX_JPN_GBL) components.

This section provides an overview of the update salaries by percentage process and describes how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Update Salaries by Percentage Process

To use the updating salaries by percentages method, which includes a simulation process that shows the effects of various increase options, you set up two tables—the Salary Increase ID Table and the Salary Increase Matrix Table. On the Salary Increase ID Table, you specify a single compensation rate code, which must be of class Defined Range Pay (DFRPAY) and of type Flat Amount. You then run the simulation process, which, like other methods, uses review results in its calculation. You can adjust the result of the simulation for workers, increasing or decreasing it, and view the overall results—the totals—online. When you’re satisfied with the results, you run a second process, similar to the processes that conclude the other methods, to load the salary increase amounts to the workers’ job compensation records.

Note. To use this salary increase method, select the Defined Range Check check box on the Calculation Rule Settings JPN page.

To update salaries by percentage:

  1. Define a Japanese salary increase ID.

  2. Set up a Japanese salary increase matrix.

  3. Run the Run Salary Inc Table process.

  4. Run the salary increase simulation and adjust as required.

  5. Run the load salary increase process.

Click to jump to top of pageClick to jump to parent topicPages Used to Update Salaries by Percentage

Page Name

Object Name

Navigation

Usage

Salary Increase ID Table JPN

SALINC_ID_TBL_JPN

Compensation, Base Compensation, Percentage Increase JPN, Define Salary Increase ID, Salary Increase ID Table JPN

Define a salary increase ID and associate a rate code—which must be of class DFRPAY and of type Flat Amount—and worker groups with it. You run the salary increase simulation by salary increase ID.

Salary Increase Matrix JPN

SALARY_MATRIX_JPN

Compensation, Base Compensation, Percentage Increase JPN, Define Salary Increase Matrix, Salary Increase Matrix JPN

Establish the fixed percentage increase for each review rating by quartile. The fields on this page are identical to the Salary Increase Matrix Table page’s.

Generate Salary Increase Data

RUN_CMPCALC_JPN

Compensation, Base Compensation, Percentage Increase JPN, Populate Salary Increase Table, Generate Salary Increase Data, Generate Salary Increase Data

Enter the parameters for running the salary increase process and populating the Salary Increase Simulation Table.

Salary Increase Simulation JPN

SALINC_SIML_JPN

Compensation, Base Compensation, Percentage Increase JPN, Simulate Salary Increase

View the results of running the simulation process. All fields in the results grid are display-only, besides Adjustment Amount on the Changes tab, in which you can adjust the amount of an individual’s salary increase.

Salary Simulation Report JPN

RUN_SALREPORT_JPN

Compensation, Base Compensation, Percentage Increase JPN, Salary Simulation Report, Salary Simulation Report JPN

Run the (JPN) Salary Simulation report (CMP020JP) that displays the results of the Salary Increase Simulation process.

Load Salary Increase JPN

RUN_UP_SALINC_JPN

Compensation, Base Compensation, Percentage Increase JPN, Load Salary Increase, Load Salary Increase JPN

Update worker job compensation records with the results of the salary increase and adjustment results.

Click to jump to top of pageClick to jump to parent topicDefining Salary Increase IDs

Access the Salary Increase ID Table JPN page.

Calculation As Of Date

The effective date that the system uses to determine from which job compensation record it should get the worker’s current data to calculate new data. For example, if the worker’s review band earns a worker a 6 percent increase, the system must get the existing rate code amount to calculate the new rate code amount.

Salary Increase Date

This becomes the effective date of the new job record that the system inserts for the worker for the review-based increased amount. The action and reason are Pay Rate Change and Salary Increase by Percentage.

Comp Rate Code (compensation rate code)

Enter the rate code. It must be of the class Defined Range Pay (DFRPAY) and of the type Flat Amount.

You can add only one compensation rate code for each salary increase ID, and only one salary increase ID is associated with each simulation run. To run a simulation for a different comp rate code, you must define additional salary increase IDs.

Note. You can’t have more than one rate code of class DFRPAY on a single worker’s Job Data - Compensation record.

The process that populates the Salary Increase Simulation Table includes all workers in the groups that you specify who have this compensation rate code and the currency code and frequency set on the Compensation Rate Code Table for this rate code.

If you’ve changed the default currency code or frequency from that set on the compensation rate table in the workers’ job compensation record, those workers go into error and aren’t included in the simulation.

Apply Rounding At

This is the numerical “place” to apply the rounding rule you select.

Rounding Rule

Select the rounding rule for the simulation process based on this salary increase ID. Options are:

  • Round

  • Round Down

  • Round Up

Group ID

Enter the group IDs for the workers being included in this process.

You must enter at least one group ID to complete this process. If a worker in a group that you specify doesn’t have the compensation rate code that you specified for processing, the system skips the worker without processing.

Note. This salary update method retrieves the required percentage increase from the salary matrix table where you linked review bands to percentage increases, quartile by quartile.

Click to jump to top of pageClick to jump to parent topicProcessing Salary Increases

Access the Generate Salary Increase Data page.

Salary Increase ID

Enter the salary increase ID for which to run the simulation.

Calculation Number

Enter the number that identifies a particular simulation in a series that you might run for comparison purposes.

 

Note. If you try to run a simulation with a combination of salary increase ID, calculation number, and group ID for which results exist, you get a warning. If you proceed, the results of the previous simulation are overwritten. To add groups to or remove them from an existing simulation and maintain the results of the previous simulation, change the calculation number.

Select All Groups

Select to have the system populate the Group ID group box with all groups that you originally associated with this salary increase ID.

Group ID

If you don’t want to run the simulation for all the groups that you associated with this salary increase ID, clear the Select All Groups check box and enter only those groups to process.

 

Note. This process includes only workers with the single compensation rate code that’s associated with the salary increase ID, but only if their currency code and frequency are the same as the compensation rate code default.

Click to jump to top of pageClick to jump to parent topicRunning a Salary Increase Simulation

Access the Salary Increase Simulation JPN page.

Name and EmplID (employee ID)

Enter this information for a single worker if you’re viewing and possibly adjusting simulation results for one person.

Search Result Message

Displays the range showing on the page and the total of the search results.

Sort group by

EmplID (employee ID) and Name

Select to have the grid display simulation results by worker ID or worker name, respectively.

Simulation Statistics

The (bracketed) number for each Total field is used in the field description to identify where the derived results come from. The Amounts and Adjustments tabs indicate on which page the column appears.

Total Current Amount (1)

The total of the Amount Before Salary Increase column (Amounts).

Total Adjusted Amount (2)

The total of the Adjustment Amount column (Adjustments).

Average Percent Increase (3)

The average of the Salary Increase Percent column (Amounts) (or 5/1).

Adjusted Average Percent (4)

The average of the Adjusted Sal Inc Percent column (Adjustments) (or 6/1).

Total Calculation Incr Amount (total calculation increase amount) (5)

The total of the Amount of Salary Increase column (Amounts) (or 1 × 3).

Total Actual Increase Amount (6)

The Total Calculation Incr (increase) Amount plus Total Adjustment Amount (or 5 + 2).

Total Calculation New Amount (7)

The total of the New Salary Amount column (Adjustments) (or 1 + 5).

Total Actual New Amount (8)

The total of the Adjusted Salary Amount column (Adjustments) (or 7 + 2).

Note. Column order for grids may vary by implementation. All columns may not be visible. Use the page’s horizontal scroll bar as necessary to view all available columns.

Salary Details tab

EmpllD (employee ID)

Displays the IDs of all the workers in the group that you entered to access this page. You can have the display sorted by this first column. The worker ID is repeated on all the pages of this component.

Name

Displays the names of all the workers in the group that you entered to access this page. You can have the display sorted by this second column.

Empl Rcd Nbr (employment record number)

Displays each employment record number if it isn’t 0. Blank = record number 0, meaning that the worker has only one employment record.

Comp Rate Code (compensation rate code)

The compensation rate code associated with this salary increase ID.

Compensation Eff Sequence (compensation effective sequence)

Displays the compensation effective sequence that comes from the worker’s compensation record on the Job record.

Amounts tab

Amount Before Salary Increase

The worker’s salary before the simulation was run.

Review Band

Displays the review band that the worker’s review results indicate. The salary increases come from the increase percentages that you linked to review bands in the Salary Increase Matrix Table.

Salary Increase Percent

The increase in salary, expressed as a percentage of the Amount Before Salary Increase.

Amount of Salary Increase

The amount by which the Amount Before Salary Increase is increased as a result of running the salary increase process.

Adjustments tab

New Salary Amount

Displays the amount of the salary after the simulated increase: the Amount Before Salary Increase (Amounts) plus the Amount of Salary Increase.

Adjustment Amount

The only field available for entry in the otherwise display-only grid. You can manually adjust the New Salary Amount by adding or subtracting an adjustment amount here.

Note. If you change the value in this field, save before you move to the next set of records using the navigation buttons below the calculation number. If you don’t save, you receive a warning that your changes won’t be stored.

Adjusted Salary Amount

The system updates this field online according to any adjustments that you make. It’s the new salary amount after adjustment or the New Salary Amount plus or minus the Adjustment Amount.

Adjusted Sal Inc Percent (adjusted salary increase percentage)

The system updates this field according to any adjustments that you make. It’s the salary increase percentage after adjustment, calculated by:

(Adjusted Salary Amount / Amount Before Salary Increase − 1) × 100.

Click to jump to top of pageClick to jump to parent topicRunning the Salary Simulation Report

Access the Salary Simulation Report JPN page.

Salary Increase ID

Enter the salary increase ID you ran the simulation for and for which you want the results reported.

Calculation Number

Enter the calculation number of the particular simulation you want reported.

Select All Groups

Select this check box if you want the system to populate the Group ID section with all the groups you originally associated with this Salary Increase ID.

Group ID

If you don’t want to run the simulation for all the groups that you associated with this salary increase ID for this calculation number, clear the Select All Groups check box and enter only groups that are to be processed.

Click to jump to top of pageClick to jump to parent topicLoading Salary Increases

Access the Load Salary Increase JPN page.

Salary Increase ID

Enter the salary increase ID for which you ran the simulation and for which the results are to be loaded to worker job compensation records.

Calculation Number

Enter the calculation number of the particular simulation results to be loaded.

Select All Groups

Select to have the system populate the Group ID section with all the groups that you originally associated with this salary increase ID and calculation number combination.

Group ID

If you don’t want to run the simulation for all the groups that you associated with this salary increase ID for this calculation number, clear the Select All Groups check box and enter only groups that are to be processed.