GPGB_EPS_SUBMIT

(SQL Table)
Index Back

EPS Reconciliation Table

EPS Reconciliation Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 GPGB_TAX_BGN_YR Number(4,0) SMALLINT NOT NULL Tax Year Begins In This Calendar Year
4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
5 HIRE_DT Date(10) DATE First Start Date
6 PRD_END_DT Date(10) DATE Pay Period End Date
7 ASOFDATE Date(10) DATE As of Date
8 GPGB_SMP Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SMP
9 GPGB_SPPA Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SPPA
10 GPGB_SPPB Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SPPB
11 GPGB_SAP Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - SAP
12 GPGB_ASPPA Signed Number(20,6) DECIMAL(18,6) NOT NULL ASPPA YTD : Additional Stat Paternity Pay Adoption
13 GPGB_ASPPB Signed Number(20,6) DECIMAL(18,6) NOT NULL ASPPB YTD : Additional Stat Paternity Pay Birth
14 GPGB_SHPPA Signed Number(20,6) DECIMAL(18,6) NOT NULL Shared Parental Adoption
15 GPGB_SHPPB Signed Number(20,6) DECIMAL(18,6) NOT NULL SHared Parental Birth
16 GPGB_SPBP_YTD Number(12,2) DECIMAL(11,2) NOT NULL GP UK Termination Payment