Skip to Main Content
Return to Navigation

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:

Pages Used to Define and Maintain Configurable Matrices

Page Name

Definition Name

Navigation

Usage

Matrix Definition

WCS_LK_TBL_DEFN

select Set Up HCM, then select Common Definitions, then select Configurable Matrices, then select Define Matrices, then select Matrix Definition

Define and maintain matrices.

Inputs

WCS_LK_TBL_INPUTS

select Set Up HCM, then select Common Definitions, then select Configurable Matrices, then select Define Matrices, then select Inputs

Define inputs to the configurable matrix.

Outputs

WCS_LK_TBL_OUTPUTS

select Set Up HCM, then select Common Definitions, then select Configurable Matrices, then select Define Matrices, then select Outputs

Define outputs of the matrix.

Search Keys

WCS_LK_TBL_KEYS

select Set Up HCM, then select Common Definitions, then select Configurable Matrices, then select Define Matrices, then select Search Keys

Specify the search keys to be used to match worker data.

Load Configurable Matrix Keys

WCS_LK_TBL_KEY_SEC

Click the Select Values from Prompt Table link on the Search Keys page.

Automatically load search keys for specific sources using a prompt table.

Data Content

WCS_LK_TBL_DATA

select Set Up HCM, then select Common Definitions, then select Configurable Matrices, then select Define Matrices, then select Data Content

Enter values for the output data.

View

WCS_LK_TBL_VIEW

select Set Up HCM, then select Common Definitions, then select Configurable Matrices, then select Define Matrices, then select View

View the matrix as of the last saved version.

Common Elements Used in this Section

Matrix Definition Page

Use the Matrix Definition page (WCS_LK_TBL_DEFN) to define and maintain matrices.

Image: Matrix Definition page

This example illustrates the fields and controls on the Matrix Definition page.

Matrix Definition page

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

Inputs Page

Image: Inputs page

This example illustrates the fields and controls on the Inputs page.

Inputs page

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:

Range Breakpoints

Range Breakpoints are equal to

40

All values below 40, up to and including 40.

60

All values greater than 40, up to and including 60.

80

All values greater than 60, up to and including 80.

100

All values greater than 80, up to and including 100.

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.

Step

40

60

80

100

1

40

30

20

10

2

50

40

30

20

3

60

50

40

30

4

70

60

50

40

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.

Outputs Page

Use the Outputs page (WCS_LK_TBL_OUTPUTS) to define outputs of the matrix.

Image: Outputs page

This example illustrates the fields and controls on the Outputs page.

Outputs page

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

Matrix Outputs (Result Columns)

Search Keys Page

Use the Search Keys page (WCS_LK_TBL_KEYS) to specify the search keys to be used to match worker data.

Image: Search Keys page

This example illustrates the fields and controls on the Search Keys page.

Search Keys page

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 Understanding 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:

Dept

Risk

Rate

101

Low

0

101

Med

0

101

High

0

102

Low

0

102

Med

0

102

High

0

103

Low

0

103

Med

0

103

High

0

104

Low

0

104

Med

0

104

High

0

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

Load Configurable Matrix Keys Page

Use the Load Configurable Matrix Keys page (WCS_LK_TBL_KEY_SEC) to automatically load search keys for specific sources using a prompt table.

Image: Load Configurable Matrix Keys page

This example illustrates the fields and controls on the Load Configurable Matrix Keys page.

Load Configurable Matrix Keys page

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.

Data Content Page

Use the Data Content page (WCS_LK_TBL_DATA) to enter values for the output data.

Image: Data Content page

This example illustrates the fields and controls on the Data Content page.

Data Content page

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.

View Page

Use the View page (WCS_LK_TBL_VIEW) to view the matrix as of the last saved version.

Image: View page

This example illustrates the fields and controls on the View page.

View page

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.