Search Results hr_assignment_sets




Overview
Explore in AI Chat

Overview

The HR_ASSIGNMENT_SETS table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module. It serves as a repository for the definitions of assignment sets, which are reusable, formula-based criteria used to identify and group specific employee assignments. These sets are fundamental for processing and reporting across various HR and Payroll functions, enabling batch operations on a defined subset of the workforce rather than the entire population. The table's primary role is to store the master definition—including the name, type, and associated business group—for each assignment set, which can then be referenced by numerous transactional and reporting processes.

Key Information Stored

The table stores the metadata that defines an assignment set. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships indicate critical fields. The ASSIGNMENT_SET_ID column is the unique primary key identifier. The BUSINESS_GROUP_ID column, which has a foreign key relationship to HR_ALL_ORGANIZATION_UNITS, anchors the set to a specific business group for security and data partitioning. Other essential columns typically include the assignment set name, a descriptive code, the set type (e.g., static or dynamic), and the identifier for the associated FastFormula that contains the actual selection logic. The table does not store the list of specific assignments; that dynamic list is generated at runtime by evaluating the stored formula criteria.

Common Use Cases and Queries

Assignment sets are pivotal for payroll processing, mass updates, and targeted reporting. A common use case is defining the population of employees for a payroll run, where the PAY_PAYROLL_ACTIONS table references an ASSIGNMENT_SET_ID. They are also used for running concurrent processes like mass salary adjustments or benefit enrollments for a specific department or job category. A typical reporting query might join HR_ASSIGNMENT_SETS to related criteria or amendment tables to audit set definitions.

  • Sample Query to List Assignment Sets: SELECT assignment_set_id, assignment_set_name, business_group_id FROM hr.hr_assignment_sets WHERE business_group_id = :p_bg_id;
  • Use Case: A payroll manager selects a pre-defined "US Monthly Salaried Employees" assignment set when submitting the monthly payroll process, ensuring only eligible assignments are processed.

Related Objects

As indicated by the foreign key metadata, HR_ASSIGNMENT_SETS is a central object with several key dependencies. The table HR_ASSIGNMENT_SET_CRITERIA stores the detailed selection rules (criteria) that comprise the set's formula. HR_ASSIGNMENT_SET_AMENDMENTS tracks changes or overrides made to the base set definition. Crucially, the PAY_PAYROLL_ACTIONS table references HR_ASSIGNMENT_SETS, linking each payroll run to the specific group of assignments being processed. The table is also linked to HR_ALL_ORGANIZATION_UNITS via the BUSINESS_GROUP_ID, enforcing multi-org security.