Search Results tax_domain_code




Overview
Explore in AI Chat

Overview

The PAY_US_ASG_RUN_LOCAL_TAX_RBR_V view is a US payroll reporting view defined in the APPS schema under the PAY (Payroll) product module. Its functional purpose is to expose, for a given assignment action within a payroll run, the applicable local (city, county, and related) tax rules together with the tax balance information used at run time. The view belongs to the family of "RBR" (reporting/by-run) balance views that Oracle Payroll uses to drive US local tax reporting and third-party interfaces, including those produced for federal, state, and local tax filing extracts. In Oracle EBS 12.1.1 and 12.2.2 the object remains a standard valid APPS view, and it is referenced by concurrent programs and balance extraction logic that need a denormalized, run-oriented projection of employee local tax rules. The suffix "V" identifies it as a database view rather than a table; it is not maintained directly by users and always reflects current transactional data in the underlying payroll and US tax tables.

Underlying Base Objects

The view is defined over a set of APPS synonyms that resolve to the core Oracle Payroll and US Payroll tax tables, plus two PL/SQL packages that are called inline within the SELECT. The documented base objects are PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS (aliased PAA), PAY_RUN_BALANCES, PAY_DEFINED_BALANCES, PAY_US_ASG_REPORTING, PAY_US_CITY_NAMES, PAY_US_CITY_TAX_INFO_F, PAY_US_COUNTIES, PAY_US_COUNTY_TAX_INFO_F, PAY_US_EMP_CITY_TAX_RULES_F, PAY_US_EMP_COUNTY_TAX_RULES_F, PAY_US_TAX_BALANCES, and PAY_US_TAX_TYPES, together with the packages PAY_US_BALANCE_VIEW_PKG and PAY_US_TAXBAL_VIEW_PKG. Functionally, it joins the assignment action and payroll action records to the effective-dated employee city tax rules, resolved city/county names, city tax information, and the tax type definitions, producing a run-scoped view of the taxes that should apply. The packages supply derived attributes — view mode, the calculate-all-time-types flag, and the run-time tax balance value — rather than static columns.

Key Columns

The projection exposes the assignment and action identifiers (ASSIGNMENT_ID, ASSIGNMENT_ACTION_ID, PAYROLL_ACTION_ID, ACTION_STATUS, ACTION_TYPE), the TAX_UNIT_ID and effective date, and jurisdiction information derived from the city tax rules (JURISDICTION_CODE). Tax identity is conveyed through TAX_TYPE_ID, TAX_TYPE_CODE, TAX_DOMAIN_CODE, EE_OR_ER_CODE (employee or employer liability), LIMIT_TAX_FLAG, and BALANCE_CATEGORY_CODE. Name-level attributes are drawn from PAY_US_CITY_NAMES as CITY_NAME, CITY_CODE, STATE_CODE, COUNTY_CODE, with placeholder columns for SCHOOL_DISTRICT_NAME, SCHOOL_DISTRICT_CODE, STATE_NAME, STATE_ABBREV, COUNTY_NAME, and COUNTY_ABBREV set to the literal 'INVALID'. The derived LOCAL_TAX_NAME column — the term most often searched by report developers — concatenates TAX_TYPE_CODE with the city name or jurisdiction code, producing values such as "CITY-Seattle". Additional derived columns are VIEW_MODE, CALC_ALL_TIMETYPES, and RUN_VAL, which returns the run-time tax balance through PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM.

Common Use Cases and Queries

Typical uses include US local tax register reporting, reconciliation of run-time balances against calculated local tax deductions, and extraction feeds for local tax filing. A representative query filters by payroll action and assignment:

  • List local taxes for a payroll run: SELECT local_tax_name, assignment_id, tax_type_code, ee_or_er_code, run_val FROM pay_us_asg_run_local_tax_rbr_v WHERE payroll_action_id = :p_action_id ORDER BY assignment_id, local_tax_name;
  • Locate a tax by its reporting name: SELECT assignment_id, payroll_action_id, local_tax_name FROM pay_us_asg_run_local_tax_rbr_v WHERE local_tax_name LIKE 'CITY-%';
  • Compare employee vs. employer liability: SELECT local_tax_name, ee_or_er_code, run_val FROM pay_us_asg_run_local_tax_rbr_v WHERE assignment_action_id = :p_aa_id;

Because LOCAL_TAX_NAME is a concatenation of TAX_TYPE_CODE and the resolved city or jurisdiction value, it is the primary search key when the business requirement references a local tax by display name. Queries should always constrain on PAYROLL_ACTION_ID or ASSIGNMENT_ACTION_ID, since the view is not indexed independently and returns rows for all assignments processed within a run.