GPGB_EPS_SUMM

(SQL Table)
Index Back

EPS summary record

RTI16-17 changes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 GPGB_TAX_BGN_YR Number(4,0) SMALLINT NOT NULL Tax Year Begins In This Calendar Year
3 PRD_END_DT Date(10) DATE Pay Period End Date
4 GPGB_TOT_SSP Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total SSP in permit number.
5 GPGB_TOT_SMP Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total SMP in this permit number.
6 GPGB_TOT_SAP Signed Number(20,6) DECIMAL(18,6) NOT NULL End of Year Submissions - Total SAP in this permit number.
7 GPGB_APPR_LEVY Character(2) VARCHAR2(2) NOT NULL Tax Month Credit
01=01-APR
02=02-MAY
03=03-JUN
04=04-JUL
05=05-AUG
06=06-SEP
07=07-OCT
08=08-NOV
09=09-DEC
10=10-JAN
11=11-FEB
12=12-MAR
8 GPGB_LEVY_ALLW_DUE Number(11,2) DECIMAL(10,2) NOT NULL RTI 2017 Changes
9 GPGB_LEVY_ALLOW Number(8,2) DECIMAL(7,2) NOT NULL RTI 2017 Changes
10 GPGB_LEVY_ALOW_CUM Number(8,2) DECIMAL(7,2) NOT NULL RTI 2017 Changes
11 GPGB_TOT_SPBP Number(12,2) DECIMAL(11,2) NOT NULL GP UK Termination Payment