Managing Salary Range Tables

Plan-specific data used in Compensation plans is derived from different compensation tables.

These tables include salary range, currency conversion, and look up tables. The tables can be shared by multiple plans; however, it is best practice to create new tables for each new compensation cycle as changes to a table used in a previous cycle will update in-progress and completed forms.

Salary range table (or Salary Pay Matrix) defines the minimum, the mid-point, and the maximum salary for each grade level. It is used to calculate range penetration and comp-ratio.

Range Penetration is commonly used by companies concentrating on minimums and maximums of a range, as those using lumpsum payments.

Compa-ratio is for companies concentrating on midpoints and market position.

The table also denotes if a grade level is promotable. In addition, you can use up to three available attributes to match ranges on multiple fields. For example, the range can match on Pay Grade and Country, or Pay Grade, Job Code, and Location.

The salary pay matrix is defined in a CSV file. Creating a new pay matrix requires uploading a new CSV file with the following fields populated, as determined by your organization:

• Currency (only if uploading ranges in local currency)
• Pay Grade
• Minimum
• Mid-point
• Maximum
• Promotable flag
• Attribute1
• Attribute2
• Attribute3

Be sure that each pay grade has a minimum and a maximum value and that the mid-point doesn’t equal zero. It's also recommended to have the spread consistent from the mid-point as this spread allows meaningful calculations on minimum and maximum or quartile, if needed.

The promotable flag is used for manual promotion; TRUE/FALSE indicates if a pay range can be used or not. Generally, it's left as TRUE even if manual promotion isn't in use.

Pay range can be further mapped to customer-specific requirement, aside from the Paygrade. For example, paygrade 1 in New York has a different min-max from the paygrade 1 in California. In this case, additional attributes can be used to accommodate such requirements.

Salary range table (or Salary Pay Matrix) defines the minimum, the mid-point, and the maximum salary for each grade level. It is used to calculate range penetration and comp-ratio.

Range Penetration is commonly used by companies concentrating on minimums and maximums of a range, as those using lumpsum payments.

Compa-ratio is for companies concentrating on midpoints and market position.

The table also denotes if a grade level is promotable. In addition, you can use up to three available attributes to match ranges on multiple fields. For example, the range can match on Pay Grade and Country, or Pay Grade, Job Code, and Location.

• Compensation Tables: Plan-specific data in Compensation Plans is sourced from tables like salary range, currency conversion, and lookup tables, which can be shared across multiple plans but should be uniquely created for each cycle to avoid affecting in-progress or completed forms.

• Salary Range Table: Defines minimum, mid-point, and maximum salaries for each grade level, essential for calculating range penetration and compa-ratio, which aids companies in evaluating salary standards relative to market and organizational benchmarks.

• Attributes and Mapping: Salary tables can incorporate up to three attributes for matching ranges across fields, such as pay grade, country, job code, and location, accommodating diverse pay requirements like regional variations within the same grade.

• CSV File Structure: The pay matrix is defined in a CSV file requiring populated fields like currency, pay grade, minimum, mid-point, maximum, promotable flag, and attributes, ensuring consistent value spreads and meaningful calculations for salary assessments.