Search Results paybv_us_county_archive




Overview
Explore in AI Chat

Overview

The PAYBV_US_COUNTY_ARCHIVE view is a read-only reporting object owned by the APPS schema within the Oracle E-Business Suite Payroll (PAY) module. It is designed to expose archived United States county-level tax information associated with employee assignment actions. The view consolidates county tax withholding, subject wages, and head tax liability data that Oracle Payroll captures during the payroll action information lifecycle. Because the view is defined WITH READ ONLY, it is intended strictly for query and reporting purposes and cannot be used to modify underlying payroll data. It is valid in both Oracle EBS 12.1.1 and 12.2.2.

In practice, this view serves as a denormalized, human-readable window into the US COUNTY action information category, translating opaque numeric action-information slots into meaningfully named columns suitable for audit reports, tax remittance extracts, and payroll reconciliation queries.

Underlying Base Objects

The view is defined over the synonym PAY_ACTION_INFORMATION (base table typically owned by the APPLSYS or PAY schema) and invokes two packaged PL/SQL functions:

Because two PL/SQL functions are called per row, query performance depends on the volume of US COUNTY action-information records being evaluated.

Key Columns

All numeric slots are wrapped in NVL(...,0) and TO_NUMBER to guarantee numeric output.

Common Use Cases and Queries

Typical scenarios include generating county tax withholding reconciliations, preparing non-resident head-tax reports, and auditing archived payroll actions by assignment.

SELECT ACTION_NUMBER, ASSIGNMENT_ID, EFFECTIVE_DATE,
       JURISDICTION_NAME, STATE, COUNTY_GROSS,
       COUNTY_WITHHELD, HEAD_TAX_WITHHELD
FROM   APPS.PAYBV_US_COUNTY_ARCHIVE
WHERE  ASSIGNMENT_ID = :p_assignment_id
AND    EFFECTIVE_DATE BETWEEN :p_start AND :p_end;

SELECT STATE, SUM(COUNTY_WITHHELD) TOTAL_WITHHELD
FROM   APPS.PAYBV_US_COUNTY_ARCHIVE
WHERE  NON_RESIDENT_FLAG = 'Y'
GROUP  BY STATE;