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.
Pages Used to Define and Maintain Configurable Matrices
Page Name 
Definition Name 
Navigation 
Usage 

Matrix Definition 
WCS_LK_TBL_DEFN 

Define and maintain matrices. 
Inputs 
WCS_LK_TBL_INPUTS 

Define inputs to the configurable matrix. 
Outputs 
WCS_LK_TBL_OUTPUTS 

Define outputs of the matrix. 
Search Keys 
WCS_LK_TBL_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 

Enter values for the output data. 
View 
WCS_LK_TBL_VIEW 

View the matrix as of the last saved version. 
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.
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.
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 PercentInRange 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 percentinrange had been 55, the system would have used 60.)
When Outside Range
Special Processing
Interpolate Result IDs 
Use this option if you want the system to calculate and return a numerical value that is proportional to the values tied to specific breakpoints. 
Example Interpolating Result IDs
For this example, assume that you have a matrix with the same percentinrange 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 PercentinRange (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.
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.
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.
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.
To load values from a specific prompt table:
Select a value in the Prompt Table field.
Select a value in the Prompt Field field.
Click the Search button.
In the Select Key Values To Load grid, select the check boxes for the values you want to load.
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.
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.
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.