GPGB_FPSPTD_ADJ

(SQL Table)
 Index Back

FPS PTD adjustment

FPS PTD adjustment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GPGB_FPS_CAL_VW

2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GPGB_FPSPYET_VW

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: GPGB_FPSEMP_VW

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: GPGB_FPSEMPR_VW

5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 HIRE_DT Date(10) DATE NOT NULL First Start Date

Prompt Table: GPGB_FPSHRDT_VW

7 GPGB_NI_CATEGORY Character(2) VARCHAR2(2) NOT NULL NI Category Code
8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10 GPGB_LEL_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Earnings at LEL PTD
11 GPGB_LELET_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Earnings above LEL up to ET PTD
12 GPGB_ETUEL_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Earnings above ET up to UEL PTD
13 GPGB_ETUAP_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Earnings above ET up to UEL PTD
14 GPGB_UAPUEL_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Earnings above ET up to UEL PTD
15 GPGB_ER_NIC_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total Employer's contributions PTD
16 GPGB_ER_RBT_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total Employer's rebate PTD
17 GPGB_EE_NIC_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Earnings at LEL PTD
18 GPGB_EE_RBT_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total Employee's rebate PTD
19 GPGB_SMP_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SMP PTD
20 GPGB_SSP_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SSP PTD
21 GPGB_SPPA_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SPPA PTD
22 GPGB_SPPB_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SPPB PTD
23 GPGB_SAP_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SAP PTD
24 GPGB_EE_GROSS_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Earnings at LEL PTD
25 GPGB_EE_TAX_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total tax PTD
26 GPGB_EE_SL_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Student loans PTD
27 GPGB_EE_TC_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Tax credits PTD
28 GPGB_ASPPA_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ASPPA PTD : Additional Stat Paternity Pay Adoption
29 GPGB_ASPPB_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL ASPPB PTD : Additional Stat Paternity Pay Birth
30 GPGB_SHPPA_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL SHPPA PTD : Shared Parental Pay Adoption
31 GPGB_SHPPB_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL SHPPB PTD : Shared Parental Pay Birth
32 GPGB_TAXABLE_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Taxable Pay PTD
33 GPGB_NIABLE_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Niable PTD used for RTI
34 GPGB_BEN_KIND_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Used to store BEN IN KIND accumulator value used in RTI
35 GPGB_EE_PEN_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Pension Ded PTD
36 GPGB_EE_PEN2_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Pension Contributions not under 'Net Pay'
37 GPGB_NON_TAX_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Non Tax PTD
38 GPGB_STAT_DED_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Storing statutory deduction value for RTI
39 GPGB_DEDNETPAY_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Used to store dedecution from net pay used in RTI
40 GPGB_NETPAY_PTD Number(19,6) DECIMAL(18,6) NOT NULL NetPay PTD for RTI
41 GPGB_BEN_TAX_PTD Number(19,6) DECIMAL(18,6) NOT NULL Used for RTI,Benefit taxed via Payroll
42 GPGB_NIC_CLAS1_PTD Number(19,6) DECIMAL(18,6) NOT NULL Used in RTI ,Benefits contributing NIC for Class1
43 GPGB_NIC_NONTX_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Benefits subjected to NIC Non Tax PTD
44 GPGB_NOT_NIC_PTD Number(19,6) DECIMAL(18,6) NOT NULL Used in RTI,Benefit not subjected to NIC CLASS 1
45 GPGB_TRIV_COMA_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Storing TRIV AC COMM PTD A for RTI
46 GPGB_TRIV_COMB_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Storing TRIV AC COMM PTD A for RTI
47 GPGB_TRIV_COMC_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Storing TRIV AC COMM PTD A for RTI
48 GPGB_FORE_TX_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL GPGB Foreign tax PTD
49 GPGB_FLX_TAX_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Flexible Drawdown Taxable Payment
50 GPGB_FLX_NTAX_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Flexible Drawdown Non-Taxable Payment
51 GPGB_TER_ER_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL GP UK Termination Payment
52 GPGB_DSGSED_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Disguised Remuneration PTD
53 GPGB_PG_LOAN_PTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Post Graduate Loan PTD
54 GPGB_SPBP_PTD Number(12,2) DECIMAL(11,2) NOT NULL GP UK Termination Payment