Search Results gb_p45_3

Overview

The view APPS.PAY_P45_3_ASG_INFO_V exposes United Kingdom P45(3) starter information held against an assignment within Oracle E-Business Suite. In the UK payroll legislation model, a P45 Part 3 is the employee's summary of pay and tax from the previous employment, supplied by the employee to the new employer so that the correct tax code and basis can be applied. Oracle Payroll stores this data as descriptive flexfield style information attached to the assignment record, and this view presents that data in a de-normalised, business-friendly form for reporting, forms, and integrations.

The view is defined in the APPS schema and is commonly referenced by UK payroll concurrent programs, self-service pages, and interface extracts. The object name prefix PAY_ identifies it as a Payroll product view, while the _V suffix confirms it is a read-only view rather than a table.

Underlying Base Objects

The view is defined solely over the synonym PER_ASSIGNMENT_EXTRA_INFO (alias AEI), which points to the base table holding assignment-level extra information. The ETRM metadata also lists the package HR_GENERAL as a referenced object; it is not a table but supplies the DECODE_LOOKUP function used in the select list to translate coded flexfield values into their descriptive meaning.

The view applies a single hard-coded filter, WHERE AEI.INFORMATION_TYPE = 'GB_P45_3', so only rows carrying the Great Britain P45(3) information type are returned. Each returned row therefore corresponds to exactly one assignment extra information record of that type, keyed by ASSIGNMENT_EXTRA_INFO_ID and ASSIGNMENT_ID.

Key Columns

• P45_3_ASG_EXTRA_INFO_ID – primary identifier of the underlying extra information row.
• ASSIGNMENT_ID – the assignment to which the P45(3) details belong.
• INFORMATION_TYPE / AEI_INFORMATION_CATEGORY – context descriptors; the type is fixed as GB_P45_3.
• P45_3_SEND_EDI – whether the previous-employment details are transmitted by EDI.
• PREVIOUS_TAX_DISTRICT, PREVIOUS_TAX_CODE – tax office district and code from the previous employment.
• PREVIOUS_TAX_BASIS and its decoded counterpart DISPLAY_PREV_TAX_BASIS – the tax basis indicator and its lookup description via GB_TAX_BASIS.
• DATE_LEFT_PREV_EMP – leaving date from the previous employer.
• PREV_EMP_LAST_PAY_PERIOD_TYPE with decoded D_PRV_EMP_LAST_PAY_PERIOD_TYPE (lookup GB_PREV_PAYMENT_TYPE), and PREV_EMP_LAST_PAYMENT_PERIOD – the final pay period details.
• P45_3_SEND_EDI_FLAG, P45_3_PREV_TAX_PAID_NOTIFIED, P45_3_NOT_PAID_BET_START_N5APR, P45_3_CONTINUE_SL_DEDUCTIONS, P45_3_PREV_TAX_PAY_NOTIFIED – statutory indicator flags.
• P45_3_OBJECT_VERSION_NUM – optimistic locking / versioning attribute.

The two SUBSTR(...DECODE_LOOKUP...,1,80) expressions provide human-readable equivalents of the coded columns, avoiding the need for callers to join lookup tables themselves.

Common Use Cases and Queries

Typical consumers include UK payroll startup processing, tax data audits, and data migration or interface extracts where P45(3) information must be reported per assignment.

• Retrieve P45(3) details for a specific assignment:

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

• List all assignments flagged for EDI transmission of P45(3) data:

SELECT ASSIGNMENT_ID, P45_3_SEND_EDI, P45_3_SEND_EDI_FLAG
  FROM APPS.PAY_P45_3_ASG_INFO_V
 WHERE P45_3_SEND_EDI_FLAG IS NOT NULL;

• Audit assignments carrying continued student loan deductions from a previous employer:

SELECT ASSIGNMENT_ID, P45_3_CONTINUE_SL_DEDUCTIONS
  FROM APPS.PAY_P45_3_ASG_INFO_V
 WHERE P45_3_CONTINUE_SL_DEDUCTIONS IS NOT NULL;

Because the view returns one row per assignment extra information record, joins to PER_ALL_ASSIGNMENTS_F on ASSIGNMENT_ID are straightforward. No DML is permitted against the view; all maintenance must be performed on the underlying PER_ASSIGNMENT_EXTRA_INFO table through supported Payroll forms or APIs.