Search Results pay_wc_rates




Overview
Explore in AI Chat

Overview

The PAY_WC_RATES table resides in the HR schema and belongs to the Oracle Payroll (PAY) product module. It stores Workers Compensation Rates, which define the rate structures applied when calculating workers' compensation liabilities for a payroll business group. In Oracle EBS 12.1.1 and 12.2.2, this table supports statutory and voluntary workers' compensation processing by associating rate values with specific compensation codes and funding sources.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure identifies this object as a link. This classification reflects the table's role in resolving relationships between workers' compensation codes and funding entities, with the composite primary key acting as the connecting grain. The table carries descriptive rate attributes alongside its relationship columns, so implementers may alternatively model the rate values as satellite attributes attached to the identified link.

Key Information Stored

The table contains fourteen documented columns. The most significant are summarized below.

  • WC_CODE — The workers' compensation code. Together with FUND_ID, this forms the composite primary key PAY_WC_RATES_PK (WC_CODE, FUND_ID), the business-key candidate for uniquely identifying a rate record.
  • FUND_ID — Foreign key to PAY_WC_FUNDS, identifying the funding source associated with the compensation code.
  • BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the rate record to a specific business group (organization).
  • RATE, RATE2, RATE3 — Rate values associated with the compensation code. Multiple rate columns accommodate tiered or alternate rate structures.
  • RATE_EE, RATE_EE2 — Employee-related rate values, typically capturing the employee-borne or employee-specific portion of the compensation rate.
  • PERIOD — The period to which the rate applies, supporting effective-dated or period-specific rate application.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide standard Oracle EBS who-did-what auditing.

The primary key is composite rather than a single surrogate identifier; WC_CODE and FUND_ID together constitute the unique business key. There is no separate single-column surrogate key documented.

Common Use Cases and Queries

Typical use cases include verifying configured workers' compensation rates for a business group, reconciling rates against funding sources, and feeding downstream payroll calculation or reporting extracts.

  • Retrieving all rates for a business group: SELECT wc_code, fund_id, rate, period FROM pay_wc_rates WHERE business_group_id = :p_bg_id;
  • Joining to funds to resolve the funding source name: SELECT r.wc_code, f.fund_name, r.rate FROM pay_wc_rates r, pay_wc_funds f WHERE r.fund_id = f.fund_id;
  • Reporting tiered rates: selecting RATE, RATE2, RATE3, RATE_EE, and RATE_EE2 side by side to compare rate tiers for a compensation code.
  • Audit and change tracking: filtering on LAST_UPDATE_DATE to identify recently modified rate records during configuration reviews.

Because the table is keyed on (WC_CODE, FUND_ID), queries that filter on either column benefit from the PAY_WC_RATES_PK index.

Related Objects

  • PAY_WC_FUNDS — Referenced via PAY_WC_RATES.FUND_ID; the parent table defining workers' compensation funding sources.
  • HR_ALL_ORGANIZATION_UNITS — Referenced via PAY_WC_RATES.BUSINESS_GROUP_ID; supplies the business group (organization) context.
  • PAY_WC_RATES_PK — The primary key index enforcing uniqueness on (WC_CODE, FUND_ID).
  • Workers' compensation processing logic within the PAY module consumes these rates during payroll calculation, and related workers' compensation setup tables (for codes and funds) should be reviewed alongside this table.

Oracle-proprietary and confidential information; the schema details above reflect the ETRM 12.2.2 documented physical structure held in the HR schema.