Search Results workers_comp2_er




Overview
Explore in AI Chat

Overview

APPS.PAYBV_US_STATE_ARCHIVE is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Applications (APPS) schema. It is registered under the FND Design Data entity PAY.PAYBV_US_STATE_ARCHIVE and carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2. The view exposes archived United States state-level payroll tax results for employees, presenting the accumulated gross, taxable, subject-to-withholding, pre-tax reduction, reduced subject, and withheld or liability balances that payroll processing calculates for each state jurisdiction within a payroll action.

The object serves as a reporting and integration layer over the payroll run results, allowing external reporting tools, extracts, and downstream analytics to read state tax accumulators without navigating the transactional payroll schema directly. Because it is a BIS view, it is intended primarily for ad hoc query, data warehouse extraction, and reporting consumption rather than for update through Application Program Interfaces. The columns align with the terminology used in Oracle Payroll for State Income Tax (SIT), State Disability Insurance (SDI), State Unemployment Insurance (SUI), and Workers' Compensation.

The user search term "sui_er_subj_whable" maps directly to a column exposed by this view: SUI_ER_SUBJ_WHABLE, the employer portion of State Unemployment Insurance subject to withholding.

Underlying Base Objects

According to the documented view metadata, PAYBV_US_STATE_ARCHIVE is defined over the following referenced base objects:

  • PAY_ACTION_INFORMATION (SYNONYM) — supplies the payroll action context, including the action number and related assignment and effective-date information used to anchor the archive rows.
  • PAY_US_EMPLOYEE_PAYSLIP_WEB (PACKAGE) — the US employee payslip web package that produces or drives the state tax balance data surfaced by the view.

The view is therefore an archive-oriented projection of US state payroll tax results, keyed by ACTION_NUMBER, TAX_UNIT_ID, EFFECTIVE_DATE, ASSIGNMENT_ID, and JURISDICTION_CODE. These key columns link each archived state row back to a specific payroll action, a specific employee assignment, a specific tax unit, and a specific state jurisdiction, which is what makes the view suitable for historical and audit reporting.

Key Columns

The column set follows a consistent naming convention across the major state tax categories. Representative columns include:

In particular, SUI_ER_SUBJ_WHABLE represents the employer SUI amount subject to withholding, complementing SUI_EE_SUBJ_WHABLE for the employee portion.

Common Use Cases and Queries

Typical use cases include state tax reconciliation, quarterly SUI/SDI return preparation, Workers' Compensation reporting, and audit extracts of archived payroll actions. The view can also feed a warehouse or BI layer for historical state tax trending by jurisdiction, assignment, and effective date.

Sample query for employer SUI subject-to-withholding by state:

  • SELECT action_number, assignment_id, jurisdiction_code, sui_er_subj_whable, sui_er_liability, effective_date FROM apps.paybv_us_state_archive WHERE jurisdiction_code = :p_jurisdiction ORDER BY effective_date;

Sample query aggregating employee and employer SUI by action:

  • SELECT action_number, SUM(sui_ee_subj_whable) ee_subj, SUM(sui_er_subj_whable) er_subj, SUM(sui_ee_withheld) ee_withheld, SUM(sui_er_liability) er_liability FROM apps.paybv_us_state_archive GROUP BY action_number;

Because the object is a view, these queries are read-only and inherit the access privileges granted on the underlying payroll objects and the APPS schema.