Using Configurable Matrices

This chapter provides an overview of configurable matrices and discusses how to:

• Define sources for configurable matrices.

• Define results for configurable matrices.

• Define and maintain configurable matrices.

• Use special rules to create configurable matrices.

• Copy matrices.

Understanding Configurable Matrices

A configurable matrix is a special type of lookup table that can be designed and populated by the administrator. The administrator specifies the inputs (or criteria) that will be used as lookup variables and the outputs (or results) that the table will return for specific combinations of input values.

Examples of Configurable Matrices

The examples that follow illustrate the concept of matrices and their intended uses.

Simple Rate Matrix

Use this matrix to determine the compensation rate for a worker based on his department.

In this example, the single input is the Department of the worker, and the output is the Rate. If a worker is in Department 10012, then the pay rate is 10.00 USD per hour.

Matrix with Two Inputs and One Output

This matrix has two inputs and one output:

In this matrix, the rate is determined by a combination of the time in company and the risk level of the work site. A worker who has been with the company for 50 months and works at a Medium risk site will be compensated at the rate of 14.00 USD per hour.

Market Pay Matrix: Matrix with Multiple Outputs of Different Types

The outputs of a matrix can be of different types, and the following example is a matrix with multiple outputs, one of which is a percentage. You use this matrix to track the compensation rates for a job at various percentiles and different geographical areas. It also tracks rates for standard compensation figures, such as total cash compensation.

In this example, the only input is the geographical area; all other columns are outputs. You can associate this matrix with a specific job code, so that the compensation administrator can track market pay for that job code across different geographical regions.

Matrix with Calculated Results

You can embed calculations in the results returned by a matrix. In this example, the matrix returns rates calculated by applying a formula:

For example, if the worker's base salary is 10,000 USD and the worker is on Step 1, then this matrix will return a rate (Base Salary × 5%) = 10,500 USD.

Note. The system performs the appropriate checks to find the worker's current base salary. The base salary was not stored in the matrix.

Understanding Matrix Inputs and Outputs

This section discusses matrix inputs, outputs, and matrix evaluation rules for configurable matrices.

Matrix Inputs

Each matrix can have one or more inputs. These inputs are the search criteria against which you will evaluate a specific worker. The maximum number of inputs is 15. Each input is defined in the form of one or more source IDs.

Human Resources contains a number of predefined source IDs as system data. You can use those to build your configurable matrices. However, you can create also additional custom source IDs.

See Defining Sources for Configurable Matrices.

Matrix Outputs

The outputs of a matrix are available in the form of Result IDs. You can have a maximum of 30 outputs for one matrix. The outputs are categorized into result types, based on their data format or the rules used to derive the result.

Base Compensation contains a number of predefined Result IDs as system data. These results can be used as outputs for the configurable matrices. However, you can create additional custom result IDs.

See .

Matrix Evaluation Rules

Whenever the matrix is invoked, the system attempts to match the worker's data with keys in the matrix. The system checks all input variables against the keys defined for each input. The order of checking will be the same as the order in which the inputs were defined. At the first row where all input variables match the keys specified in the matrix, the system will return all result IDs for that row. When you are defining search keys, the system ensures that no rows are duplicated. You cannot have any blank search keys.

Using Wildcards as Search Keys

You can use wildcards when defining search keys. After you enter specific key values for one input, you can optionally add a wildcard key. If no explicit match is found against any of the other key values, then the wildcard key is considered a match. For example, assume you defined Dept ID as an input. You want to list specific non-zero rates for Dept IDs 101, 102, 103, and 104. However, for all other departments, you want a rate of 0. In this case, you would specify a total of five keys for the input, 101, 102, 103, 104, and '*' for the wildcard. Any worker not in Dept 101, 102, 103, and 104 would match the wildcard and would get a rate of 0. Using wildcards allows you to have a default rule defining what to do if the worker's data does not match any of the key values.

Understanding Matrix Types

This section discusses the three types of matrices you can create using the configurable matrices feature.

• Market pay matrix

  This matrix captures market pay information for a given job. The market pay matrix can then be associated with specific job codes by using the Associate Mkt Pay to Job Codes page (Set Up HRMS, Product Related, Compensation, Market Pay, Associate Mkt Pay to Job Code). You can also associate the matrix directly on the Market Pay Match page of the Job Code definition component (Set Up HRMS, Foundation Tables, Job Attributes, Job Code Table, Market Pay Match).

