GPGB_EPS_SUMM(SQL Table) |
Index Back |
---|---|
EPS summary recordRTI16-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 |