Search Results subj_whable

Overview

APPS.PAY_US_STATE_EE_WAGE_TYPES_V is a U.S. legislative reporting view in Oracle E-Business Suite Payroll (Oracle Payroll, Oracle Human Resources). Its purpose is to expose the mapping between U.S. state-level tax types, their associated subject balances, and the payroll element types that implement them for the employee withholding side. The view is defined with a filter restricting results to employee-level (EE) balances and to state-domain tax types, so it effectively returns the set of wage element types that feed state withholding subject balances.

The view is relevant to users investigating the SUBJ_WHABLE balance category, which stands for "subject to withholding." A SUBJ_WHABLE balance represents earnings or wage amounts that are subject to state income tax withholding. The view is typically used in reporting, troubleshooting, and integration contexts where it is necessary to identify which element types contribute to state withholding subject balances, or to reconcile payroll element definitions against the tax balances they update.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is owned by the APPS schema and is defined over four referenced base objects, each accessed through a synonym:

• PAY_ELEMENT_TYPES_F (SYNONYM) — the base element type definitions, including effective dating, legislation, business group, and processing priority.
• PAY_ELEMENT_TYPES_F_TL (SYNONYM) — the translated (language-dependent) element type names, joined on LANGUAGE = USERENV('LANG').
• PAY_US_TAX_TYPES (SYNONYM) — U.S. tax type definitions, including TAX_TYPE_CODE, TAX_DOMAIN_CODE, and LIMIT_TAX_FLAG.
• PAY_US_TAX_BALANCES (SYNONYM) — the association of tax types to balances, including BALANCE_CATEGORY_CODE, EE_OR_ER_CODE, and USER_REPORTING_NAME.

The joins link element types to their translated names, tax types to tax balances via TAX_TYPE_ID, and tax types to element types through a substring match on the element name (TAX_TYPE_CODE = SUBSTR(ELEMENT_NAME,1,3)). Filters exclude employer-side elements, arrears, and specific disability/SUI subject elements.

Key Columns

• TAX_TYPE_ID, TAX_TYPE_CODE, TAX_DOMAIN_CODE — identify the state tax type; TAX_DOMAIN_CODE is constrained to 'STATE'.
• LIMIT_TAX_FLAG — indicates whether the tax type is subject to a wage limit; drives the conditional balance category logic.
• BALANCE_CATEGORY_CODE — the balance category, including SUBJECT, SUBJ_WHABLE, SUBJ_NWHABLE, or TAXABLE.
• EE_OR_ER_CODE — employee or employer indicator; restricted to 'EE' in the view predicate.
• USER_REPORTING_NAME — the reporting label associated with the tax balance.
• ELEMENT_NAME — the translated element type name.
• ELEMENT_TYPE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — element type identity and effective dating.
• BUSINESS_GROUP_ID, PROCESSING_PRIORITY, LEGISLATION_CODE — business group, processing priority, and legislation context of the element type.

Common Use Cases and Queries

Typical scenarios include verifying which element types update a state withholding subject balance, auditing state tax setup, and supporting migration or integration mapping. The conditional predicate ensures limited tax types return SUBJECT/TAXABLE categories, while non-limited tax types return SUBJECT, SUBJ_WHABLE, and SUBJ_NWHABLE.

Example 1 — list all state withholding subject wage types:

SELECT element_name, tax_type_code, balance_category_code, user_reporting_name
FROM   apps.pay_us_state_ee_wage_types_v
WHERE  balance_category_code = 'SUBJ_WHABLE'
ORDER BY tax_type_code, element_name;

Example 2 — count element types per state tax type:

SELECT tax_type_code, COUNT(*) element_count
FROM   apps.pay_us_state_ee_wage_types_v
GROUP BY tax_type_code
ORDER BY tax_type_code;

Example 3 — inspect effective dating for a specific element type:

SELECT element_type_id, element_name, effective_start_date, effective_end_date
FROM   apps.pay_us_state_ee_wage_types_v
WHERE  element_name = :element_name;