Search Results pay_p45_v1




Overview
Explore in AI Chat

Overview

PAY_P45_V1 is a United Kingdom-specific view owned by the APPS schema within the PAY (Payroll) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is defined over PER_PEOPLE_F and related HR and Payroll objects, and its purpose is to select employees who are candidates for the statutory P45 report — the form issued in the UK when an employee leaves employment. The view consolidates termination, assignment, person, and organization data into a single flattened row set that the P45 reporting process and associated concurrent programs can consume directly.

Because the view is a database object rather than a report definition, it serves as the data access layer for P45 processing. It is particularly relevant to implementers and technical consultants who need to query leaver data outside of the standard report, to troubleshoot P45 generation, or to build custom extracts. The view embeds HR security and language-dependent organization name resolution, which means results can vary by the session's language setting and the responsibility's security profile.

Underlying Base Objects

According to the documented ETRM metadata, PAY_P45_V1 references the following base objects:

The view definition combines a UNION of two branches: one driven by periods of service with a non-null ACTUAL_TERMINATION_DATE, and one driven by the GB_P45 extra information flag on assignments. This structure ensures that leavers are captured both through the period-of-service termination path and through the assignment-level P45 flag path.

Key Columns

  • BUSINESS_GROUP_ID — identifies the HR business group, supporting multi-organization filtering.
  • PERSON_ID and ASSIGNMENT_ID — the primary person and assignment keys used to join back to HR and Payroll tables.
  • EMPLOYEE_NUMBER, LAST_NAME, FIRST_NAME, TITLE, NATIONAL_IDENTIFIER — the person identification details printed on the P45.
  • ACTUAL_TERMINATION_DATE — the confirmed leaving date, derived either from the period of service or the assignment effective end date.
  • LAST_PROCESS_DATE — the last standard process date, or the effective end date, reflecting the final payroll processed.
  • DECEASED_FLAG — returns 'D' when the leaving reason indicates death, otherwise NULL.
  • ASSIGNMENT_NUMBER, PAYROLL_ID — assignment and payroll identifiers used for downstream processing.
  • ORGANIZATION_ID, ORG_NAME — the organization owning the assignment, with the translated name resolved against USERENV('LANG').

Common Use Cases and Queries

The view is typically used to audit leavers, verify that P45 data is complete, or feed a custom P45 extract. A basic query returning leavers for a business group is:

  • SELECT person_id, employee_number, last_name, first_name, actual_termination_date, last_process_date, org_name FROM apps.pay_p45_v1 WHERE business_group_id = :p_business_group_id;

To identify deceased employees requiring special handling, filter on the deceased flag:

  • SELECT employee_number, last_name, actual_termination_date FROM apps.pay_p45_v1 WHERE deceased_flag = 'D';

Because HR_SECURITY and HR_PERSON_NAME packages participate in the definition, results are subject to the security profile of the connecting user. When querying from a custom report or integration, it is advisable to connect with a responsibility that carries appropriate HR security, or to pass an explicit business group filter. Row counts can also differ between 12.1.1 and 12.2.2 where HR security and organization translation behaviors were refined.