Search Results p45_3_send_edi

Overview

The APPS.PAY_P45_3_ASG_INFO_V view is a payroll reporting object within the Oracle E-Business Suite (EBS) Payroll (PAY) product, available in release levels 12.1.1 and 12.2.2. It presents statutory P45 Part 3 data captured against an assignment. In United Kingdom payroll processing, a P45 is the document issued when an employee leaves employment; Part 3 records details of the previous employment and the pay and tax figures carried forward to the new employer. This view exposes those stored values in a denormalized, report-friendly form, mapping generic assignment extra information segments to meaningful column names.

The view is defined with a single filter, WHERE AEI.INFORMATION_TYPE = 'GB_P45_3', so it returns only assignment extra information rows classified as P45 Part 3 for the United Kingdom legislative context. The object metadata lists it with status VALID and owner APPS, and the documented base objects are PER_ASSIGNMENT_EXTRA_INFO and HR_GENERAL. Because the search term "date_left_prev_emp" maps to a specific column in this view, it is frequently used when reporting or integrating the date on which an employee left their previous employer.

Underlying Base Objects

The view is defined over PER_ASSIGNMENT_EXTRA_INFO, referenced through a synonym and aliased as AEI. This table stores additional assignment-level information addressed by information type and a set of generic information attributes (AEI_INFORMATION1 through AEI_INFORMATION11). The view selects only rows where INFORMATION_TYPE equals 'GB_P45_3' and relies on the assignment identifier, ASSIGNMENT_ID, as its foreign key to the assignment record.

The second documented base object, HR_GENERAL, is a package rather than a table. It is invoked inside the view text through the function HR_GENERAL.DECODE_LOOKUP, which resolves lookup codes into their display meanings. This function is applied to AEI_INFORMATION5 and AEI_INFORMATION6 to produce the DISPLAY_PREV_TAX_BASIS and D_PRV_EMP_LAST_PAY_PERIOD_TYPE columns, using the lookup types GB_TAX_BASIS and GB_PREV_PAYMENT_TYPE respectively. The derived values are truncated to 80 characters, a defensive measure consistent with lookup value sizing.

Key Columns

• P45_3_ASG_EXTRA_INFO_ID — Primary identifier of the underlying PER_ASSIGNMENT_EXTRA_INFO row.
• ASSIGNMENT_ID — Assignment to which the P45 Part 3 record belongs; the principal join key.
• INFORMATION_TYPE — Always 'GB_P45_3' for rows returned by this view.
• DATE_LEFT_PREV_EMP — Derived from AEI_INFORMATION3; the date the employee left the previous employment, the most commonly searched value.
• PREVIOUS_TAX_DISTRICT, PREVIOUS_TAX_CODE, PREVIOUS_TAX_BASIS — Carried-forward tax identifiers and basis from the prior employment.
• DISPLAY_PREV_TAX_BASIS — Decoded, human-readable form of PREVIOUS_TAX_BASIS via GB_TAX_BASIS.
• PREV_EMP_LAST_PAY_PERIOD_TYPE and D_PRV_EMP_LAST_PAY_PERIOD_TYPE — Coded and decoded previous pay period frequency (GB_PREV_PAYMENT_TYPE).
• PREV_EMP_LAST_PAYMENT_PERIOD — The last payment period recorded from the previous employer.
• P45_3_SEND_EDI and P45_3_SEND_EDI_FLAG — Indicators controlling electronic (EDI) submission of the P45 Part 3.
• P45_3_PREV_TAX_PAID_NOTIFIED, P45_3_NOT_PAID_BET_START_N5APR, P45_3_CONTINUE_SL_DEDUCTIONS — Statutory flags covering previous tax paid notification, non-payment between the start of the tax year and 5 April, and continuation of student loan deductions.
• P45_3_OBJECT_VERSION_NUM — Optimistic locking version number.

Common Use Cases and Queries

Typical usage covers P45 Part 3 reporting, UK payroll data validation, and integration feeds delivering previous-employment data to downstream systems. A common query retrieves the date left previous employment together with tax details for surviving assignments:

SELECT ASSIGNMENT_ID, DATE_LEFT_PREV_EMP, PREVIOUS_TAX_DISTRICT,
PREVIOUS_TAX_CODE, DISPLAY_PREV_TAX_BASIS, PREV_EMP_LAST_PAYMENT_PERIOD,
P45_3_SEND_EDI_FLAG
FROM APPS.PAY_P45_3_ASG_INFO_V
WHERE ASSIGNMENT_ID = :p_assignment_id;

A second pattern validates EDI readiness by filtering on the send flags and the previous tax paid notification before transmitting P45 Part 3 data. Because the view exposes only a subset of the eleven generic information attributes, additional P45 columns must be read directly from PER_ASSIGNMENT_EXTRA_INFO when required.