• Rate matrix

  This matrix is used to store compensation rates based on multiple criteria. You can then associate a rate matrix to a rate code defined on the Comp Rate Code Table page (Set Up HRMS, Foundation Tables, Compensation Rules, Comp Rate Code Table). The rate matrix can return compensation rates that are directly listed in the matrix or derived using formula-based result IDs.

• Salary increase matrix

  This matrix is used to store the salary increase guidelines, as percentages of base salary. These guidelines are usually based on the worker's performance ratings and ratios, such as Compa-Ratio and Percent-In-Range. You can attach this matrix to specific rate codes in a group budget (Compensation, Base Compensation, Group Budgets, Create/Approve Group Budget, Budget Components). When calculating the budget, the system applies the appropriate increases to workers based on the criteria in the matrix.

  Note. Depending upon the page, you can only associate a specific type of matrix to that page. For example, the system will only retrieve rate matrices when searching on a rate code definition page. Similarly, you can only associate market pay matrices to a job code.

Important! You cannot associate configurable matrices to seniority pay rate codes.

See Defining Rate Codes.

See .

See Also

Setting Up and Working with Market Pay

Understanding Matrix Displays

This section discusses how the system displays a configurable matrix.

Matrix Display

Within compensation processes, data is often presented and used in a two-dimensional table, or matrix form. An example is in salary increase guidelines, which store increase percentages for different performance ratings and percent-in-range ratios. How this data is presented affects how easily it can be understood. When defining inputs for a matrix, you can specify one of the inputs to be the column header instead of the row header. The following section explains this concept further.

Example: Displaying Inputs as Columns

Assume that you have two inputs (step and department) and one output (rate). The system can display the matrix in two ways.

Example 1: Each combination of inputs is like a row header.

Example 2: One input is a column header.

This display is easier to understand because the Department input was set to Column rather than to Row, which is the standard.

Defining Sources for Configurable Matrices

To define sources for configurable matrices, use the Define Sources (WCS_SOURCE_DEFN) component.

Note. You cannot create new source types.

This section provides an overview of source types, lists common elements, and discusses how to:

• Define sources based on addresses.

• Define sources based on dates.

• Define sources based on ratios.

• Define sources based on performance ratings.

• Define sources based on employee information.

• Define sources for related employee information.

• Define sources based on position information.

• Define sources based on related position information.

• Define sources based on geographical areas.

• Define sources based on salary grade step rates.

• Define sources based on length of time.

• Define sources based on supplied information.

• Define sources based on a matrix.

See Also

Understanding Source Types

This table describes the predefined source types that are available and shows you which type to use when defining your own source IDs. These sources types are system delivered:

Common Elements Used in this Section

Pages Used to Define and Maintain Sources for Configurable Matrices

Defining Sources Based on Addresses

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select ADDRESS as a Source Type when creating a new source.

You can create a source that refers to any address type (home, work, mailing, and so on) and any field (address line, city, state, country) in the address.

Defining Sources Based on Dates

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select DATES as a Source Type.

Type of Date

Select the date type for this matrix. Values are: Date of Last Increase: The date of the last increase, which is the Comp Rate on the worker's COMPENSATION record. Date of Last Var Comp Award: The date of last award paid out using the Variable Compensation functionality. Hire Date: The hire date on the EMPLOYMENT view, which is specific to Empl Record number. Seniority Date: The company seniority date on the EMPLOYMENT view. Start of Current Grade: The grade entry date on the worker's JOB record. Start of Current Job: The job entry date on the worker's JOB record. Start of Current Position: The position entry date on the worker's JOB record. Start of Current Step: The step entry date on the worker's JOB record. Termination Date: The termination date on the EMPLOYMENT view.

Defining Sources Based on Ratios

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select RATIOS as a Source Type.

The system will calculate the appropriate ratio for the worker dynamically at runtime. The system uses the salary ranges based on the effective date of the transaction.

Defining Sources Based on Performance Ratings

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select RATING as a Source Type.

Document Type	Select a performance review document type from the available values. The list of document types will change based on the effective date of the Source ID.
Element	Select the element that will define this source. The available values come from the EP_APPR record.

Defining Sources Based on Employee Information

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select EMPINFO as a Source Type.

