Search Results balance_category_code




Overview
Explore in AI Chat

Overview

APPS.PAY_US_LOCAL_TAXES_RBR_V is a reporting and integration view within the Oracle E-Business Suite (EBS) Payroll module, specifically scoped to United States local tax processing. It surfaces assignment-level local tax data — city, county, and other jurisdiction-based taxes — in a form suitable for view-only reporting and external integration. The view is an "RBR" (report-by-report / rule-based reporting) construct, meaning it is designed to expose payroll assignment action information alongside computed tax balances for display or downstream consumption rather than for transactional maintenance.

Because it draws from Payroll assignment actions, payroll action definitions, and local tax rules, the view presents a unified snapshot of local tax liability at a given point in the payroll cycle. Its primary role is to expose the relationship between employee assignments, tax units, and the local tax types that apply, along with current, run, quarter-to-date (QTD), and year-to-date (YTD) tax balances computed through packaged business logic. Users searching for tax_type_code will find this column central to the view, as it drives jurisdiction naming, local tax classification, and programmatic balance retrieval.

Underlying Base Objects

The view is defined over a documented set of base objects, joined with an ORDERED hint to control execution order:

Key Columns

  • tax_type_code — the classifier for the local tax (for example CITY or HT). It drives the DECODE used to build LOCAL_TAX_NAME and is passed into the balance function.
  • tax_type_id — surrogate key linking to PAY_US_TAX_TYPES.
  • ee_or_er_code — indicates employee or employer portion.
  • tax_domain_code, balance_category_code, limit_tax_flag — tax classification and limiting attributes.
  • assignment_id, assignment_action_id, tax_unit_id, payroll_action_id — payroll context identifiers.
  • local_tax_name — derived display name combining the tax type code with city name or jurisdiction code.
  • current_val, run_val, qtd_val, ytd_val — computed balances.
  • view_mode, calc_all_timetimes — package-derived flags.

Common Use Cases and Queries

The view supports local tax reporting, verification of assignment-level local tax setup, and feeds to external payroll integrations. A typical query filters by assignment and tax type:

  • Retrieve local taxes for an assignment: 
    SELECT assignment_id, tax_type_code, local_tax_name,
       current_val, run_val, qtd_val, ytd_val
FROM   apps.pay_us_local_taxes_rbr_v
WHERE  assignment_id = :p_assignment_id;
  • Summarize YTD local tax by type: 
    SELECT tax_type_code, SUM(ytd_val)
FROM   apps.pay_us_local_taxes_rbr_v
GROUP BY tax_type_code;
  • Inspect employee versus employer splits using ee_or_er_code alongside balance_category_code.

Because balance columns invoke packaged PL/SQL functions, queries should be filtered narrowly to avoid performance overhead.