Results for “per_bf_payroll_runs”

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

Overview

PER_BF_PAYROLL_RUNS is a Human Resources (PER) module table that stores payroll runs processed by a third-party benefits or payroll provider on behalf of an Oracle E-Business Suite enterprise. The "BF" prefix denotes the Benefits/Payroll interface staging area used to integrate externally calculated payroll results back into EBS for downstream processing, reporting, and reconciliation. Each row represents a discrete payroll run (a single payroll cycle for a payroll identifier within a specific business group), together with its period dates, processing date, and provider-supplied attributes.

The table resides in the HR schema and is present in both 12.1.1 and 12.2.2, with the documented 12.2.2 physical schema comprising 44 columns. Because the primary key PAYROLL_RUN_ID is a system-generated surrogate and the descriptive context (identifier, business group, period) is carried on the same row, the ETRM Data Vault heuristic classifies this object as satellite-leaning. In modeling terms, it behaves as a descriptive satellite attached to the payroll and business-group hubs rather than a true hub or link.

Key Information Stored

The documented column set separates identifying keys from descriptive and audit attributes:

• PAYROLL_RUN_ID — surrogate primary key (PER_BF_PAYROLL_RUNS_PK), the internal unique identifier for each processed payroll run.
• PAYROLL_IDENTIFIER and BUSINESS_GROUP_ID — together forming unique index PER_BF_PAYROLL_RUNS_UK1, the business-key candidate guaranteeing uniqueness of a payroll identifier per business group.
• PAYROLL_ID — reference to the payroll definition the run pertains to.
• PERIOD_START_DATE and PERIOD_END_DATE — the payroll period boundaries the run covers.
• PROCESSING_DATE — the date the third-party processor executed the run.
• BPR_ATTRIBUTE_CATEGORY and BPR_ATTRIBUTE1 through BPR_ATTRIBUTE30 — a 30-column descriptive flexfield used by the external provider to carry run-level context that EBS does not natively model.
• OBJECT_VERSION_NUMBER and the standard Who columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) — concurrency control and audit trail attributes.

Common Use Cases and Queries

Typical usage centers on reconciling externally processed payroll runs, reporting run history by period, and joining runs to their processed assignment detail. A representative query lists runs for a business group within a date range:

• SELECT payroll_run_id, payroll_identifier, period_start_date, period_end_date, processing_date FROM per_bf_payroll_runs WHERE business_group_id = :bg_id AND processing_date BETWEEN :from_date AND :to_date ORDER BY processing_date DESC;
• Joining runs to detail: SELECT r.payroll_identifier, a.* FROM per_bf_payroll_runs r, per_bf_processed_assignments a WHERE r.payroll_run_id = a.payroll_run_id;
• Auditing provider-supplied context via the BPR_ATTRIBUTE flexfield columns for a specific run.

These patterns support payroll auditing, provider reconciliation, and extract reporting where the third-party system is the system of record for calculation.

Related Objects

• PER_BF_PROCESSED_ASSIGNMENTS — child table; joins on PER_BF_PROCESSED_ASSIGNMENTS.PAYROLL_RUN_ID = PER_BF_PAYROLL_RUNS.PAYROLL_RUN_ID, holding assignment-level detail for each run.
• HR_ALL_ORGANIZATION_UNITS — parent for BUSINESS_GROUP_ID; supplies the business group (organization) each run belongs to.
• PER_BF_PAYROLL_RUNS_PK / PER_BF_PAYROLL_RUNS_UK1 — primary and unique indexes enforcing identity and uniqueness.
• PAY_ALL_PAYROLLS_F — the standard payroll definition referenced conceptually via PAYROLL_ID for denominator/context reporting.