Search Results other_insurable_weeks

Overview

The APPS.PAY_IE_P45_PRSI_DETAILS view is a supplementary Oracle E-Business Suite database object residing in the APPS schema and registered under the FND Design Data identifier PAY.PAY_IE_P45_PRSI_DETAILS. It is classified as a VIEW with a VALID status in both the 12.1.1 and 12.2.2 releases. Its stated purpose, per the ETRM metadata, is to simplify forms coding rather than to serve as a general-purpose data source. Oracle explicitly warns that this view is not recommended for direct querying or data alteration, because its definition may change dramatically in subsequent minor or major releases.

The view supports Irish Pay As You Earn (PAYE) and Pay-Related Social Insurance (PRSI) statutory reporting, specifically the data required for P45 processing. It consolidates per-assignment PRSI contribution totals and insurable week counts at the assignment action level, allowing the P45 archive and related forms logic to retrieve aggregated PRSI figures without assembling them from multiple base tables.

Underlying Base Objects

The ETRM dependency documentation lists the following referenced objects:

• PAY_ACTION_INFORMATION (SYNONYM) — provides action-level detail associated with the assignment action.
• PAY_ASSIGNMENT_ACTIONS (SYNONYM) — the principal source of assignment-level action records driving the join.
• PAY_IE_P45_ARCHIVE (PACKAGE) — the Irish P45 archiving package; the view both references and is referenced by it, reflecting a tightly coupled relationship for P45 data extraction.
• PAY_PAYROLL_ACTIONS (SYNONYM) — supplies payroll action context.

Because the view is defined over these base objects, each row corresponds to an assignment action within a payroll action, enriched with PRSI and insurable-week aggregates extracted via the P45 archive logic.

Key Columns

The view exposes the following columns:

• ASSIGNMENT_ACTION_ID (NUMBER, 15) — the unique identifier linking the row to the originating assignment action. This is the primary key of the result set.
• TOTAL_EMPLOYER_PRSI (NUMBER) — the total employer PRSI contribution amount.
• TOTAL_EMPLOYEE_PRSI (NUMBER) — the total employee PRSI contribution amount.
• INSURABLE_WEEKS (NUMBER) — the total number of insurable weeks recorded. This is the column most commonly referenced by users searching on this view.
• CLASS_A_INSURABLE_WEEKS (NUMBER) — the subset of insurable weeks attributable to Class A PRSI contributions.
• OTHER_INSURABLE_WEEKS (VARCHAR2, 40) — a descriptive or formatted field capturing insurable weeks falling outside the standard Class A treatment.

The INSURABLE_WEEKS and CLASS_A_INSURABLE_WEEKS numeric columns are central to Irish P45 reporting, where the count of insurable weeks determines contribution liability and statutory leave entitlements.

Common Use Cases and Queries

Typical usage centers on retrieving PRSI totals and insurable week counts for a specific assignment action during P45 generation or reconciliation. A basic query is:

SELECT ASSIGNMENT_ACTION_ID, TOTAL_EMPLOYER_PRSI, TOTAL_EMPLOYEE_PRSI, INSURABLE_WEEKS, CLASS_A_INSURABLE_WEEKS, OTHER_INSURABLE_WEEKS FROM APPS.PAY_IE_P45_PRSI_DETAILS;

To isolate high insurable week counts:

SELECT ASSIGNMENT_ACTION_ID, INSURABLE_WEEKS FROM APPS.PAY_IE_P45_PRSI_DETAILS WHERE INSURABLE_WEEKS > 52;

Because the view is forms-oriented and Oracle discourages direct access, production queries should generally be routed through the PAY_IE_P45_ARCHIVE package or the supported concurrent programs that populate P45 archive tables. Where direct querying is unavoidable, treat the view as read-only, avoid binding it into custom interfaces, and expect its column set to evolve across point releases.