GPGB_EPSX_TBL(SQL Table) |
Index Back |
|---|---|
EPS XML TableEPS XML Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 3 | GPGB_TAX_BGN_YR | Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 4 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 5 | GPGB_TAX_END_YR | Number(4,0) | SMALLINT NOT NULL | Tax Year Ends In This Calendar Year |
| 6 | GPGB_NO_PYMT_IND | Character(1) | VARCHAR2(1) NOT NULL | No Payment for Period Indicator |
| 7 | GPGB_NO_PYMNT_FROM | Date(10) | DATE | Stores the 'From' date for No Payment Period |
| 8 | GPGB_NO_PYMNT_TO | Date(10) | DATE | Stores the 'To' value for the No Payment Period |
| 9 | GPGB_INACT_FROM | Date(10) | DATE | Stores the 'From' value for the Inactivity Period |
| 10 | GPGB_INACT_TO | Date(10) | DATE | Stores the "To" value fro the Inactivity Period |
| 11 | BRANCH_NAME_AC | Character(15) | VARCHAR2(15) NOT NULL | This field stores the branch name in an alternate character format |
| 12 | BS_ACCOUNT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Account Number |
| 13 | BANK_ID_CODE | Character(11) | VARCHAR2(11) NOT NULL | Bank Identifier Code |
| 14 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 15 | GPGB_TAX_MONTH | 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 |
| 16 | GPGB_TOT_SSP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SSP in permit number. |
| 17 | GPGB_TOT_SMP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SMP in this permit number. |
| 18 | GPGB_TOT_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SAP in this permit number. |
| 19 | GPGB_TOT_SPP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total SPP in this permit number. |
| 20 | GPGB_TOT_SHPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total sum of shared parental adoption |
| 21 | GPGB_TOT_TC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax credits in permit number. |
| 22 | GPGB_TOT_NIC_COMP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on SMP in this permit number. |
| 23 | GPGB_TOT_COMP_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on SAP in this permit number. |
| 24 | GPGB_TOT_COMPSPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on SPPA in this permit number. |
| 25 | GPGB_TOT_COMPASPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total NIC compensation on ASPPA in this permit number. |
| 26 | GPGB_DD_SB_CONTS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | P35 EDI - Deductions made from subcontractors. |
| 27 | GPGB_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GP UK - Amount |
| 28 | GPGB_AMT_CHAR | Long Character(25) | VARCHAR2(25) | GP UK - Amount |
| 29 | GPGB_LEVY_ALLOW_CH | Character(10) | VARCHAR2(10) NOT NULL | RTI 2017 Changes |
| 30 | 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 |
| 31 | GPGB_LEVY_ALLW_DUE | Number(11,2) | DECIMAL(10,2) NOT NULL | RTI 2017 Changes |
| 32 | GPGB_LEVY_ALLOW | Number(8,2) | DECIMAL(7,2) NOT NULL | RTI 2017 Changes |
| 33 | GPGB_CEASED_DESCR | Character(3) | VARCHAR2(3) NOT NULL | Final Ceased Submission Inidcator |
| 34 | GPGB_DTSCH_CEASED | Date(10) | DATE | Date Scheme ceased |
| 35 | GPGB_FINAL_YR_DESC | Character(3) | VARCHAR2(3) NOT NULL | Final Year Submission Indicator used in RTI |
| 36 | GPGB_REL_TAX_YEAR | Character(5) | VARCHAR2(5) NOT NULL | GPGB RTIXML Related Tax Year |
| 37 | GPGB_RTI_EMP_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Employment Allowance
N=No Y=Yes |
| 38 | GPGB_LEVY_ALOW_CUM | Number(8,2) | DECIMAL(7,2) NOT NULL | RTI 2017 Changes |
| 39 | GPGB_TOT_SPBP | Number(12,2) | DECIMAL(11,2) NOT NULL | GP UK Termination Payment |
| 40 | GPGB_TOT_NICSPBP | Number(12,2) | DECIMAL(11,2) NOT NULL | GP UK Termination Payment |
| 41 | GPGB_AGRI_SEC | Character(1) | VARCHAR2(1) NOT NULL |
Agricultural Sector
N=No Y=Yes |
| 42 | GPGB_FISH_SEC | Character(1) | VARCHAR2(1) NOT NULL |
Fisheries and aquaculture sector
N=No Y=Yes |
| 43 | GPGB_IND_SEC | Character(1) | VARCHAR2(1) NOT NULL |
Industrial Sector
N=No Y=Yes |
| 44 | GPGB_ROAD_SEC | Character(1) | VARCHAR2(1) NOT NULL |
Road and transport Sector
N=No Y=Yes |
| 45 | GPGB_AID_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Aid Amount |
| 46 | GPGB_NO_AID | Character(1) | VARCHAR2(1) NOT NULL |
State Aid rules do not apply
N=No Y=Yes |
| 47 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 48 | GPGB_AID_AMT_TXT | Character(10) | VARCHAR2(10) NOT NULL | Deminis Aid Amount Text Format |