Create an HCM Group with a Value Set to Use in Worker Time Profiles

Here's how you can create an HCM group using a value set. You can use these groups in worker time entry, processing, and device processing profiles.

1. Create the value set. For example, you create the All Part-Time Workers with an Annual Salary Basis value set that includes this query:

    SELECT ASG.PERSON_ID
     FROM  PER_ALL_ASSIGNMENTS_M ASG
         , CMP_SALARY SAL
         , CMP_SALARY_BASES SB
         , HR_LOOKUPS EMP_CAT
    WHERE ASG.ASSIGNMENT_ID = SAL.ASSIGNMENT_ID
      AND SAL.SALARY_BASIS_ID = SB.SALARY_BASIS_ID
      AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE
      AND SYSDATE BETWEEN Sal.Date_From AND SAL.DATE_TO
      AND ASG.PRIMARY_FLAG = 'Y'
      AND ASG.EMPLOYMENT_CATEGORY = EMP_CAT.lookup_code
      and emp_cat.lookup_type = 'EMP_CAT'
      and emp_cat.lookup_code = 'PR'
      and sb.name = 'Annual Basis'

   In this query, 'PR' identifies the Part-Time Regular employment category.

   Go to Setup and Maintenance > Workforce Deployment > Time and Labor > Time and Labor Value Sets.

2. Create the HCM group.
   1. Go to Setup and Maintenance > Workforce Deployment > Time and Labor > HCM Groups.
   2. Complete the required and relevant optional group information.
   3. In the Include or Exclude Groups section, add the value set and specify whether to include or exclude members the value set identifies.
   4. Save your changes and close the page.
3. Refresh the group membership.
   1. Select the group to refresh.
   2. Select the current date as the evaluation date.
   3. Submit the refresh process.