Symptom

﻿What is a Attribute Based Pay Matrix?

Environment

Compensation

Resolution

A Salary Pay Matrix is a table that defines ranges of pay based on grade level, and up to three additional attributes (such as country, city, job level, etc.). Pay matrices define the minimum, midpoint, and maximum pay levels for each pay grade and are required for compa-ratio and range penetration calculations.

Managing Pay Matrices

How do I create a new Pay Matrix for my upcoming compensation cycle?

The best practice is to always create a new Pay Matrix for each Compensation plan year and not to update the table referenced by previously launched forms. Updates to a Pay Matrix after forms are launched are dynamic. Any changes to the table will impact in-progress and completed forms linked to that table.

Scroll to the bottom, Click Export to download and save the table to a local drive.

Step 2: Create New Table.

• From the screen shown above, click Up to all pay matrices to return to Manage Salary Pay Matrix page.

• Type the Name and Description of the new Pay Matrix.

• Determine whether the pay values in the pay matrix will be reflected in Functional Currency (which is defined for the Compensation Plan Template) or by local currency code.

• Click Create.

Update data in a Pay Matrix table

(Admin> Compensation > Manage Salary Pay Matrices)

• Click on the table name that you wish to update.

• Browse to your saved file.

• For Local Currency table, indicate whether you will import a full file or for a single currency code.

– If you select the second option, then the records in the import file will only replace those records in the current pay matrix with the same currency codes as those in the import file. The records in the import file can then only have one currency.

• Click Import

• Note that updates are DYNAMIC and will update previously created forms (including completed forms) referencing this Pay Matrix.

Additional Information about Pay Matrix Tables

Import file should be in csv format with a single header row, with the headers and in the order shown here:

Sample files are can be downloaded below.

Pay matrices contain the following data:

Pay grade (string value).

Ascending, positive, non-zero values for minimum, midpoint, and maximum; and

Promotable = “true” unless instructed by configuration consultant.

Up to three attributes to further associate pay grade to specific employees (* is used as a “wildcard” value, as well as if attributes are not used).

Information for Local Currency Pay Matrices

The order of the import file will matter: Records with the same currency should be grouped together and should be continuous in the import file.

Currency code should appear in lexicographical order.

Records for the functional currency should appear in the end of the file.

Currency code “*” represents functional currency. This would apply if you do not specify a local currency in the currency column, then the pay guide would be interpreted in functional currency.

Helpful Information

The link between each employee and salary grade (or pay grade) is done using the Paygrade column in your Salary Pay Matrix file and PAYGRADE column in your UserDirectory file in the Compensation data part.

PAYGRADE: PAYGRADE column size limit is up to 256 single byte characters, but recommended size of less than 30 characters to prevent latency issues. This size limit cannot be changed.

To get the UserDirectory with Compensation data, you need to go to Admin Tools > Manage Users > Employee Export.