Search Results pay_job_wc_code_usages




Overview
Explore in AI Chat

Overview

The PAY_JOB_WC_CODE_USAGES table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It functions as a configuration and reference table that stores Workers Compensation (WC) code assignments for specific combinations of jobs and states. Its primary role is to enable the accurate calculation and reporting of Workers Compensation insurance premiums by linking a defined job within the organization to the appropriate statutory WC code mandated for that job's activities within a particular U.S. state or jurisdiction. This table ensures payroll processing adheres to regional insurance regulations by providing the necessary mapping logic between organizational roles and legal codes.

Key Information Stored

The table's structure is designed to enforce unique combinations of job and state, forming the basis of its primary key. Key columns include JOB_ID, which references the job definition from PER_JOBS, and STATE_CODE, which references the jurisdiction from PAY_STATE_RULES. The central piece of data is the Workers Compensation code itself, typically stored in a column such as WC_CODE (implied by the table's purpose, though not explicitly listed in the provided metadata). The BUSINESS_GROUP_ID column links the record to the specific HR organization unit (HR_ALL_ORGANIZATION_UNITS), enforcing data security at the Business Group level. Additional columns likely exist to track effective dates, creation, and update information, which are standard in EBS HR/Payroll tables.

Common Use Cases and Queries

This table is primarily accessed during payroll runs and for compliance reporting. A common operational use case is the validation of WC code assignments when setting up a new job or when an employee's job or work state changes. For reporting, it is frequently joined to job and state descriptions to produce clear audit trails. A typical query pattern retrieves the assigned code for a specific job and state:

  • SELECT pjwc.wc_code, pj.name job_name, psr.state_name FROM pay_job_wc_code_usages pjwc, per_jobs pj, pay_state_rules psr WHERE pjwc.job_id = pj.job_id AND pjwc.state_code = psr.state_code AND pjwc.business_group_id = :p_bg_id;

Another critical use case is identifying gaps in configuration, such as jobs missing a required WC code for a state where the organization operates, which can be identified via anti-joins between job/state combinations and this table.

Related Objects

As indicated by its foreign key constraints, PAY_JOB_WC_CODE_USAGES has direct dependencies on several fundamental HR and Payroll tables. It is a child table of PER_JOBS (for job definitions) and PAY_STATE_RULES (for state jurisdiction definitions). It also references HR_ALL_ORGANIZATION_UNITS for Business Group context. This table is a likely reference point for payroll calculation engines and may be accessed by key Payroll APIs or views responsible for generating wage and tax reports that include Workers Compensation data. Its data is essential for the proper functioning of the Workers Compensation component within the Oracle Payroll process.