Search Results pay_wc_funds




Overview
Explore in AI Chat

Overview

The PAY_WC_FUNDS table is a core data repository within the Oracle E-Business Suite Payroll module (PAY). It serves as the master table for defining and storing Workers' Compensation funds. In the context of U.S. payroll, Workers' Compensation is a state-mandated insurance program that provides benefits to employees who suffer job-related injuries or illnesses. This table enables organizations to configure the specific funds, carriers, and associated rules required for accurate calculation, reporting, and remittance of Workers' Compensation premiums. Its integrity is maintained through a primary key and multiple foreign key relationships, ensuring data consistency with other fundamental HR and payroll entities.

Key Information Stored

The table's structure is designed to capture essential details for each defined fund. The primary identifier is the FUND_ID column, which is the table's primary key. Critical contextual columns include BUSINESS_GROUP_ID, which links the fund to a specific organizational entity, and STATE_CODE, which ties the fund to a governing state rule as defined in the PAY_STATE_RULES table. The table also stores carrier and location information via the CARRIER_ID and LOCATION_ID foreign keys, referencing HR_ALL_ORGANIZATION_UNITS and HR_LOCATIONS_ALL, respectively. Additional columns typically include fund names, codes, effective dates, and configuration flags controlling the fund's activity and calculation methodology, though these specific column names are implied by the table's purpose beyond the provided metadata.

Common Use Cases and Queries

This table is central to payroll processes involving Workers' Compensation. Primary use cases include the setup and maintenance of compensation funds, the generation of premium liability reports, and the processing of payroll runs where Workers' Compensation deductions are calculated. A common reporting query involves joining PAY_WC_FUNDS with related tables to list all active funds for a business group.

  • Sample Query: Listing Fund Details
    SELECT pwf.fund_id, pwf.name, pwf.state_code,
    hou.name carrier_name, hl.location_code
    FROM pay_wc_funds pwf,
    hr_all_organization_units hou,
    hr_locations_all hl
    WHERE pwf.carrier_id = hou.organization_id(+)
    AND pwf.location_id = hl.location_id(+)
    AND pwf.business_group_id = :p_bg_id
    AND SYSDATE BETWEEN pwf.effective_start_date AND pwf.effective_end_date;
  • Integration Point: The fund definitions in this table are directly referenced during payroll calculations to determine the applicable premium rates stored in the related PAY_WC_RATES table.

Related Objects

PAY_WC_FUNDS maintains defined relationships with several key EBS objects, as documented in its foreign key constraints.

  • PAY_WC_RATES: This is a primary child table. The PAY_WC_RATES.FUND_ID column references PAY_WC_FUNDS.FUND_ID, storing the specific premium rates applicable to each fund.
  • PAY_STATE_RULES: The STATE_CODE foreign key ensures fund definitions align with state-specific legislative rules configured within the payroll system.
  • HR_ALL_ORGANIZATION_UNITS: Referenced twice: via BUSINESS_GROUP_ID to scope the fund, and via CARRIER_ID to identify the insurance carrier organization.
  • HR_LOCATIONS_ALL: The LOCATION_ID link associates a fund with a specific work location, which may be required for reporting or rate determination.