Search Results hr_assignment_set_criteria




Overview
Explore in AI Chat

Overview

The HR_ASSIGNMENT_SET_CRITERIA table is a core data structure within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. Its primary function is to store the detailed selection criteria that define an Assignment Set. An Assignment Set is a named group of employee assignments, used extensively for security and reporting purposes to restrict data access to specific populations. This table operates as a child entity, where each record represents a single logical rule or criterion that, when combined with other criteria in the same set, determines which employee assignments are included. It is fundamental to the implementation of Security Profiles and other population-based filtering mechanisms in Oracle HRMS.

Key Information Stored

The table's structure is designed to capture the components of a selection criterion. The metadata indicates a composite primary key consisting of LINE_NO and ASSIGNMENT_SET_ID. The ASSIGNMENT_SET_ID is a foreign key linking the criterion to its parent definition in the HR_ASSIGNMENT_SETS table. The LINE_NO column sequences multiple criteria within a single set, allowing for ordered evaluation. While the provided metadata does not list all columns, typical columns in this table (based on its function) would include fields to specify the criterion type (e.g., based on Organization, Position, Payroll, Grade), the comparison operator, and the specific value or range of values to be matched against an employee's assignment attributes.

Common Use Cases and Queries

The primary use case is the administration and auditing of Security Profiles. When a user's responsibility is secured by a Security Profile, the underlying Assignment Set and its criteria in this table control which employee records the user can view or process. Common queries involve identifying the criteria for a specific Assignment Set or tracing security access. A typical analytical query would join this table to its parent.

  • Listing all criteria for a known Assignment Set ID:

    SELECT line_no, criterion_type, operand, comparison_operator
    FROM hr_assignment_set_criteria
    WHERE assignment_set_id = 1001
    ORDER BY line_no;

  • Finding all Assignment Sets that use a specific organization as a criterion:

    SELECT ac.assignment_set_id, aset.set_name
    FROM hr_assignment_set_criteria ac, hr_assignment_sets aset
    WHERE ac.assignment_set_id = aset.assignment_set_id
    AND ac.criterion_type = 'ORG'
    AND ac.operand = '<organization_id>';

Related Objects

This table has direct and critical dependencies within the HR schema. As per the metadata, its principal relationship is defined by a foreign key constraint to the HR_ASSIGNMENT_SETS table (HR_ASSIGNMENT_SET_CRITERIA.ASSIGNMENT_SET_ID). HR_ASSIGNMENT_SETS is the parent table storing the header information for the Assignment Set, such as its name and description. Furthermore, Assignment Sets defined using these tables are consumed by the Security Profile setup (via tables like PER_SECURITY_PROFILES) and are integral to the population of key HR views like PER_ALL_ASSIGNMENTS_M and PER_ALL_PEOPLE_F when accessed through secured responsibilities. APIs such as HR_ASSIGNMENT_SET_API may be used to programmatically create or maintain these criteria.