Results for “bpa_attribute30”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PER_BF_PROCESSED_ASSIGNMENTS is a Human Resources (PER) module table in the HR schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as an intersection table that records which employee assignments have been processed by a third-party (non-Oracle) payroll provider during a given payroll run. The "BF" prefix refers to the payroll interface architecture used to exchange data between Oracle EBS and an external payroll engine; rows in this table represent the successful linkage of an assignment to a specific payroll run processed through that external provider.
From a data-modeling perspective, the table is heuristic-classified as hub-leaning. It carries its own surrogate primary key and resolves into child tables (balance amounts and payment details), which is characteristic of a hub or reference entity that anchors downstream transactional detail. This classification is a modeling suggestion only, derived from the foreign-key topology, and should not be treated as a formal Data Vault design.
Key Information Stored
The table is documented with 40 columns. The most significant structural and descriptive columns are:
- PROCESSED_ASSIGNMENT_ID — Surrogate primary key, enforced by index PER_BF_PROCESSED_ASSIGNS_PK. It uniquely identifies each processed-assignment record and is the column referenced by dependent child tables.
- PAYROLL_RUN_ID — Foreign key to PER_BF_PAYROLL_RUNS. Identifies the payroll run in which the assignment was processed.
- ASSIGNMENT_ID — Identifies the assignment (the worker's placement against a payroll) that was submitted to and accepted by the third-party provider.
- PAYROLL_RUN_ID + ASSIGNMENT_ID — Documented as unique index PER_BF_PROCESSED_ASSIGNS_UK1. This composite is the true business-key candidate: a given assignment may appear only once per payroll run.
- OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications framework to detect concurrent updates.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking modification.
- CREATED_BY, CREATION_DATE — Standard WHO columns tracking row creation.
- BPA_ATTRIBUTE_CATEGORY and BPA_ATTRIBUTE1 through BPA_ATTRIBUTE30 — A flexible descriptive-flexfield block (prefixed "BPA" for processed assignment) allowing customers to persist provider-specific or implementation-specific data without schema change.
The BPA attribute columns are the dominant volume of the 40 documented columns and are the extension point for third-party provider integration data, whereas the identity and relationship columns above are the ones routinely joined and filtered in reporting.
Common Use Cases and Queries
Typical scenarios include reconciling third-party payroll output back to Oracle, identifying which assignments were accepted or rejected in a run, and drilling from a run into per-assignment balance or payment detail.
- List all assignments processed in a specific run:
SELECT processed_assignment_id, assignment_id FROM per_bf_processed_assignments WHERE payroll_run_id = :run_id;
- Confirm the assignment was processed exactly once per run (business-key validation):
GROUP BY payroll_run_id, assignment_id HAVING COUNT(*) > 1. - Join to run header for context:
SELECT pba.assignment_id, pr.run_name FROM per_bf_processed_assignments pba JOIN per_bf_payroll_runs pr ON pr.payroll_run_id = pba.payroll_run_id;
- Aggregate balance or payment detail per processed assignment through the child tables PER_BF_BALANCE_AMOUNTS and PER_BF_PAYMENT_DETAILS using PROCESSED_ASSIGNMENT_ID.
- Report on flexfield values by querying BPA_ATTRIBUTE_CATEGORY and the relevant BPA_ATTRIBUTE
column.
Related Objects
- PER_BF_PAYROLL_RUNS — Parent table; joined on PAYROLL_RUN_ID.
- PER_BF_BALANCE_AMOUNTS — Child table; references this table via PROCESSED_ASSIGNMENT_ID, holding balance detail per processed assignment.
- PER_BF_PAYMENT_DETAILS — Child table; references this table via PROCESSED_ASSIGNMENT_ID, holding payment-level detail per processed assignment.
- PER_ASSIGNMENTS_F / PER_ALL_ASSIGNMENTS_F — Source of assignment context referenced by ASSIGNMENT_ID.
- PER_BF_PROCESSED_ASSIGNS_PK / PER_BF_PROCESSED_ASSIGNS_UK1 — Primary and unique indexes enforcing the identity and business-key constraints.
-
Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run
-
Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run
-
APPS.PER_BF_EMPLOYEE_RUN_DETAILS_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
APPS.PER_BF_EMPLOYEE_RUN_DETAILS_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
PACKAGE: APPS.PER_BPA_SHD 12.1.1
-
PACKAGE: APPS.PER_BPA_SHD 12.2.2
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person