Search Results sit_subject




Overview
Explore in AI Chat

Overview

APPS.PAY_US_STATE_ACTION_INFO_V is a reporting view in the Oracle E-Business Suite Payroll (PAY) schema that consolidates United States state-level statutory tax and wage information for a given payroll action and assignment. It is an internal, read-only view (FND Design Data: PAY.PAY_US_STATE_ACTION_INFO_V) owned by the APPS schema and marked VALID in ETRM 12.2.2. The view exposes jurisdiction context alongside taxable, subject, reduced-subject, pre-tax deduction, and withheld or liability amounts for State Income Tax (SIT), State Disability Insurance employee and employer portions (SDI_EE / SDI_ER), State Unemployment Insurance employee and employer portions (SUI_EE / SUI_ER), and several Workers' Compensation categories.

The view is explicitly flagged "Oracle Internal Use Only." Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. Any use should therefore be treated as diagnostic or investigative rather than as a supported integration interface. The columns relating to SUI_EE_SUBJ_WHABLE and SUI_ER_SUBJ_WHABLE correspond directly to the search term "sui_er_subj_whable," which is a stored column name in this view and not a standalone database object.

Underlying Base Objects

Per documented view metadata, PAY_US_STATE_ACTION_INFO_V is defined over two referenced objects:

  • PAY_ACTION_INFORMATION (SYNONYM) — the action-level payroll results store that supplies the state tax and wage balances for a payroll action, assignment, and effective date.
  • PAY_US_EMPLOYEE_PAYSLIP_WEB (PACKAGE) — the US payslip web package, which supplies jurisdiction naming and presentation logic used to shape the view's output.

Because the view is layered over the action information synonym and calls into a package, its row population and derived jurisdiction names depend on those underlying definitions rather than a single physical base table. This layering is typical of internal PAY reporting views and explains why the source cannot be treated as a stable public interface.

Key Columns

Common Use Cases and Queries

Typical usage is reconciliation and audit of state tax balances for a payroll action, verification of SUI employer subject amounts, and investigation of SIT/SDI/SUI figures during troubleshooting. A representative query filters by action and assignment:

  • SELECT jurisdiction_code, jurisdiction_name, assignment_id, effective_date, sui_ee_subj_whable, sui_er_subj_whable, sui_er_liability FROM apps.pay_us_state_action_info_v WHERE action_number = :action_number;
  • SELECT jurisdiction_code, sit_withheld, sdi_ee_withheld, sui_ee_withheld FROM apps.pay_us_state_action_info_v WHERE assignment_id = :assignment_id AND effective_date BETWEEN :start_date AND :end_date;

Because the object is internal and unsupported for external access, queries should be limited to authorized diagnostic activity and executed read-only.