Context

Select a value. The system will allow you to select an element that is available through one of these contexts. This is the list of contexts, along with sample list of elements that are available within each context: Effective Dated Personal Data: Full-time student, Highest Education Level. Employee Time Profile: Time Period ID, Rule Element, Time Reporter Status. General Employment Data: Date Last Worked, 5% Owner, Probation Date. Job History: Company, Business Unit, Labor Agreement, Salary Plan, Grade. Job Jr: Assignment ID, Category Rate, Intercompany Transfer Data. Names: First Name, Last Name, Middle Name, Prefix. Person Core Objects: Birth data. Person Org Assignments: Benefit Record, Organizational Instance.

Element

Select the field that will define this source. The prompt list is based on the selected context.

Defining Sources Based on Related Employee Information

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select EMPRELATED as a Source Type.

Click the folder icon in the tree to open the appropriate related table and then select the appropriate element by clicking the leaf node.

This tree allows you to derive a value from any table related to worker's Job record using the EmplID as a starting point. For example, if you want to use the Manager Level of the worker's Job Code as the source, you can link to it by opening the JOBCODE folder and clicking the Manager Level leaf node. You can use this source type to create source IDs for fields that are not available as system-defined source IDs.

Defining Sources Based on Position Information

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select POSINFO as a Source Type.

Element

Select the field that will define this source.

Defining Sources Based on Related Position Information

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select POSRELATED as a Source Type.

View various worker related information such as general employment data, job history, names, and so on.

Defining Sources Based on Geographical Areas

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select GEOGRAPHY as a Source Type.

This source type is used to create sources that will always refer to Geographical Area definitions. One system-defined Source ID, GEOGAREA exists; however, you can create another source if you want a different name and label.

Note. Key values are not automatically validated for geographical areas. However, you can specify the prompt table GEOGRAPHY_TBL and prompt field GEOGRAPHY_ID when you add GEOGAREA as the input in the matrix component.

Defining Sources Based on Salary Grade Step Rates

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select STEPRATE as a Source Type.

This source returns the standard compensation rate for a given grade and step within the worker's salary administration plan. This type of source can be used to create rate matrices where the rates are dependent upon or related to rates on one or more grades and steps in the worker's salary administration plan.

Defining Sources Based on Length of Time

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select TIMESPAN as a Source Type.

This source allows you to define as input the length of time elapsed between current (as of) date and a specified reference date. For example, if you want to create a rate matrix that will include pay rates based on how long the worker has been in the company, in that job, or in that grade, then you define a source of this type.

Defining Sources Based on Supplied Information

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select SUPPLIED as a Source Type.

Use this type of source when the component that will use the matrix will pass the appropriate Input value (for the worker) directly, so that there is no lookup to any table to derive the value.

Defining Sources Based on a Matrix

Access the Source Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Sources, Source Definition) and select MATRIX as a Source Type.

With this source, the system evaluates the key for the input dynamically by referring to another matrix and using one of the results from that matrix as the key value.

See Defining Inputs for Matrices.

Example: Health Benefits Rates Using a MATRIX Type Source ID

Suppose you are creating a matrix to determine health benefit allowance amounts. However, you want to base the health benefits on standard hourly rates for each department. If the hourly rates are below a certain amounts, then you will give health benefits. The matrix may look like this example:

In this case, you need a way to dynamically get hourly rates for the worker's department. A source of type Matrix is useful in this case. In the previous example, you define a source that will return the rate for the worker's department. You specify which matrix has department rates and which result ID from that matrix is the rate value.

In the health benefits table, the Std Hourly Rate would be defined using the DEPTRATE_MTX source ID.

Defining Results for Configurable Matrices

To define results for configurable matrices, use the Define Results (WCS_RESULT_DEFN) component.

This section provides an overview of results for configurable matrices, lists common elements, and discusses how to:

• Define results based on the SIMPLECHAR (simple character) result type.

• Define results based on the SIMPLENUM (simple number) result type.

• Define results based on the SIMPLEDATE (simple date) result type.

• Define results based on the INCRBYAMT (increment by amount) result type.

• Define results based on the PCNTOFBASE (percent of base) result type.

• Define results based on the THRESHOLD result type.

• Define results based on the SOURCE result type.

• Define results based on the MATRIX result type.

Understanding Results for Configurable Matrices

