| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 5 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 6 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 7 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 8 |
PRC_ORD_TS |
DateTime(26) |
TIMESTAMP |
Process Order Timestamp
|
| 9 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 10 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 11 |
GPGB_RTI_REC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
RTI Reconciliation Type
E=EPS Reconciliation
F=FPS Reconciliation
P=Payroll Reconciliation
Default Value: F
|
| 12 |
GPGB_TAX_BGN_YR |
Number(4,0) |
SMALLINT NOT NULL |
Tax Year Begins In This Calendar Year
|
| 13 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table:
GP_PYENT_OPR_VW
|
| 14 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GPGB_PYGRP11_VW
|
| 15 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 16 |
GPGB_RTI_DIFF |
Character(1) |
VARCHAR2(1) NOT NULL |
RTI Recon Report Differences Only Flag
N=No
Y=Yes
Default Value: Y
|
| 17 |
GPGB_LEL_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings at LEL PTD
|
| 18 |
GPGB_LELET_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above LEL up to ET PTD
|
| 19 |
GPGB_ETUEL_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above ET up to UEL PTD
|
| 20 |
GPGB_ETUAP_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above ET up to UEL PTD
|
| 21 |
GPGB_UAPUEL_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above ET up to UEL PTD
|
| 22 |
GPGB_ER_NIC_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total Employer's contributions PTD
|
| 23 |
GPGB_ER_RBT_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total Employer's rebate PTD
|
| 24 |
GPGB_EE_NIC_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings at LEL PTD
|
| 25 |
GPGB_EE_RBT_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total Employee's rebate PTD
|
| 26 |
GPGB_SMP_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SMP PTD
|
| 27 |
GPGB_SSP_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SSP PTD
|
| 28 |
GPGB_SPPA_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SPPA PTD
|
| 29 |
GPGB_SPPB_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SPPB PTD
|
| 30 |
GPGB_SAP_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SAP PTD
|
| 31 |
GPGB_EE_GROSS_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings at LEL PTD
|
| 32 |
GPGB_EE_TAX_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total tax PTD
|
| 33 |
GPGB_EE_SL_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Student loans PTD
|
| 34 |
GPGB_EE_TC_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Tax credits PTD
|
| 35 |
GPGB_ASPPA_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ASPPA PTD : Additional Stat Paternity Pay Adoption
|
| 36 |
GPGB_ASPPB_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ASPPB PTD : Additional Stat Paternity Pay Birth
|
| 37 |
GPGB_SHPPA_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SHPPA PTD : Shared Parental Pay Adoption
|
| 38 |
GPGB_SHPPB_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SHPPB PTD : Shared Parental Pay Birth
|
| 39 |
GPGB_TAXABLE_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Taxable Pay PTD
|
| 40 |
GPGB_NIABLE_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Niable PTD used for RTI
|
| 41 |
GPGB_BEN_KIND_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Used to store BEN IN KIND accumulator value used in RTI
|
| 42 |
GPGB_EE_PEN_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Pension Ded PTD
|
| 43 |
GPGB_EE_PEN2_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Pension Contributions not under 'Net Pay'
|
| 44 |
GPGB_NON_TAX_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Non Tax PTD
|
| 45 |
GPGB_STAT_DED_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Storing statutory deduction value for RTI
|
| 46 |
GPGB_DEDNETPAY_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Used to store dedecution from net pay used in RTI
|
| 47 |
GPGB_NETPAY_PTD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
NetPay PTD for RTI
|
| 48 |
GPGB_BEN_TAX_PTD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Used for RTI,Benefit taxed via Payroll
|
| 49 |
GPGB_NIC_CLAS1_PTD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Used in RTI ,Benefits contributing NIC for Class1
|
| 50 |
GPGB_NIC_NONTX_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Benefits subjected to NIC Non Tax PTD
|
| 51 |
GPGB_NOT_NIC_PTD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Used in RTI,Benefit not subjected to NIC CLASS 1
|
| 52 |
GPGB_TRIV_COMA_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Storing TRIV AC COMM PTD A for RTI
|
| 53 |
GPGB_TRIV_COMB_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Storing TRIV AC COMM PTD A for RTI
|
| 54 |
GPGB_TRIV_COMC_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Storing TRIV AC COMM PTD A for RTI
|
| 55 |
GPGB_FORE_TX_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
GPGB Foreign tax PTD
|
| 56 |
GPGB_FLX_TAX_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Flexible Drawdown Taxable Payment
|
| 57 |
GPGB_FLX_NTAX_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Flexible Drawdown Non-Taxable Payment
|
| 58 |
GPGB_TER_ER_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
GP UK Termination Payment
|
| 59 |
GPGB_DSGSED_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Disguised Remuneration PTD
|
| 60 |
GPGB_PG_LOAN_PTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Post Graduate Loan PTD
|
| 61 |
GPGB_SPBP_PTD |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
GP UK Termination Payment
|
| 62 |
GPGB_LEL_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings at LEL
|
| 63 |
GPGB_LELET_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above LEL up to ET
|
| 64 |
GPGB_ETUEL_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above ET up to UEL
|
| 65 |
GPGB_ETUAP_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above ET up to UEL
|
| 66 |
GPGB_UAPUEL_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Earnings above ET up to UEL
|
| 67 |
GPGB_ER_NIC_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total Employer's contributions
|
| 68 |
GPGB_ER_RBT_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total Employer's rebate
|
| 69 |
GPGB_EE_NIC_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Employee NIC
|
| 70 |
GPGB_EE_RBT_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total Employee's rebate
|
| 71 |
GPGB_SMP |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SMP
|
| 72 |
GPGB_SSP |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SSP
|
| 73 |
GPGB_SPPA |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SPPA
|
| 74 |
GPGB_SPPB |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SPPB
|
| 75 |
GPGB_SAP |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - SAP
|
| 76 |
GPGB_EE_GROSS |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total gross
|
| 77 |
GPGB_FORGN_TAX |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Foreign Tax
|
| 78 |
GPGB_WIDOW |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Widow
|
| 79 |
GPGB_LIFE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Life
|
| 80 |
GPGB_EE_TAX |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Total tax
|
| 81 |
GPGB_EE_SL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Student loans
|
| 82 |
GPGB_EE_TC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
End of Year Submissions - Tax credits
|
| 83 |
GPGB_ASPPA |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ASPPA YTD : Additional Stat Paternity Pay Adoption
|
| 84 |
GPGB_ASPPB |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ASPPB YTD : Additional Stat Paternity Pay Birth
|
| 85 |
GPGB_NIABLE_YTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Niable YTD used for RTI
|
| 86 |
GPGB_BEN_TAX_YTD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Storing TRIV AC COMM PTD A for RTI
|
| 87 |
GPGB_PEN_DED_YTD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Storing TRIV AC COMM PTD A for RTI
|
| 88 |
GPGB_ST_PENS_YTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
State Pension YTD
|
| 89 |
GPGB_PEN2DED_YTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
State Pension YTD
|
| 90 |
GPGB_SHPPA |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Shared Parental Adoption
|
| 91 |
GPGB_SHPPB |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
SHared Parental Birth
|
| 92 |
GPGB_TER_ER_YTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
GP UK Termination Payment
|
| 93 |
GPGB_PG_LOAN_YTD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Post Graduate Loan YTD
|
| 94 |
GPGB_SPBP_YTD |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
GP UK Termination Payment
|
| 95 |
GPGB_TRIV_COMM_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Trivial Commutation Payment Type for Pensioners
A=Trivial Commutation Lump sums
B=Lump Sum - Personal Pension
C=Lump Sum -Occupational Pension
|
| 96 |
GPGB_TRIV_COMM_B |
Character(1) |
VARCHAR2(1) NOT NULL |
Trivial Commutation Payment Type for Pensioners
A=Trivial Commutation Lump sums
B=Lump Sum - Personal Pension
C=Lump Sum -Occupational Pension
|
| 97 |
GPGB_TRIV_COMM_C |
Character(1) |
VARCHAR2(1) NOT NULL |
Trivial Commutation Payment Type for Pensioners
A=Trivial Commutation Lump sums
B=Lump Sum - Personal Pension
C=Lump Sum -Occupational Pension
|
| 98 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 99 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 100 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 101 |
PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across.
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
|
| 102 |
ENTRY_TYPE_ELEM |
Character(3) |
VARCHAR2(3) NOT NULL |
entry type element
|
| 103 |
ACM_SIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Accumulator Sign
A=Add
S=Subtract
|
| 104 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 105 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 106 |
GPGB_QUAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Global Payroll UK - RTI Qualifier
|
| 107 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 108 |
GPGB_STRM_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Option
N=NO
Y=YES
|
| 109 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
|
| 110 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID (first for a range)
|
| 111 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
Empl ID To
|