Search Results gb_p45

Overview

APPS.PAY_P45_V1 is a reporting view in Oracle E-Business Suite that presents assignment- and person-level data relevant to P45 processing for United Kingdom payroll legislation. The view consolidates termination details, assignment attributes, person identifiers, and organizational context into a single queryable structure, allowing payroll administrators, HR staff, and downstream integrations to retrieve the information needed to produce or validate P45 output. Because it derives its data from core HR tables (PER_PEOPLE, PER_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE) rather than storing data itself, it always reflects the current transactional state of the underlying records, subject to the row filters defined in its SQL definition.

The user search term "last_process_date" maps directly to a computed column in this view. In the first branch of the UNION, the column is populated from SERV.LAST_STANDARD_PROCESS_DATE and aliased as LAST_PROCESS_DATE; in the second branch it is populated from A.EFFECTIVE_END_DATE. This dual sourcing means the meaning of the exposed value depends on which branch of the UNION produced the row, a nuance that is important when interpreting query results.

Underlying Base Objects

The view is defined over a UNION of two SELECT statements. The documented referenced base objects are:

• PER_PEOPLE (VIEW) — supplies person-level attributes such as name, title, and national identifier
• PER_ASSIGNMENTS_F (VIEW) — supplies assignment-level attributes, effective dates, payroll and organization references
• PER_PERIODS_OF_SERVICE (SYNONYM) — supplies actual termination date and last standard process date via the service record
• PER_ASSIGNMENT_EXTRA_INFO (SYNONYM) — used in the filter logic to identify assignments flagged with the GB_P45 information type
• HR_ALL_ORGANIZATION_UNITS (SYNONYM) and HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — supply organization identifiers and translated organization names
• HR_GENERAL, HR_PERSON_NAME, HR_PERSON_TYPE_USAGE_INFO, and HR_SECURITY (PACKAGES) — supporting packages referenced by the view runtime

Joins between these objects are keyed principally on ASSIGNMENT_ID, PERSON_ID, PERIOD_OF_SERVICE_ID, and ORGANIZATION_ID. The view also enforces language sensitivity through USERENV('LANG') on the translated organization table.

Key Columns

• BUSINESS_GROUP_ID — legal entity/business group context for the assignment
• ASSIGNMENT_ID, ASSIGNMENT_NUMBER — assignment identifiers
• PERSON_ID, EMPLOYEE_NUMBER — person identifiers
• LAST_NAME, FIRST_NAME, TITLE, NATIONAL_IDENTIFIER — personal details sourced from PER_PEOPLE
• LAST_PROCESS_DATE — the search term of interest; from LAST_STANDARD_PROCESS_DATE in the first union branch, or from assignment EFFECTIVE_END_DATE in the second
• ACTUAL_TERMINATION_DATE — from PERIODS_OF_SERVICE in branch one, or the assignment's EFFECTIVE_END_DATE in branch two
• DECEASED_FLAG — set to 'D' when the leaving reason indicates the employee is deceased, otherwise NULL
• PAYROLL_ID, ORGANIZATION_ID, ORG_NAME — payroll and organizational context

Common Use Cases and Queries

This view is typically queried during P45 preparation and auditing, to identify leavers who require a P45 document, and to reconcile the reported last process date against the true termination date. A basic query might select the employee, termination date, and last process date for a given business group or organization. A representative example is shown below.

• Filtering leavers by period: SELECT EMPLOYEE_NUMBER, LAST_NAME, ACTUAL_TERMINATION_DATE, LAST_PROCESS_DATE FROM APPS.PAY_P45_V1 WHERE LAST_PROCESS_DATE BETWEEN :from_date AND :to_date;
• Identifying deceased employees for specialized handling: SELECT PERSON_ID, LAST_NAME, DECEASED_FLAG FROM APPS.PAY_P45_V1 WHERE DECEASED_FLAG = 'D';
• Organizational reconciliation: SELECT ORG_NAME, COUNT(*) FROM APPS.PAY_P45_V1 GROUP BY ORG_NAME ORDER BY ORG_NAME;

Because the view filters on the GB_P45 extra information type and effectively excludes rows where the P45 has already been issued, it behaves as a working list of outstanding P45 obligations rather than a historical archive. Queries referencing LAST_PROCESS_DATE should account for the UNION logic so that date comparisons are interpreted consistently.