Search Results p46_pen_send_edi

Overview

APPS.PAY_P46_PENNOT_ASG_INFO_V is a reporting and integration view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes United Kingdom P46 Pension Notification (P46 PENNOT) data held against employee assignments. The P46 Pension Notification is a statutory UK HM Revenue & Customs filing used by employers to report employees who receive a pension but are not required to complete a P45 or standard P46. This view provides a stable, business-friendly projection of that legislative data, translating the generic descriptive flexfield storage model of Oracle HRMS into named, purpose-specific columns.

The view filters a single underlying HRMS table for one specific information type, presenting each P46 PENNOT record alongside assignment context. It plays a supporting role in payroll reporting, extract generation, and downstream EDI or RTI processing, where pension notification data must be selected, validated, and transmitted.

Underlying Base Objects

The view is owned by APPS and is defined over a single referenced object: PER_ASSIGNMENT_EXTRA_INFO, accessed through a synonym. PER_ASSIGNMENT_EXTRA_INFO stores legislative and user-defined assignment-level information in a generic structure comprising an information type, an information category, and a series of thirty descriptive flexfield segments (AEI_INFORMATION1 through AEI_INFORMATION30), plus a primary key and an object version number for optimistic locking.

The view applies the predicate AEI.INFORMATION_TYPE = 'GB_P46PENNOT', restricting output to records of that type only. For each qualifying row it maps the flexfield segments to semantic aliases, so the eleven used segments correspond to named pension-notification attributes. No joins or aggregations are performed; the view is a direct filtered and renamed projection of the base table.

Key Columns

• P46_PEN_ASG_EXTRA_INFO_ID — Surrogate key of the underlying assignment extra information record (ASSIGNMENT_EXTRA_INFO_ID).
• ASSIGNMENT_ID — Identifier of the assignment to which the P46 pension notification applies.
• INFORMATION_TYPE — Always 'GB_P46PENNOT' in this view; the discrimination value.
• AEI_INFORMATION_CATEGORY — The descriptive flexfield context (category) under which the segment values were entered.
• P46_PEN_OBJECT_VERSION_NUM — Object version number supporting concurrent-update detection.
• P46_PEN_SEND_EDI (AEI_INFORMATION1) — Flag indicating whether the notification is to be sent via EDI.
• ANNUAL_PENSION (AEI_INFORMATION2) — The annual pension amount for the employee.
• DATE_PENSION_STARTED (AEI_INFORMATION3) — Date the pension commenced.
• P46_PENNOT_SEND_EDI_FLAG (AEI_INFORMATION4) — Additional EDI transmission flag for the P46 PENNOT.
• PREVIOUS_TAX_DISTRICT (AEI_INFORMATION5) — Tax district reference from the previous employment.
• DATE_LEFT_PREV_EMP (AEI_INFORMATION6) — Leaving date from the previous employer.
• PREVIOUS_TAX_CODE (AEI_INFORMATION7) — Tax code applied in the previous employment.
• PREVIOUS_TAX_BASIS (AEI_INFORMATION8) — Tax basis from the previous employment.
• PREV_EMP_LAST_PAY_PERIOD_TYPE (AEI_INFORMATION9) — Pay period type of the last payment from the previous employer.
• PREV_EMP_LAST_PAYMENT_PERIOD (AEI_INFORMATION10) — The last payment period figure.
• RECENTLY_BEREAVED (AEI_INFORMATION11) — Bereavement indicator affecting pension or tax treatment.

Common Use Cases and Queries

Typical uses include extracting P46 pension notification data for a given assignment, feeding EDI or Real Time Information submissions, and auditing stored pension values for UK payroll compliance. Because the view resolves the flexfield segments into named columns, it simplifies report SQL considerably.

Retrieve all pension notification records for an assignment:

• SELECT assignment_id, annual_pension, date_pension_started, previous_tax_code
• FROM apps.pay_p46_pk asg_info_v
• WHERE assignment_id = :p_assignment_id;

Identify records flagged for EDI transmission:

• SELECT p46_pen_asg_extra_info_id, assignment_id, p46_pen_send_edi
• FROM apps.pay_p46_pennot_asg_info_v
• WHERE p46_pen_send_edi = 'Y';

Report bereavement cases within a date range:

• SELECT assignment_id, recently_bereaved, date_pension_started
• FROM apps.pay_p46_pennot_asg_info_v
• WHERE recently_bereaved = 'Y';

Correlating with PER_ASSIGNMENTS on ASSIGNMENT_ID yields employee and payroll identifiers for statutory reporting. Queries should respect the INFORMATION_TYPE filter already enforced by the view.