Search Results pay_all_payrolls_f




Overview
Explore in AI Chat

Overview

The PAY_ALL_PAYROLLS_F table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It serves as the master repository for payroll group definitions, which are fundamental organizational structures for processing employee compensation. A payroll group defines the parameters for a specific pay cycle, including its frequency, associated organization, and accounting rules. This 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, allowing for the tracking of historical changes to payroll definitions over time. Its role is critical for payroll processing runs, cost allocation, and financial reporting.

Key Information Stored

The table stores the defining attributes of a payroll. The primary key uniquely identifies a payroll definition across time (PAYROLL_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE). Essential columns include PAYROLL_NAME for identification and PERIOD_TYPE, which links to PER_TIME_PERIOD_TYPES to define the pay frequency (e.g., weekly, monthly). The table also holds key foreign key references that configure the payroll's operational and financial context: BUSINESS_GROUP_ID and ORGANIZATION_ID link to HR_ALL_ORGANIZATION_UNITS; CONSOLIDATION_SET_ID links to PAY_CONSOLIDATION_SETS for reporting; and COST_ALLOCATION_KEYFLEX_ID, SUSPENSE_ACCOUNT_KEYFLEX_ID, and SOFT_CODING_KEYFLEX_ID link to key flexfields for accounting and defaulting rules.

Common Use Cases and Queries

This table is central to payroll setup, reporting, and integration. Common use cases include generating a list of all active payrolls within a business group for a process schedule, validating payroll parameters before a batch run, and tracing accounting configurations. A typical query retrieves active payroll definitions for reporting or feeder systems.

  • Listing active payrolls with key details: 
    SELECT payroll_name,
       period_type,
       organization_id
FROM   pay_all_payrolls_f
WHERE  SYSDATE BETWEEN effective_start_date
                   AND effective_end_date
AND    business_group_id = &bg_id;
  • Identifying payrolls using a specific consolidation set for period-end reporting.
  • Troubleshooting by joining to related key flexfield tables to verify cost account mappings.

Related Objects

PAY_ALL_PAYROLLS_F has defined relationships with several other critical HR and Payroll tables, primarily through foreign key constraints. These relationships are essential for data integrity and join logic in custom reports and interfaces.

  • HR_ALL_ORGANIZATION_UNITS: Linked via BUSINESS_GROUP_ID and ORGANIZATION_ID to define the payroll's legal employer and operating unit context.
  • PAY_CONSOLIDATION_SETS: Linked via CONSOLIDATION_SET_ID to group payrolls for period-end processing.
  • PAY_COST_ALLOCATION_KEYFLEX: Linked via COST_ALLOCATION_KEYFLEX_ID and SUSPENSE_ACCOUNT_KEYFLEX_ID for default costing and suspense account rules.
  • HR_SOFT_CODING_KEYFLEX: Linked via SOFT_CODING_KEYFLEX_ID for default earning and deduction rules.
  • PER_TIME_PERIOD_TYPES: Linked via PERIOD_TYPE to define the payroll frequency (e.g., 'Calendar Monthly').