Search Results works_no

Overview

APPS.PAY_IE_P45_EMPLOYEE_DETAILS is a supplementary view in the Oracle E-Business Suite APPS schema that supports the Irish P45 end-of-employment reporting process. ETRM documentation classifies it as a "supplementary view used to simplify forms coding," and it is registered under the FND Design Data identifier PAY.PAY_IE_P45_EMPLOYEE_DETAILS with a status of VALID. The view exposes the employee-level attributes required to populate a P45 form when an assignment leaves employment, combining personal identifiers, Revenue-related reference numbers, and the key employment dates that drive the statutory return.

Because it is a forms-coding convenience view rather than a public interface, Oracle explicitly warns that the view should not be queried or altered directly and that it may change dramatically in subsequent minor or major releases. For this reason, the view is best regarded as an internal dependency of the Irish payroll P45 process rather than a supported reporting API. The user search term "date_of_leaving" maps directly to the DATE_OF_LEAVING column exposed by this view, which is the leaver date carried onto the P45.

Underlying Base Objects

Per the documented dependency information, the view is defined over the following APPS base objects: PAY_ACTION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, PAY_LEGISLATION_RULES, PAY_PAYROLL_ACTIONS (all referenced as synonyms), and the FND_DATE package. These sources supply the payroll action context (PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INFORMATION), the legislative rules that govern the Irish P45 calculation (PAY_LEGISLATION_RULES), and date handling utilities (FND_DATE). The join across these objects lets the view present, for a given assignment action, both payroll-processing identifiers (ASSIGNMENT_ACTION_ID, ASSIGNMENT_ID, TAX_UNIT_ID) and the descriptive employee data needed by the P45 form.

Downstream, the view is referenced by the APPS.PAY_IE_P45_ARCHIVE object and is also exposed under a PUBLIC synonym PAY_IE_P45_EMPLOYEE_DETAILS. This indicates that the archive process and any form or concurrent program that builds the P45 archive consume the view's columns directly, making it a structural dependency of the Irish P45 archival mechanism rather than a standalone reporting entity.

Key Columns

• ASSIGNMENT_ACTION_ID (NUMBER(15)) — Identifier of the payroll assignment action that triggered the P45.
• ASSIGNMENT_ID (NUMBER(10)) — The assignment being terminated; links to the employee's payroll record.
• LAST_NAME, FIRST_NAME (VARCHAR2(240)) — Employee name fields printed on the P45.
• PPS_NO, WORKS_NO (VARCHAR2(240)) — Irish Revenue identifiers (Personal Public Service Number and employer/works number).
• DATE_OF_BIRTH (DATE) — Employee date of birth.
• DATE_OF_COMMENCEMENT (DATE) — Employment start date used to compute total pay and tax for the P45.
• DATE_OF_LEAVING (DATE) — The leaving date reported on the P45; the primary column matching the search term.
• DECEASED (VARCHAR2(240)) — Flag indicating the leaver is deceased.
• PERSON_ID, TAX_UNIT_ID — Party identifier and tax unit reference for the employee.

Common Use Cases and Queries

The view is typically used to derive P45 output for a leaver. A minimal query selecting the leaver date and core identifiers would be:

• SELECT assignment_id, person_id, pps_no, date_of_leaving, date_of_commencement FROM apps.pay_ie_p45_employee_details;
• Filter by a specific action or assignment: SELECT * FROM apps.pay_ie_p45_employee_details WHERE assignment_action_id = :action_id;

Because Oracle advises against direct querying, production integrations should prefer the supported payroll interfaces or the PAY_IE_P45_ARCHIVE process, using this view only for diagnostic or upgrade-impact analysis.