Search Results school_subject




Overview
Explore in AI Chat

Overview

PAYBV_US_SCHOOL_ARCHIVE is a read-only Oracle EBS database view owned by the APPS schema and validated as VALID in the PAY (Payroll) product. It exposes archived United States school district tax information captured during payroll processing. The view derives its content exclusively from rows in PAY_ACTION_INFORMATION where the ACTION_INFORMATION_CATEGORY equals 'US SCHOOL DISTRICT'. Its purpose is to present, in a flattened and analytically usable form, the state and local school district withholding, subject, and pre-tax reduction amounts recorded against processed payroll actions.

Because the view is declared WITH READ ONLY and is prefixed with the PAYBV naming convention, it is oriented toward Business View/reporting consumption rather than transactional maintenance. Administrators, payroll analysts, and reporting integrators use it to reconcile school district tax activity by assignment, jurisdiction, and date without needing to parse the raw ACTION_INFORMATION1 through ACTION_INFORMATION5 flexfields directly. In Oracle EBS 12.1.1 and 12.2.2 the object is delivered as a database view and is queried through standard SQL or through reporting tools such as Oracle Reports, BI Publisher, and Oracle Discoverer.

Underlying Base Objects

The documented base dependencies for PAYBV_US_SCHOOL_ARCHIVE are:

The view therefore does not maintain its own storage; it is a logical projection over action information rows joined logically to two payroll packages for descriptive enrichment. The relationship is one-to-many from payroll actions to school district information records, with each row identifiable by ACTION_CONTEXT_ID, ASSIGNMENT_ID, and EFFECTIVE_DATE.

Key Columns

All numeric fields are wrapped in NVL(...,0) so absent values resolve to zero, simplifying aggregation.

Common Use Cases and Queries

Typical uses include auditing school district withholding per assignment, verifying taxable subject amounts against gross, and feeding downstream payroll tax reconciliation reports. A representative query totals withheld and gross amounts by jurisdiction:

  • SELECT JURISDICTION_NAME, STATE, SUM(SCHOOL_GROSS) GROSS, SUM(SCHOOL_WITHHELD) WITHHELD FROM PAYBV_US_SCHOOL_ARCHIVE GROUP BY JURISDICTION_NAME, STATE;
  • SELECT ASSIGNMENT_ID, EFFECTIVE_DATE, SCHOOL_SUBJECT, SCHOOL_REDUCED_SUBJECT FROM PAYBV_US_SCHOOL_ARCHIVE WHERE TAX_UNIT_ID = :tax_unit_id;
  • SELECT * FROM PAYBV_US_SCHOOL_ARCHIVE WHERE ASSIGNMENT_ID = :assignment_id ORDER BY EFFECTIVE_DATE;

Because the view is read only, it is safe for ad hoc querying; no DML should be attempted against it.