- 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.
• Legacy Admin Tools> Compensation Administration> Manage Salary Pay Matrices.
• One Admin> Compensation> Manage Salary Pay Matrices.
Step 1: Export the Currency table used in previous cycle.
• Click on Name to view the 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).
- Pay grade (string value).
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.
Connecting Matrix to Program
- Go to Admin tools > Compensation Plan Templates > Select your plan > Template Information > Select Salary Pay Matrix.
- Troubleshooting Pay Guide issues Integrated with EC see: Top 10 Troubleshooting Tips for Compensation-Employee Central Pay Guide Integration.
- 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.
- Include User Compensation Data (Not Applicable when exporting users in "Short format").
- Include imported field-level eligibility fields with system default import Keys.
- Include imported compensation field(s) (and planner flag if applicable) defined for the selected compensation form template(s) below. Select your Compensation Plan Template in the box below and click on the Export Users button.
Download your UserDirectory file, open it and look for PAYGRADE column.
This is where you need to put a PAYGRADE value for each employee (matching your Salary Pay Matrix).
- Here is how compa-ratio calculation works:
Compa-ratio =Salary/(Salary Pay Matrix Mid Point).
- Please be sure that each user has a valid Salary in the UserDirectory column SALARY and a valid pay grade in PAYGRADE.
KBA , sf compensation cycle preparation , sf compensation manage data , LOD-SF-CMP , Compensation Management , How To