As part of the setup of your collective agreement entitlement items you may need to use value sets in order for your entitlement items to perform correctly.

Item Value Sets

If you are creating an entitlement item that populates one of the fields on the assignment included in the table below you need to select the corresponding item value set. This is so that when the entitlement item is selected in the Collective Agreement Entitlements window the values field displays a drop-down list of valid values.

The following table describes the fields on the assignment and the corresponding item value set:

Item Value Sets

In addition to these a CAGR_YES_NO value set is provided to be used where the valid value for a field is Yes or No, or the field uses a check box, for example Union Member.

You can also use these supplied value sets as examples to set up your own should you need to. For example, if you want to create a value set to write a value to a descriptive flexfield column, you can define a value set that enforces the same validation that is used by the descriptive flexfield.

Beneficial Rule Value Sets

For entitlement items where the most beneficial value cannot be determined from the value itself, but can be determined from some other value associated with it, you can define a value set to enable the application to do this. An example of this would be grades where you can use the sequence number associated with a grade to determine which is most beneficial. This is presuming that you have set up your grades so that the higher the sequence number, the better the grade.

An example value set, CAGR_BR_GRADE has been supplied for you to use as a template for creating your own value sets.

Setups for Collective Agreement Value Sets

In order for the value set to work correctly with the collective agreement, it must conform to the following rules:

• The item value set name must begin with CAGR_

• The beneficial rule value set name must begin with CAGR_BR

• The value set must be defined with a validation type of Table.

• The value set must return two values, one ID and one value or description.

• The following syntax is to be used if business_group_id is required in the sql. This example is for grades:

  Where business_group_id =  $PROFILES$.PER_BUSINESS_GROUP_ID AND GRADE_ID in ()

  The important part of this syntax is that the ID column is restricted to a set of values that are inserted within the brackets. If the brackets are not there, the value set will not work.

Example Entitlement Setups

The following give an example setup for each of the categories supported in Oracle HRMS.

Assignment Category Example

Imagine that the notice period for employees is based on their employee category as shown in the following table:

Assignment Category

To represent these collective agreement terms in Oracle HRMS you must complete the following steps:

1. Create an entitlement item called Notice Period and associate it with the Notice Period field.

2. Create two eligibility profiles based on the employment factor of Employee Category. In one select the employee category of Blue Collar and in the other select the employee category of White Collar.

3. Assuming you have already created your collective agreement, select the Notice Period entitlement item in the Collective Agreement Entitlements window and define the values for each of the eligibility profiles. Against White Collar, enter 3, and against Blue Collar, enter 2. Use the Default profile name to define the notice period of one month for all other employees.

Pay Scales Example

Imagine your enterprise uses the salary scale shown in the following table where employees' salary is based on their job and grade:

Pay Scales

To represent these collective agreement terms in Oracle HRMS you must complete the following steps:

1. Define jobs called Manager and Executive.

2. Define the grades M1, M2 and E2

3. Define a pay scale with points 1.1 through to 3.2.

4. Define a scale rate to associate the correct salary value with each point for the pay scale.

5. Define a grade scale to associate each grade to the correct points.

6. Create an entitlement item called Pay Scale and associate it with the Spinal Point field.

7. Create two eligibility profiles based on the employment factor of Job. In one select the job of Manager and in the other select the job of Executive.

8. Assuming you have already created your collective agreement, select the Pay Scale entitlement item in the Collective Agreement Entitlements window.

For each of the rows in the table you define a row in the Pay Scales tab. For the first row you would select the Manager eligibility profile, the grade M1, and the step 1.1.

Payroll Example

Imagine your enterprise uses the hourly rates shown in the following table where employees' rates are based on their grade:

Payroll

To represent these collective agreement terms in Oracle HRMS you must complete the following steps:

1. Define the grades A1 through to A3

2. Ensure the input values, element links and element entries have been defined for the Basic Salary Rate and Overtime elements.

3. Create two entitlement items, one called Standard Hourly Rate associated with the Basic Salary Rate element, and another called Overtime Hourly Rate associated with the Overtime element.

4. Create three eligibility profiles based on the employment factor of Grade. Select A1 in the first, A2 in the second, and A3 in the third.

5. Assuming you have already created your collective agreement, select the Standard Hourly Rate entitlement item in the Collective Agreement Entitlements window.

For each of the rows in the table you define a row in the values tabbed region. For the first row you would select the A1 Grade eligibility profile and enter the value of 7.50.

6. Select the Overtime Hourly Rate entitlement item in the Collective Agreement Entitlements window.

For each of the rows in the table you define a row in the values tabbed region. For the first row you would select the A1 Grade eligibility profile and enter the value of 9.00.