Results (result IDs) represent outputs for configurable matrices. A result ID is simply a standardized name for one of the outputs from a matrix. By using standardized names, the applications and components that query a matrix can know what set and type of results to expect after they perform a lookup. For example, if you expect to get a percentage value back, the name PERCENTAGE is more intuitive than NUMBER1. If you expect to get an amount that represents a compensation rate, the name COMPRATE is better than AMOUNT.

The system delivers result IDs, but you can also create new ones. The simplest result IDs are free-form values of type, character string, numbers, or dates. Using free-form values, you enter values into the matrix that are directly returned to the calling program when the matrix is evaluated. For example, in a rate matrix, the compensation rate can be stored as an AMOUNT result ID that has values of 10, 12, and so on. Note that currency and frequency concepts are derived automatically based on context. The matrix simply stores the numbers.

Advanced result types also exist. For these, the system performs a formula-based calculation or a lookup operation and returns the final value as the result.

See .

The four special result types are:

• INCRBYAMT (increment by amount)

  See Defining Results Based on the INCRBYAMT Result Type.

• PCNTOFBASE (percent of base)

  See Defining Results Based on the PCNTOFBASE Result Type.

• THRESHOLD

  See Defining Results Based on the THRESHOLD Result Type.

• SOURCE

  See Defining Results Based on the SOURCE Result Type.

Common Elements Used in this Section

Pages Used to Define and Maintain Results for Configurable Matrices

Defining Results Based on the SIMPLECHAR Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select SIMPLECHAR (simple character) as a Result Type.

This type of result ID stores simple character string values with an appropriate label. In this example, the result ID SURVEY_JOBCODE is being defined. This result ID can then be used in a market pay matrix so that compensation specialists can refer to market pay by job code. Since the job code is coming from a survey database, it is stored as a character string.

Defining Results Based on the SIMPLENUM Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select SIMPLENUM (simple number) as a Result Type.

This type of result stores simple numbers that represent different values. For example, the 50_PERC result ID can be used in salary increase guidelines matrices and in market pay matrices to track the 50th percentile values for different numbers, such as compa-ratios and base compensation market rates.

Defining Results Based on the SIMPLEDATE Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select SIMPLEDATE (simple date) as a Result Type.

This result type stores date values in the matrix. For example, you can use it to track the date of the surveys that are tracked in market pay matrices.

Defining Results Based on the INCRBYAMT Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select INCRBYAMT (increment by amount) as a Result Type.

Total Length	Enter the number of characters for the result ID.
Decimal Positions	Indicate how many decimal places to use for the number format.

Using the Increment by Amount Result Type

This result type uses the number entered as an amount to be applied to another result. It requires you to specify the target Result ID to which this amount will be applied. You can enter both positive and negative numbers, so you can increment or decrement the target value. For example, assume that you have a matrix for calculating rates based on Department. Each department has a fixed base rate (which can vary by department). However, you want to calculate the final rate as an increment of the base rate. In this case, you will have one Result ID called Base Rate (of type SIMPLENUM) and another Result ID called Final Rate (of type INCRBYAMT).

The matrix looks like this:

If a worker is in Dept 1010, the system will return 10 − 2 = 8.00 as the value in Final Rate result ID. Note that when you are defining the matrix, you entered a value of −2 in the cell for Final Rate, but the system uses that value as the amount to add and returns 8 in the same result ID at runtime. You do not need to define another result ID to hold the value from the calculation.

If a worker is in Dept 1040, the value in Final Rate result ID will be (12 + 1) = 13.00.

Defining Results Based on the PCNTOFBASE Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select PCNTOFBASE (percent of base) as a Result Type.

Total Length	Enter the total length of the number format.
Decimals	Enter the number of decimal places to use for the number format.

Example: PCNTOFBASE (percent of base) Result Type

This result type uses the number entered as a percentage to be applied to another result. You must specify the target result ID to which the percentage will be applied. For example, assume you have a matrix for calculating rates based on Department. Each department has a fixed base rate, which can vary by department. However, you want to calculate the final rate as a percentage of the base rate. In this case, you will have one result ID called Base Rate (type SIMPLENUM) and another result ID called Final Rate (type PCNTOFBASE).

This example illustrates a rate matrix using the PCNTOFBASE result type:

