Results for “hr_assignment_set_criteria”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR_ASSIGNMENT_SET_CRITERIA is a Human Resources (PER) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores the individual filtering criteria that together define an assignment set. An assignment set is a reusable grouping of employee assignments that Oracle EBS uses to scope processes, reports, and security. Each row in HR_ASSIGNMENT_SET_CRITERIA represents one condition (a line) within a set definition, expressed as a left operand, an operator, and a right operand, optionally joined by a logical connective. The table therefore functions as the child detail that makes an assignment set executable: without criteria rows, a set definition has no way to resolve which assignments qualify.

Under the heuristic Data Vault classification mined from its foreign-key structure, this table is described as satellite-leaning. As a modeling suggestion, this reflects its role as a descriptive child of a parent entity (HR_ASSIGNMENT_SETS) rather than an independent hub or a pure many-to-many link. In practice it behaves as a dependent detail table whose grain is the criterion line within a set.

Key Information Stored

The documented schema exposes eleven columns. The most significant are:

• LINE_NO — the sequence number of the criterion within a set, ordering the conditions as they are evaluated.
• ASSIGNMENT_SET_ID — the foreign key to HR_ASSIGNMENT_SETS, identifying the parent set that owns the criterion.
• LEFT_OPERAND — the left side of the criterion expression, typically the assignment attribute or column being tested.
• OPERATOR — the comparison operator applied between operands (for example equality or range operators).
• RIGHT_OPERAND — the value or attribute against which the left operand is compared.
• LOGICAL — the connective that joins this line to the preceding line (such as AND/OR), governing how criteria combine.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard Oracle EBS Who columns capturing audit and concurrency information.

The surrogate primary key is HR_ASSIGNMENT_SET_CRITERIA_PK, defined over the composite (LINE_NO, ASSIGNMENT_SET_ID). Because this unique index also serves as the business-key candidate, the combination of parent set and line number uniquely identifies each criterion; no separate system-generated single-column identifier is documented.

Common Use Cases and Queries

Typical scenarios include auditing how an assignment set is built, troubleshooting why a process selects an unexpected population, and reporting on set definitions. A common query retrieves all criteria for a given set in evaluation order:

• SELECT line_no, left_operand, operator, right_operand, logical FROM hr.hr_assignment_set_criteria WHERE assignment_set_id = :set_id ORDER BY line_no;
• Joining to the parent to list set names alongside their criteria: SELECT s.assignment_set_id, c.line_no, c.left_operand, c.operator, c.right_operand FROM hr.hr_assignment_sets s JOIN hr.hr_assignment_set_criteria c ON s.assignment_set_id = c.assignment_set_id ORDER BY s.assignment_set_id, c.line_no;
• Audit reporting on who last changed a set definition, using LAST_UPDATED_BY and LAST_UPDATE_DATE.
• Impact analysis to find which sets reference a particular attribute value in RIGHT_OPERAND.

Related Objects

• HR_ASSIGNMENT_SETS — the parent table; joined on ASSIGNMENT_SET_CRITERIA.ASSIGNMENT_SET_ID = HR_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID via the documented foreign key.
• PER_ASSIGNMENT_SETS / assignment set definition forms — the UI and API layer that populate criteria.
• HR_ASSIGNMENTS — the assignment records ultimately resolved by set evaluation.
• FND_FLEX_* and key flexfield structures — supply the attribute values referenced by LEFT_OPERAND and RIGHT_OPERAND.
• PER_ASSIGNMENT_SETS_API / assignment set PL/SQL packages — programmatic creation and maintenance of sets and their criteria.