Search Results pay_wc_rates




Overview
Explore in AI Chat

Overview

The PAY_WC_RATES table is a core data structure within the Oracle E-Business Suite Payroll module (PAY). It serves as the definitive repository for workers' compensation insurance rates. These rates are essential for calculating employer liabilities for workplace injuries and are a critical component of payroll costing and accrual processes. The table's primary function is to store the specific rate values, associated with unique workers' compensation codes and funds, which are then applied to employee earnings during payroll runs to determine the correct compensation premium amounts.

Key Information Stored

The table's design centers on the unique combination of a workers' compensation code and a specific fund. As indicated by its primary key (PAY_WC_RATES_PK), the WC_CODE and FUND_ID columns are its principal identifiers. The WC_CODE typically represents a classification of work or job risk, while the FUND_ID links to a specific insurance fund or state authority defined in the PAY_WC_FUNDS table. Other critical columns include the BUSINESS_GROUP_ID, which scopes the rate to a particular organizational unit, and the RATE column itself, which holds the numerical rate value. The table likely includes effective date columns (e.g., EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) to manage rate changes over time, along with standard WHO columns for auditing.

Common Use Cases and Queries

The primary use case is the retrieval of the applicable rate for payroll calculation. A typical query involves joining to employee assignment or costing records to fetch the correct WC_CODE and FUND_ID, then looking up the corresponding rate. For reporting and maintenance, queries often list all active rates for a business group or fund. Common SQL patterns include:

  • Fetching a specific rate: SELECT rate FROM pay_wc_rates WHERE wc_code = '<code>' AND fund_id = <id> AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
  • Auditing rate history: SELECT wc_code, rate, effective_start_date FROM pay_wc_rates WHERE fund_id = <id> ORDER BY wc_code, effective_start_date;

This table is integral to workers' compensation liability reports and payroll reconciliation audits.

Related Objects

PAY_WC_RATES maintains defined foreign key relationships with other HR and Payroll tables, ensuring data integrity. Based on the provided metadata, the key relationships are:

  • HR_ALL_ORGANIZATION_UNITS: The BUSINESS_GROUP_ID column in PAY_WC_RATES references this table, tethering each rate record to a specific business group for security and multi-org purposes.
  • PAY_WC_FUNDS: The FUND_ID column in PAY_WC_RATES references the primary key of this table. PAY_WC_FUNDS stores master information about the workers' compensation funds, insurers, or jurisdictions, making this a critical parent table for the rate data.

Furthermore, the table is expected to be referenced by payroll costing tables (e.g., PAY_COSTS) that store the calculated premium amounts, and it is central to the workers' compensation setup and maintenance forms within the Oracle EBS application.