Search Results pay_wc_funds




Overview
Explore in AI Chat

Overview

PAY_WC_FUNDS is a payroll-configuration table owned by the HR schema in Oracle E-Business Suite (validated across 12.1.1 and 12.2.2). It stores Workers Compensation fund definitions used by the Oracle Payroll application to identify the insurance carriers, jurisdictions, and reporting locations under which workers' compensation coverage is administered. Each row represents a distinct workers' compensation fund combination that payroll processing can attach to rates defined in PAY_WC_RATES.

Under the heuristic Data Vault classification derived from its foreign-key structure, PAY_WC_FUNDS is satellite-leaning. In Data Vault terms this suggests it behaves primarily as a descriptive grouping table supplying attributes and context around a small set of parent references (business group, carrier, location, and state), rather than acting as a central hub or an intersection of independent entities. Modeling exercises should treat it as descriptive configuration data owned by the PAY product, not as transactional payroll results.

Key Information Stored

The table contains 14 documented columns. The most significant include FUND_ID, the surrogate primary key defined by the PAY_WC_FUNDS_PK constraint, which uniquely identifies each fund record and is referenced by dependent rate rows. The unique index PAY_WC_FUNDS_U50 (CARRIER_ID, STATE_CODE, LOCATION_ID) establishes the business-key candidate: a given carrier, state, and location combination uniquely identifies a fund. BUSINESS_GROUP_ID scopes the record to its legislative or organizational business group, while CARRIER_ID identifies the workers' compensation insurance carrier (both referencing HR_ALL_ORGANIZATION_UNITS). LOCATION_ID references HR_LOCATIONS_ALL and identifies the reporting or coverage location, and STATE_CODE references PAY_STATE_RULES to pin the fund to a jurisdiction and its associated statutory rules.

Three calculation-method columns — CALCULATION_METHOD, CALCULATION_METHOD2, and CALCULATION_METHOD3 — capture how workers' compensation amounts are computed, allowing tiered or alternate methods per fund. COMMENTS holds free-form descriptive notes. The standard EBS audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) track who created and most recently changed each row, supporting audit and change-tracking requirements. SYS_IL0000043490C00014$$ is an internal LOB index and should not be treated as a business attribute.

Common Use Cases and Queries

Typical uses include reporting the carriers, states, and locations configured for workers' compensation, validating that required funds exist before rates are loaded, and auditing configuration changes. A common pattern joins the fund to its carrier and location:

  • List funds by state: SELECT f.fund_id, f.state_code, f.carrier_id, f.location_id FROM pay_wc_funds f WHERE f.state_code = :state_code;
  • Resolve carrier names via the organization units: SELECT f.fund_id, ou.name carrier FROM pay_wc_funds f JOIN hr_all_organization_units ou ON ou.organization_id = f.carrier_id;
  • Cross-check rates against funds: SELECT f.fund_id, r.fund_id FROM pay_wc_funds f LEFT JOIN pay_wc_rates r ON r.fund_id = f.fund_id;
  • Audit recent changes: SELECT fund_id, last_update_date, last_updated_by FROM pay_wc_funds ORDER BY last_update_date DESC;

These queries support reconciliation, data-migration validation, and interface extracts feeding third-party workers' compensation reporting.

Related Objects

  • PAY_WC_RATES — references PAY_WC_FUNDS.FUND_ID; holds the rate detail applied to each fund.
  • HR_ALL_ORGANIZATION_UNITS — parent of BUSINESS_GROUP_ID and CARRIER_ID.
  • HR_LOCATIONS_ALL — parent of LOCATION_ID.
  • PAY_STATE_RULES — parent of STATE_CODE, supplying jurisdiction-level rules.
  • PAY_WC_FUNDS_PK / PAY_WC_FUNDS_U50 — primary and unique constraints enforcing identity and business keys.