Using this example, if a worker is in Dept 1010, the system returns 10 × 85% = 8.50 as the value of the Final Rate result ID.

Note. When you defined the matrix, you entered a value, 85, for the Final Rate, but the system uses that as the percentage to apply, and it returns the value in the same result ID at runtime. You do not need to define another result ID to hold the value from the calculation.

If a worker is in Dept 1040, the value of the Final Rate result ID is 12 × 110% = 13.20.

Defining Results Based on the THRESHOLD Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select THRESHOLD as a Result Type.

This result type allows you to apply rounding based on threshold differences between a calculated value and a reference value. When used within a matrix, this result requires two other Result IDs as parameters. The system takes the first (calculated) result and subtracts it from the second (reference) result. The difference is compared to the amount in the threshold result. If the difference is less than the threshold amount, the matrix returns the reference value in the threshold result ID. If the difference is greater, the matrix returns the calculated value.

For example, assume that you are calculating increases in compensation rates based on salary steps, but you want to round up to the next step rate when the difference between the calculated rate and the next step rate is less than a specified threshold amount. Assume a worker is on Step 3 at the rate of 8.50 USD per hour. The rate for Step 4 is 9.00 USD. For all workers who get a raise such that their new rate is within 0.20 USD of 9.00 USD, you want to automatically set their rate to 9.00 USD. If the increase matrix gives the worker a 5 percent increase, the new rate is 8.925 USD. Since this rate is within 0.20 USD of the 9.00 USD rate for Step 4, the system returns a new rate of 9.00 USD.

Defining Results Based on the SOURCE Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select SOURCE as a Result Type.

Source ID

Select a source ID that this result ID will implicitly evaluate and return the source's value as the final result. The list of possible source ID values comes from the Sources Definition.

This type of result ID returns the value of a referenced source ID as its value. The final result is the value of the source. As an example, assume you needed to create a rate matrix for calculating bonuses as a percentage of workers' annual compensation rates. However, the bonus percentages will vary by department. Therefore, the single input to the matrix is Dept, and the two results are Annual Rate and Bonus Pct.

The matrix looks like this:

Since you do not know each worker's annual rates, you define one result ID of type of SOURCE, called ANNUAL_RATE_SOURCE, and associate it to the Source ID ANNUAL_RATE. Then, you define a second result ID of type PCNTOFBASE, called BONUS_PCT, which tracks the bonus percentages. You specify the ANNUAL_RATE_SOURCE result ID as the target result ID to which the bonus percentage is applied. When this matrix is evaluated, the following actions will occur:

1. Since Dept is the required input, the system looks up the worker's department (for example, 103).

2. The system looks up results for Dept 103.

3. For the Annual_Rate_Source result, the system looks up the ANNUAL RATE of the worker and returns that value (for example, 10,000 USD).

4. For the Bonus Pct result, the system applies the bonus percent, 5, to 10,000 USD and returns a value of 500 USD.

Defining Results Based on the MATRIX Result Type

Access the Result Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Results, Result Definition) and select MATRIX as a Result Type.

Matrix ID	Select the matrix on which this result should be based.
Matrix Result ID	Select a result ID (for the matrix) on which this result should be based.

This type of result uses one of the result IDs of another matrix as its value. When a matrix using this result is evaluated, the system evaluates the referenced matrix to get the final value. For example, assume that you want to set up a payment structure for health benefits, and you decide that the company will pay health benefits at 20 percent of the standard compensation rate by department. To determine a worker's health benefit rate, you need to determine their department's standard compensation rate. However, the standard compensation rate itself is dynamically set based on Salary Grade steps. Assume that the standard rate is derived using the KUR001 rate matrix, which has NEW_AMOUNT as the result. Then, the system would use the NEW_AMOUNT result of that matrix as the reference rate. The system can now apply a percentage of that result (using PCNTOFBASE) to get a final health benefit rate.

In this case, the Matrix ID is KUR001, and the Matrix Result ID is NEW_AMOUNT.

Defining and Maintaining Configurable Matrices

To define configurable matrices, use the Define Matrices (WCS_LK_TBL_DEFN) component.

This section lists common elements and discusses how to:

• Define matrices.

• Define inputs (source IDs) for matrices.

• Define matrix output (result IDs) information.

• Define search keys for configurable matrices.

• Load values from the prompt table.

• Enter data content fields.

• View matrix results.

