Individuals, Value Sets, or Other Groups Included or Excluded in HCM Groups

Decide group membership by adding individuals, value sets, and other groups with either Include or Exclude membership statuses. For example, to create a larger group that includes the Hourly Marketing group, add Hourly Marketing with the Include membership status.

To create a group that includes members using a value set, first create the value set. You can include any individual assignment or payroll attributes in your value set queries and filters.

Example

You create the All Part-Time Employees with an Annual Salary Basis value set that contains 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 example query, 'PR' identifies the Part-Time Regular employment category. Depending on the status that you use when adding the value set, the group includes or excludes individuals that match the query.