Search Results std_cut_off

Overview

APPS.PAY_IE_P45_SUPP_DETAILS is a supplementary database view owned by the APPS schema within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It is classified as a View Type supplementary view used to simplify Oracle Forms coding, meaning it exists primarily to support the P45 processing forms used for Irish payroll rather than to serve as a standalone reporting object. The ETRM metadata explicitly carries Oracle's standard warning that querying or altering data through this view is not recommended and that the definition may change dramatically in subsequent minor or major releases.

The view presents end-of-employment P45 details on a per-assignment, per-pay-period basis. Each row represents a person's payroll assignment for a given reporting period, exposing cumulative pay, tax, PRSI, and Universal Social Charge figures that appear on the Irish P45 documentation. The inclusion of TOTAL_USC and TOTAL_USC_PAY columns makes this view directly relevant to the search term "total_usc," as both attributes relate to the Universal Social Charge introduced into the Irish tax regime.

Underlying Base Objects

The view is defined over a documented set of base objects resolved through the APPS schema. Assignment data is drawn from PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENTS_F, with PER_TIME_PERIODS supplying the pay period definitions and period frequency. Payroll processing context is derived from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ACTION_INFORMATION, while PAY_IE_P45_ARCHIVE provides the P45 archival linkage specific to Irish legislation.

Two PL/SQL packages are also referenced: HR_GENERAL and HR_SECURITY. HR_SECURITY is significant because it enforces row-level security through Business Group and security profile restrictions, filtering the assignment and person records visible to the querying user. The view is itself referenced by the PAY_IE_P45_ARCHIVE package, confirming its role in the archival path of P45 data rather than as a general-purpose transactional source.

Key Columns

• TOTAL_USC (NUMBER): The total Universal Social Charge amount calculated for the assignment in the period, and the object of the user's search.
• TOTAL_USC_PAY (NUMBER): The USC-eligible pay base against which the Universal Social Charge is assessed.
• TOTAL_PAY (NUMBER): Gross pay for the period, essential context alongside the USC figures.
• TOTAL_TAX, TAX_CREDIT, STD_CUT_OFF (NUMBER): Cumulative tax, tax credit, and standard cut-off point values.
• TOTAL_EMPLOYER_PRSI, TOTAL_EMPLOYEE_PRSI, PRSI_CLASS: Employer and employee PRSI contributions plus the PRSI class (VARCHAR2, 30).
• INSURABLE_WEEKS, SUPP_INSURABLE_CLASSA_WEEKS (NUMBER): Insurable week counts used in contribution calculations.
• ASSIGNMENT_ID, PERSON_ID, TAX_UNIT_ID: Identifying keys for the assignment, person, and tax unit.
• DATE_PAID, DATE_OF_LEAVING, PAY_PERIOD, PERIOD_FREQUENCY: Temporal attributes defining the period and leaving date.

Common Use Cases and Queries

Despite the warning against direct use, developers and support analysts frequently reference this view when troubleshooting P45 figures or reconciling USC amounts. A typical reconciliation query retrieves the USC components per assignment.

• USC verification: SELECT PERSON_ID, ASSIGNMENT_ID, PAY_PERIOD, TOTAL_USC_PAY, TOTAL_USC FROM APPS.PAY_IE_P45_SUPP_DETAILS WHERE TOTAL_USC IS NOT NULL;
• Leaver reporting: SELECT ASSIGNMENT_ID, DATE_OF_LEAVING, TOTAL_PAY, TOTAL_TAX, TOTAL_USC FROM APPS.PAY_IE_P45_SUPP_DETAILS WHERE DATE_OF_LEAVING BETWEEN :start_date AND :end_date;
• PRSI analysis: SELECT ASSIGNMENT_ID, PRSI_CLASS, TOTAL_EMPLOYER_PRSI, TOTAL_EMPLOYEE_PRSI FROM APPS.PAY_IE_P45_SUPP_DETAILS WHERE PRSI_CLASS = 'A';

Because HR_SECURITY is applied, results are restricted by the caller's security profile. For production reporting, extraction from base archival tables or the P45 archive package is generally preferred over querying this supplementary view.