Search Results sit_wk

Overview

APPS.PAY_US_STATE_TAX_TYPES_V is a reporting and integration view in the Oracle E-Business Suite (EBS) HRMS payroll schema, available in Release 12.1.1 and 12.2.2. It consolidates United States state-level tax type definitions with their associated payroll element types and tax balances, presenting a single denormalized result set that joins statutory tax configuration to the payroll elements through which those taxes are processed. The view is restricted to state tax domain records (TAX_DOMAIN_CODE = 'STATE') and to employee-side balances, making it a focused dictionary of employee state tax obligations such as State Income Tax (SIT), State Disability Insurance (SDI), and State Unemployment Insurance (SUI).

Because the base tax configuration tables are highly normalized, this view serves as a convenient reporting surface for technical consultants and integrators who need to correlate a tax type with the element name, element type identifier, balance category, and effective dating without writing the multi-table join themselves. It is commonly referenced in USA payroll statutory reporting, balance feeds, and custom extracts.

Underlying Base Objects

The view is defined over four documented base objects owned by APPS (referenced via synonyms):

• PAY_US_TAX_TYPES (PUTT) — holds the tax type definition, including TAX_TYPE_ID, TAX_TYPE_CODE, TAX_DOMAIN_CODE, and LIMIT_TAX_FLAG.
• PAY_US_TAX_BALANCES (PUTB) — holds the balance mapping for each tax type, including BALANCE_CATEGORY_CODE, EE_OR_ER_CODE, and USER_REPORTING_NAME.
• PAY_ELEMENT_TYPES_F (PET) — the payroll element type definition, contributing ELEMENT_TYPE_ID, effective dates, BUSINESS_GROUP_ID, PROCESSING_PRIORITY, and LEGISLATION_CODE.
• PAY_ELEMENT_TYPES_F_TL (PETTL) — the translated element name table, contributing ELEMENT_NAME filtered by USERENV('LANG').

The joins key on ELEMENT_TYPE_ID (PET to PETTL), TAX_TYPE_ID (PUTT to PUTB), and a decode-driven match between the element name and TAX_TYPE_CODE. Only elements named SIT_WK, SDI_EE, SUI_EE, STEIC_WK, Workers Compensation, and Workers Compensation2 EE are returned.

Key Columns

• TAX_TYPE_ID — surrogate identifier of the state tax type.
• TAX_TYPE_CODE — short code (SIT, SDI, SUI, STEIC, WC, WC2), matched to the element name via a DECODE expression.
• LIMIT_TAX_FLAG — indicates whether the tax is subject to a wage limit.
• BALANCE_CATEGORY_CODE — restricted to 'WITHHELD' or 'ADVANCED'.
• EE_OR_ER_CODE — fixed to 'EE', confirming employee-side balances.
• USER_REPORTING_NAME — reporting label for the balance.
• ELEMENT_NAME — translated payroll element name.
• ELEMENT_TYPE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, BUSINESS_GROUP_ID, PROCESSING_PRIORITY, LEGISLATION_CODE — element-level attributes supporting date-effective and legislative filtering.

Common Use Cases and Queries

A frequent scenario is locating the tax type and balance configuration behind the SUI_EE element. The following query returns SUI records:

• SELECT tax_type_code, element_name, balance_category_code, user_reporting_name FROM apps.pay_us_state_tax_types_v WHERE element_name = 'SUI_EE';
• SELECT tax_type_id, tax_type_code, element_type_id, effective_start_date, effective_end_date FROM apps.pay_us_state_tax_types_v WHERE userenv('LANG') IS NOT NULL ORDER BY tax_type_code;

The view supports reconciliation of statutory tax types against their payroll elements, validation of effective-dated element definitions, and construction of custom state tax extracts. Because it filters to employee-side state taxes, it should not be used to retrieve employer tax liabilities.