Search Results pay_state_rules




Overview
Explore in AI Chat

Overview

The PAY_STATE_RULES table is a core reference table within the Oracle E-Business Suite (EBS) Human Resources (HR) and Payroll modules, specifically for the US localization. It serves as the master repository for storing and managing fundamental state-level tax and regulatory information required for accurate payroll processing. Its primary role is to provide the foundational state definitions and associated rules that the payroll engine references when calculating state income tax withholdings, unemployment insurance (SUTA), and other state-mandated deductions and contributions for employees. The integrity of data in this table is critical for ensuring compliance with the tax laws of individual US states and territories.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the table's description as "US state tax information" and its primary key on STATE_CODE indicate its core structure. Based on standard Oracle Payroll implementation, this table typically stores attributes for each state code (e.g., 'CA', 'NY', 'TX'). Common columns include the state's abbreviation, full name, legislative state code, effective dates for tax rules, and flags controlling various payroll calculations. It often holds references to default tax rules, unemployment tax rates, and other jurisdictional identifiers necessary for automated tax processing and reporting to state agencies.

Common Use Cases and Queries

This table is primarily accessed for setup, validation, and reporting purposes. A common use case is during the implementation or maintenance of state tax rules, where an administrator queries the table to verify which states are already configured. For reporting, it is frequently joined to assignment and payroll tables to generate state-specific tax summaries. A typical validation query would check for active state rules:

  • SELECT state_code, state_name FROM pay_state_rules WHERE effective_start_date <= SYSDATE AND effective_end_date IS NULL ORDER BY state_code;

Another critical use case is troubleshooting payroll calculations, where a developer might join PAY_STATE_RULES to employee tax records (e.g., PAY_US_EMP_STATE_TAX_RULES_F) to verify the source of a state code used in a calculation.

Related Objects

As indicated by the foreign key metadata, PAY_STATE_RULES is a parent table referenced by several other objects in the Workers' Compensation and job code sub-modules. The documented foreign keys are:

  • PAY_JOB_WC_CODE_USAGES: References STATE_CODE to associate job codes with specific states for Workers' Compensation.
  • PAY_WC_FUNDS: References STATE_CODE to define state-specific Workers' Compensation funds.
  • PAY_WC_STATE_SURCHARGES: References STATE_CODE for state-level surcharge rules.

Furthermore, it is intrinsically linked to key payroll tables such as PAY_US_EMP_STATE_TAX_RULES_F (which holds employee-level state tax settings) and is likely referenced by the legislative rule definitions within the PAY_STATUTORY_RULES_B table that govern the actual tax calculation formulas.