Common Elements Used in this Section

Pages Used to Define and Maintain Configurable Matrices

Defining Matrices

Access the Matrix Definition page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Matrices, Matrix Definition).

Note. All matrices are created with a status of Inactive. You must change the status to Active to use them.

See Also

Setting Up and Working with Market Pay

Setting Up Rate Codes

Defining Inputs for Matrices

Access the Inputs page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Matrices, Inputs).

Matrix Inputs

Optional Prompting

If you want the ability to enter search keys from a prompt table, you can use this section to specify the table, the field, and, if appropriate, the setID.

Note. The system does not enforce that search keys must exist in that table. You are allowed to enter search keys that are new and do not exist in any table.

Sources for Resolving Input

Range Rules

The following example illustrates how ranges work. Assume that Percent-In-Range is the input. The typical ranges are 0–40%, 41–60%, 61–80%, and 81–100%. For this example, we will only use the last 3 ranges (41–100%). When defining these ranges in a configurable matrix, we only enter the range breakpoints, which in this example are 40, 60, 80, and 100. The system interprets these breakpoints as defining the following ranges:

Analyzing the Lookup Methods

Assuming a worker has a value of 45 percent:

• If the method is Use Higher Limit, the system determines that 60 is the first breakpoint higher than 45, and it will use 60.

• If the method is Use Lower Limit, the system determines that 40 is the first breakpoint lower than 45, and it will use 40.

• If the method is Use Nearest Limit, the system determines that 45 is closest to 40, and it will use 40. (If the worker's percent-in-range had been 55, the system would have used 60.)

When Outside Range

Special Processing

Example Interpolating Result IDs

For this example, assume that you have a matrix with the same percent-in-range breakpoints and one output that is a rate.

Note. All values are percentages, unless noted otherwise.

If you assume that the worker is on Step 1 and the Percent-in-Range (PIR) is 50, then the rate could be 40 or 30. However, if the Interpolate Result IDs option is selected, then the system would calculate the ratio of worker's value (50) to the lower limit (40), and use that ratio on the lower rate (40) and return a rate of 35. The worker's PIR of 50 is exactly between the breakpoints 40 and 60; therefore, the system calculates a rate exactly between the rates of 40 and 30.

If the PIR were 55 (75 percent of the numerical difference between 40 and 60), then the system would return 32.50 as the 75 percent rate value between 40 and 60.

Defining Matrix Output Information

Access the Outputs page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Matrices, Outputs).

Note. Results that are available on this page will differ depending upon the matrix type.

Matrix Outputs (Result Columns)

Defining Search Keys for Configurable Matrices

Access the Search Keys page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Matrices, Search Keys).

Use this page to enter the key values against which worker data is matched. In the previous example, the system checked for worker's performance ratings to be 1, 2, 3, or 4.

Note. For market pay matrices, you are allowed to create the matrix without specifying any search keys and output data values, which is useful when you intend to load data into the matrix from a flat file. In this case, you define the matrix, but you do not specify search keys and output data. You can still update the status to Active. Then, you can load data into it from a flat file. However, if you change the status of the matrix to Active and you have not defined any search criteria or values, you will receive a warning.

For more options, review the sections about market pay matrices for an explanation of how to load data into a matrix.

See Setting Up and Working with Market Pay.

Matrix Definition

Search Key Series

Example: Generating Key Combinations

For example, if you had one input as Dept with values 101, 102, 103, and 104, and another input of Job Risk with values of High, Med, or Low and a single output of Rate, then the system would generate the following table of combinations automatically:

Now you can enter the rates, and you do not need to manually enter Dept IDs or Risk levels.

Loading Values from the Prompt Table

Access the Load Configurable Matrix Keys page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Matrices, Search Keys). Click the Select Values from Prompt Table link.

To load values from a specific prompt table:

1. Select a value in the Prompt Table field.

2. Select a value in the Prompt Field field.

3. Click the Search button.

4. In the Select Key Values To Load grid, select the check boxes for the values you want to load.

5. Click OK.

Entering Data Content Fields

Access the Data Content page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Matrices, Data Content).

This page lists the combinations of search keys for all inputs that the matrix will evaluate. For each combination, it lists all outputs fields. You can add the character, date, or numerical values of each output here. The columns that appear on this page vary depending on the fields you define on the Inputs page and Outputs page. The columns to the left of the Default check box are defined on the Inputs page. The columns to the right of the Default check box are defined on the Outputs page.

