Search Results per_all_assignments_f

Overview

The PER_ALL_ASSIGNMENTS_F table is a core data object within the Oracle E-Business Suite Human Resources (HR) module. It serves as the central repository for storing detailed assignment records for both employees and applicants. An assignment defines the specific terms, conditions, and organizational context of an individual's role, such as their job, position, location, and grade. The table is date-effective, as indicated by the '_F' suffix and the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns in its primary key. This design allows for the maintenance of a complete historical record of all changes to an assignment over time, which is critical for accurate payroll processing, reporting, and compliance.

Key Information Stored

The table's primary key is a composite of ASSIGNMENT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. Beyond these temporal columns, the table stores a comprehensive set of foreign keys that link the assignment to other critical entities in the HRMS structure. Key relational columns include PERSON_ID (linking to PER_ALL_PEOPLE_F), ORGANIZATION_ID, JOB_ID, POSITION_ID, GRADE_ID, and LOCATION_ID, which define the assignment's organizational placement. The ASSIGNMENT_STATUS_TYPE_ID indicates whether the assignment is active, suspended, or terminated. Other significant columns track compensation details (PAY_BASIS_ID), recruitment (APPLICATION_ID, VACANCY_ID), and collective agreements (COLLECTIVE_AGREEMENT_ID, CAGR_GRADE_DEF_ID).

Common Use Cases and Queries

This table is fundamental for HR reporting, payroll integration, and organizational management. Common operational and analytical queries include retrieving an employee's current assignment details for a payslip, listing all assignments within a specific department, or tracking the history of job changes for an individual. A typical query to find an employee's active assignment would join PER_ALL_PEOPLE_F with PER_ALL_ASSIGNMENTS_F, filtering on the person identifier and ensuring the system date falls between the assignment's effective dates. For headcount reporting, analysts often aggregate records from this table by ORGANIZATION_ID, JOB_ID, and ASSIGNMENT_STATUS_TYPE_ID. The table is also central to processes managed by standard Oracle APIs, such as the HR_ASSIGNMENT_API, which are used for creating and maintaining assignment data programmatically.

Related Objects

As evidenced by its extensive foreign key relationships, PER_ALL_ASSIGNMENTS_F is a hub table with dependencies across the HR and Payroll modules. It directly references master tables such as PER_JOBS, PER_ALL_POSITIONS, PER_GRADES, HR_ALL_ORGANIZATION_UNITS, and HR_LOCATIONS_ALL. It is the parent table for key payroll-related entities like PAY_PAYROLLS_F and PER_PAY_PROPOSALS. Furthermore, it is linked to recruitment objects like PER_APPLICATIONS and PER_ALL_VACANCIES. Key dependent objects include the PER_ASSIGNMENTS_X and PER_ASSIGNMENTS_LE_V views, which provide secure, business-oriented access to the underlying assignment data. For comprehensive person data, it is invariably joined with the PER_ALL_PEOPLE_F table.