Search Results per_bf_processed_assigns_uk1




Overview
Explore in AI Chat

Overview

The PER_BF_PROCESSED_ASSIGNMENTS table is a core intersection table within the Oracle E-Business Suite Human Resources (HR) module, specifically designed to support third-party payroll integrations. Its primary role is to serve as a detailed audit and control mechanism for payroll processing. For each payroll run executed by an external payroll provider, this table records a definitive list of employee assignments that were successfully processed. This creates a critical link between the Oracle HR assignment data and the external payroll run, enabling reconciliation, reporting, and downstream processing of payroll results such as balance adjustments and payment details within the EBS system.

Key Information Stored

The table's structure is centered on uniquely identifying which assignments belong to which payroll run. Its primary key is the system-generated PROCESSED_ASSIGNMENT_ID. The table enforces a unique constraint (PER_BF_PROCESSED_ASSIGNS_UK1) on the combination of PAYROLL_RUN_ID and ASSIGNMENT_ID, ensuring that a specific assignment is recorded only once per payroll run. The PAYROLL_RUN_ID is a foreign key to PER_BF_PAYROLL_RUNS, which stores high-level information about the external payroll execution. The ASSIGNMENT_ID directly references the core PER_ALL_ASSIGNMENTS_F table, linking the processed record to the employee's assignment details. This intersection design is fundamental for tracking the processing status of every assignment in an external payroll cycle.

Common Use Cases and Queries

The primary use case is payroll reconciliation and auditing. Administrators can query this table to verify which employees were included in a specific external payroll run or to review the payroll history of a particular assignment. It is also essential for generating reports on payroll processing completeness and for troubleshooting missing assignments. A typical query would join to PER_BF_PAYROLL_RUNS for run details and to PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F for employee information.

  • Sample Query: To list all processed assignments for a payroll run named 'JAN-2024-MONTHLY':
    SELECT ppf.full_name, paaf.assignment_number
    FROM per_bf_processed_assignments pbfpa
    JOIN per_bf_payroll_runs pbfpr ON pbfpa.payroll_run_id = pbfpr.payroll_run_id
    JOIN per_all_assignments_f paaf ON pbfpa.assignment_id = paaf.assignment_id
    JOIN per_all_people_f ppf ON paaf.person_id = ppf.person_id
    WHERE pbfpr.payroll_run_name = 'JAN-2024-MONTHLY'
    AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
    AND SYSDATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date;

Related Objects

PER_BF_PROCESSED_ASSIGNMENTS sits at the center of the third-party payroll interface data model. It has a direct parent-child relationship with several key tables:

  • PER_BF_PAYROLL_RUNS: The parent table, providing context for the payroll run (foreign key: PAYROLL_RUN_ID).
  • PER_BF_BALANCE_AMOUNTS: A child table that stores balance adjustments (e.g., deductions, earnings) imported from the external provider for each processed assignment.
  • PER_BF_PAYMENT_DETAILS: Another child table that stores detailed payment information (e.g., net pay, tax withholdings) resulting from the payroll run for each assignment.
  • PER_ALL_ASSIGNMENTS_F: The foundational HRMS table for assignment data, referenced via the ASSIGNMENT_ID column.