Understanding P11D Extraction Setup

This topic discusses:

  • Setting up extract types and extract definitions.

  • Setting up the P11D processing structure.

  • Delivered supporting elements.

  • Viewing delivered elements.

There are two setup components for the Extract P11D Data process:

  • Define P11D Extract Types GBR component (GPGB_P11D_E_TYP).

    The extract type is a key field for the P11D result tables (GPGB_P11RSLT_L, GPGB_P11RSLT_M, and GPGB_P11RSLT_S). These tables store data retrieved from more than one source table. The extract type identifies the type of information stored in a row of data. For example, the GPGB_P11DRSLT_L table stores results relating to both Employee Details and Company Car allocations and the extract type is used to distinguish between these two sets of data. The extract type enables the Extract P11D Data process to select the relevant rows from the result tables. Do not change the delivered extract types unless you need to modify the global payroll process to retrieve additional data.

    See Modifying the P11D Data Extract Tool.

  • Define P11D Solution GBR component (GPGB_P11D_SOLUTION).

    The P11D Solution page is where you set up the extract definition for your P11D solution. The extract definition defines:

    • The tables from which data is extracted.

    • The extract type, if applicable.

      If data is extracted from the P11D results table, then an extract type is required to define the rows extracted.

    • How to map the extracted data into the CSV file.

      Each third-party P11D solution has specific format requirements for loading data. Use the P11D Solution page to define the name of the CSV files and the format of data in the CSV files. Refer to the documentation for your third-party P11D solution for details of the formatting requirements.

Before you run the P11D global payroll process, set up a processing structure to process results for the tax year for your pay groups. Here are the elements required and a description of the delivered elements:

  • Period for the tax year.

    Global Payroll for the UK delivers a set of periods that correspond to tax years:

    • GBRTAX0304 (UK tax year April 6, 2003 to April 5, 2004).

    • GBRTAX0405 (UK tax year April 6, 2004 to April 5, 2005).

    • GBRTAX0506 (UK tax year April 6, 2005 to April 5, 2006).

    • GBRTAX0607 (UK tax year April 6, 2006 to April 5, 2007).

    • GBRTAX0708 (UK tax year April 6, 2007 to April 5, 2008).

    • GBRTAX0809 (UK tax year April 6, 2008 to April 5, 2009).

    • GBRTAX0910 (UK tax year April 6, 2009 to April 5, 2010).

    These periods are provided as sample data only. You can use the delivered periods or create your own. However, each period must be defined for the whole tax year.

  • A P11D Run Type

    A P11D run type is delivered specifically for P11D data extract processing that is linked to the GBR PR P11D process list.

  • Calendars

    Define a P11D calendar for your pay groups that is linked to a tax year period and the P11D run type.

  • Calendar groups

    Note: The calendar group for P11D processing is defined when the Off Cycle check box is deselected. The P11D process is not an off-cycle process.

  • Sections

    A P11D section is delivered for each type of extract:

    • P11D SE EE DETS extracts employee details.

    • P11D SE LOANS extracts loan information.

    • P11D SE LOAN BAL extracts loan balance.

    • P11D SE CAR ALLOC extracts company car data.

  • Process List

    The delivered process list GBR PR P11D includes all the P11D sections listed above.

PeopleSoft delivers elements for P11D processing as sample data. You can use the delivered structure, or create your own.

This table lists the arrays that PeopleSoft delivers to retrieve information for the P11D:

Array

Description

GBR AR EMPLOYEE

Retrieves employee information from the table PERSONAL_DT_FST

GBR AR NAME

Retrieves employee first and last name from the view NAMES_VW.

GBR AR PAY ENTITY

Retrieves employer name and tax reference from the pay entity table GPGB_PYENT

P11D AR CAR ALLOC

Retrieves car allocations from the company car table CAR_ALLOC

P11D AR CAR DATA

Retrieves car data from the table CAR_DATA

P11D AR LOAN BAL

Retrieves loan balance from the writable array GPGB_LOAN_WA, which stores loan processing results.

P11D AR LOAN HD A

Retrieves loan data from the table GPGB_EE_LOAN_HD

P11D AR LOAN HD B

Retrieves loan data from the table GPGB_EE_LOAN_HD

P11D AR LOAN IN

Retrieves loan interest amount from table GPGB_EE_LOAN_IN.

P11D AR CAR PAY

Retrieves information about car payments.

P11D AR UNAV

Retrieves car information related to the periods when a car is not available.

P11D AR LOAN DT

Retrieves employee loan details.

This table lists the writable arrays that are delivered to populate the P11D results tables:

Writable Array

Description

P11D WR RESULT L

Populates the results table GPGB_P11DRSLT_L

P11D WR RESULT M

Populates the results table GPGB_P11DRSLT_M

P11D WR RESULT S

Populates the results table GPGB_P11DRSLT_S

The PeopleSoft system delivers a query that you can run to view the names of all delivered elements designed for the United Kingdom. Instructions for running the query are provided in the PeopleSoft Global Payroll product documentation.