Results for “hr_assignment_set_criteria_pk”

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

Overview

HR.HR_ASSIGNMENT_SET_CRITERIA is a transactional configuration table in the Oracle E-Business Suite Human Resources (HR) schema. It stores the individual logical conditions that, taken collectively, define an assignment set. Each row represents one criterion used to filter a population of assignments, expressed in a form that can be compiled into an assignment set formula. The list of assignments belonging to a set is generated dynamically when the formula is executed, for example when the assignment set is referenced by a payroll run or other process.

The table resides in the APPS_TS_TX_DATA tablespace and is owned by the HR schema (FND Design Data: PER.HR_ASSIGNMENT_SET_CRITERIA). Its primary key, HR_ASSIGNMENT_SET_CRITERIA_PK, is composite over LINE_NO and ASSIGNMENT_SET_ID, and its uniqueness is enforced by a normal unique index in APPS_TS_TX_IDX. A non-unique foreign key index, HR_ASSIGNMENT_SET_CRITERIA_FK1, supports the relationship to HR_ASSIGNMENT_SETS.

Under a heuristic Data Vault classification, this object is satellite-leaning. Its composite key of a parent identifier (ASSIGNMENT_SET_ID) plus a sequence attribute (LINE_NO) is characteristic of a dependent child or satellite holding descriptive detail attached to a parent hub or link, in this case the assignment set.

Key Information Stored

The documented physical schema for release 12.2.2 contains eleven columns. The columns most relevant to functional and reporting use are:

• LINE_NO — Sequence in which the condition is applied for the set; part of the primary key.
• ASSIGNMENT_SET_ID — Foreign key to HR_ASSIGNMENT_SETS; part of the primary key and identifies the parent set.
• LEFT_OPERAND — The database item or literal text on the left side of the condition. Database items are prefixed in the user interface with an ampersand (&).
• OPERATOR — Defines how the left operand must relate to the right operand for the condition to succeed (for example equality or inequality).
• RIGHT_OPERAND — The database item or literal text on the right side of the condition, also ampersand-prefixed when referencing a database item.
• LOGICAL — The logical link (AND/OR) between this condition and the previous one in the sequence.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Who audit columns recording creation and last modification metadata.

The surrogate primary key is the composite (LINE_NO, ASSIGNMENT_SET_ID), which is also the sole documented business-key candidate, since HR_ASSIGNMENT_SET_CRITERIA_PK is the only unique index defined. No separate single-column surrogate identifier exists; the parent identifier and sequence together uniquely identify each criterion row.

Common Use Cases and Queries

Typical uses include auditing how an assignment set is constructed, diagnosing why an assignment is or is not included in a payroll run, and migrating or comparing assignment set definitions between environments or releases.

A common pattern retrieves all criteria for a given set in sequence order:

• SELECT line_no, left_operand, operator, right_operand, logical FROM hr_assignment_set_criteria WHERE assignment_set_id = :set_id ORDER BY line_no;
• Joining to the parent set to obtain the set name: SELECT s.assignment_set_name, c.line_no, c.left_operand, c.operator, c.right_operand, c.logical FROM hr_assignment_set_criteria c, hr_assignment_sets s WHERE c.assignment_set_id = s.assignment_set_id ORDER BY s.assignment_set_name, c.line_no;
• Searching for criteria that reference a specific operand: SELECT assignment_set_id, line_no FROM hr_assignment_set_criteria WHERE left_operand LIKE '%PER_AGE%' OR right_operand LIKE '%PER_AGE%';

Because the criteria are compiled into an assignment set formula, reporting should reconstruct conditions in LINE_NO order and respect the AND/OR linkage recorded in the LOGICAL column. Change-tracking reports can leverage the Who columns to identify recently modified set definitions.

Related Objects

The following objects are most significant in relation to HR_ASSIGNMENT_SET_CRITERIA:

• HR_ASSIGNMENT_SETS — The parent table; joined on ASSIGNMENT_SET_ID. This is the documented foreign key relationship and the source of the set name and header information.
• HR_ASSIGNMENT_SET_CRITERIA_PK — The unique index over (LINE_NO, ASSIGNMENT_SET_ID) that enforces the table's primary key.
• HR_ASSIGNMENT_SET_CRITERIA_FK1 — The non-unique index supporting the ASSIGNMENT_SET_ID foreign key.
• Assignment set formula and database item definitions — The operands referenced in LEFT_OPERAND and RIGHT_OPERAND resolve against HR database items, and the conditions are compiled into an assignment set formula executed at runtime.
• Payroll and assignment set processing logic — Payroll runs and related processes that reference an assignment set trigger execution of the compiled formula, generating the member assignment list from these criteria.

Collectively these relationships confirm that HR_ASSIGNMENT_SET_CRITERIA functions as a dependent detail table attached to HR_ASSIGNMENT_SETS, with its criteria feeding formula-driven assignment set generation in Oracle EBS 12.1.1 and 12.2.2.