Note. All inputs appear to the left of the Default column, and all outputs appear to the right of the Default column.

Viewing Matrix Results

Access the View page (Set Up HRMS, Common Definitions, Configurable Matrices, Define Matrices, View).

After you enter all data content for outputs, you must save the matrix. You can view the matrix on this page only after you have saved it.

When you click the Display Saved Matrix button, the results that are generated are from the last saved version of the matrix.

Important! This page will display only the last saved version of the matrix.

Using Special Rules to Create Configurable Matrices

Special rules apply when you create rate matrices and salary increase guidelines matrices, and specific result ID values must exist in each type of matrix in order for the system to be able to process the matrix. Special rules are required because the components where these matrices are invoked will look for and process specific result IDs. If the correct result IDs do not exist, then the calling component will not know how to process the output.

Rate Matrix

This table lists the result IDs that must exist in a rate matrix that you plan to associate with a rate code. The list of expected result IDs is based on the rate code type:

Note. You do not need every result ID for each rate code type. You only need one of these result IDs for each.

If you create a rate matrix that uses calculations, such as result IDs with the type of PERCENT_TO_APPLY, INCREMENT_PERCENT, and so on, you must select the Do not return Results check box for all other result IDs. This selection is necessary because the system requires that a rate matrix attached to a rate code can have only one result ID returned.

Salary Increase Matrix Attached to a Group Budget

The result IDs in the matrix must match the rate code type. This table illustrates the result IDs that are allowed based on rate code type:

When the salary increase matrix is attached to a group budget, the system always looks for the DEFAULT_PERCENTAGE, DEFAULT_AMOUNT, or DEFAULT_POINTS result ID, and it will use that result ID to calculate the budget or assign increases.

However, the system performs special processing when the matrix includes both DEFAULT_PERCENTAGE and AMOUNT result IDs. In this case, the AMOUNT result ID is treated like a lump sum increase amount. Since every row will have both a default percentage and an amount result, the system will first check to see if the value for AMOUNT is greater than 0. If the value is greater than 0, the system uses that value as a lump sum increase amount in the group budget. If the AMOUNT value is 0, then the system uses the value for DEFAULT_PERCENTAGE as a change percentage. This selection allows you to create a salary increase matrix that handles the cases for which a worker's compa-ratio or percent-in-range values are outside the standard guidelines.

This example illustrates a salary increase matrix that includes percent-in-range values that are outside the standard guidelines:

Note that the matrix includes an explicit breakpoint with a Percent in Range (PIR) value of 0. This breakpoint is required to handle all workers whose PIR is negative, as compared to their salary range. A breakpoint with a value of 1000 also exists. This breakpoint is required to handle all workers whose PIR is greater than 100. The value 1000 is an arbitrarily high value chosen to ensure that all possible PIR values greater than 100 are captured.

Note how the LumpSum values are non-zero only for breakpoints 0 and 1000. All other breakpoints have LumpSum=0. This setting means that a worker whose PIR is between 0 and 100 will get increases based on the DEFAULT_PERCENTAGE guideline, while those whose PIR is outside the standard range (less than 0 or greater than 100) will get a flat amount increase based on the LumpSum AMOUNT guideline.

Copying Matrices

This section discusses how to copy matrices.

Page Used to Copy Configurable Matrices

Copying Matrices

Access the Copy Matrix page (Set Up HRMS, Common Definitions, Configurable Matrices, Copy Matrix).

To copy a matrix:

1. Select the matrix that you want to copy from the Available Matrices grid.

2. In the Copy To group box, enter values in the Matrix Name, Effective Date, Status, and Description fields for the new matrix.

   Note. The default status is Inactive, but you can change it to Active. However, if the source matrix is Inactive, then you cannot change the copy status to Active.

3. In the Matrix Components To Copy group box:

   • Select Copy Structure Only to include just matrix details, input and output definitions.

   • Select Copy Structure and Keys to include the structure plus all search key values for every input.

   • Select Copy Structure, Keys, and Data to clone the entire matrix.

4. Click the Copy Matrix button to create the copy.

   You will get a confirmation message and then see a new link labeled "Edit New Matrix <<matrix name>>. Click this link to begin editing the new matrix.