Results for “hr_assignment_sets”

50+ results




Overview
Explore in AI Chat

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

Overview

HR_ASSIGNMENT_SETS is a Human Resources (PER) table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores formula definitions that identify discrete sets of assignments, enabling payroll and HR processes to operate against a logical grouping of employee assignments rather than against the full population of assignments in a business group. Each row defines one assignment set, bound to a business group and optionally to a payroll, and associated with a formula that determines the membership criteria evaluated at runtime.

Assignment sets are foundational to Oracle Payroll because payroll run actions, including the choice of which assignments to process in a given payroll run, are driven by assignment set definitions rather than ad hoc assignment lists. The heuristic Data Vault classification mined from the foreign key structure is hub-leaning: ASSIGNMENT_SET_ID behaves as a durable business entity key around which dependent descriptive and criterion tables cluster. From a dimensional perspective, HR_ASSIGNMENT_SETS is best modeled as a hub (or a low-cardinality dimension) rather than a transactional link, with HR_ASSIGNMENT_SET_CRITERIA and HR_ASSIGNMENT_SET_AMENDMENTS functioning as satellite-style detail.

Key Information Stored

The table carries ten documented columns. The principal attributes are:

  • ASSIGNMENT_SET_ID — the surrogate primary key, enforced by HR_ASSIGNMENT_SETS_PK. This is the only documented unique index and therefore the sole business-key candidate in the metadata.
  • BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the set to a specific business group and thus establishing the legislative and organizational context.
  • ASSIGNMENT_SET_NAME — the user-visible name used to identify the set on payroll run parameters and in HR inquiry screens.
  • FORMULA_ID — reference to the Oracle FastFormula that evaluates assignment attributes and returns whether an assignment belongs to the set. Membership is dynamic, so the same set can yield different populations as assignment data changes.
  • PAYROLL_ID — associates the set with a payroll, supporting payroll-specific assignment grouping.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Oracle EBS WHO columns providing audit lineage for the row.

The ETRM documentation does not enumerate additional descriptive columns beyond these ten, so the surrogate key (ASSIGNMENT_SET_ID) and the business-key candidate coincide, with ASSIGNMENT_SET_NAME serving as the human-readable identifier.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing assignment sets for a business group, identifying which sets drive payroll actions, and resolving the membership criteria for audit purposes.

  • Enumerate sets by business group: SELECT assignment_set_id, assignment_set_name, formula_id FROM hr.hr_assignment_sets WHERE business_group_id = :p_bg_id ORDER BY assignment_set_name;
  • Trace payroll actions that consume a set: SELECT a.assignment_set_name, p.payroll_action_id FROM hr.hr_assignment_sets a, pay.pay_payroll_actions p WHERE a.assignment_set_id = p.assignment_set_id;
  • Retrieve the criteria rows behind a named set: SELECT c.* FROM hr.hr_assignment_set_criteria c, hr.hr_assignment_sets s WHERE c.assignment_set_id = s.assignment_set_id AND s.assignment_set_name = :p_name;
  • Audit recent changes: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to satisfy SOX or internal control reporting.

Related Objects

The documented relationships anchor the following significant objects:

  • HR_ALL_ORGANIZATION_UNITS — referenced via BUSINESS_GROUP_ID; supplies the business group context for each set.
  • HR_ASSIGNMENT_SET_CRITERIA — child table keyed by ASSIGNMENT_SET_ID; holds the individual criteria lines that the formula or set evaluation uses.
  • HR_ASSIGNMENT_SET_AMENDMENTS — child table keyed by ASSIGNMENT_SET_ID; records amendments or versioned changes to assignment set definitions.
  • PAY_PAYROLL_ACTIONS — references ASSIGNMENT_SET_ID, tying payroll run actions to the set of assignments processed.
  • FF_FORMULAS (FORMULA_ID) — the FastFormula referenced by FORMULA_ID, though not listed in the FK metadata, governs runtime membership evaluation.
  • PER_ASSIGNMENTS_F — the assignment population ultimately filtered by the formula, providing the effective-dated assignment rows the set resolves to.