Search Results ee_or_er_code




Overview
Explore in AI Chat

Overview

PAY_US_LOCAL_TAXES_RBR_V is a PL/SQL-based reporting view owned by the APPS schema in Oracle E-Business Suite (validated under 12.1.1 and 12.2.2). It belongs to the PAY (Payroll) product family and specifically addresses United States local tax reporting. The view is a "row-by-row" (RBR) construct that resolves city, county, and transit-district withholding balances for an assignment action within the payroll action lifecycle. Rather than residing on physical columns alone, its projection is largely computed through calls to two packaged APIs—PAY_US_BALANCE_VIEW_PKG and PAY_US_TAXBAL_VIEW_PKG—which return period-to-date, run, quarter-to-date, and year-to-date tax balances on demand.

The suffix "RBR" indicates the view is designed to feed a BI Publisher or report-level data model rather than a persistent table. It is typically consumed by US local tax reports (e.g., city/county withholding summaries and reconciliation reports) that must display current, run, QTD, and YTD amounts for each local tax authority, along with the associated employee assignment, action status, and jurisdiction identifiers.

Underlying Base Objects

The view is defined over a mix of assignment/action synonyms and US-specific tax setup and balance synonyms:

A notable characteristic is the literal 'INVALID' text placed in SCHOOL_DISTRICT_NAME/CODE, STATE_NAME/ABBREV, and COUNTY_NAME/ABBREV columns, confirming this view is specialized for city/county local taxes and intentionally blanks out unrelated jurisdictions.

Key Columns

Common Use Cases and Queries

The view is predominantly used in US local tax reporting and payroll reconciliation. A typical query filters to a payroll action and assignment to display all local tax withholding lines with their period balances:

  • City/county withholding detail for a pay run.
  • QTD/YTD local tax reconciliation for a payroll period.
  • Employee-level audit of city tax rule applicability versus actual balances.

Sample SQL:

SELECT assignment_id, assignment_action_id, payroll_action_id, tax_type_code, local_tax_name, ee_or_er_code, current_val, run_val, qtd_val, ytd_val FROM apps.pay_us_local_taxes_rbr_v WHERE payroll_action_id = :p_payroll_action_id AND tax_type_code IN ('CITY','HT') ORDER BY assignment_id, tax_type_code;

Because the balance columns invoke packaged functions, performance is sensitive to indexing on the underlying PAY_ASSIGNMENT_ACTIONS and PAY_US_TAX_BALANCES tables; queries should always be constrained by payroll action or assignment to avoid expensive full scans.