GPGB_PYENT_RTI

#	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	GPGB_NIC_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	NIC Percentage
4	GPGB_SSPREC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total SSP Recovered under PTS
5	GPGB_RTI_SRVC	Character(1)	VARCHAR2(1) NOT NULL	Service Company Indicator used in RTI Y/N Table Edit Default Value: N
6	GPGB_ASPP_REC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total SSP Recovered under PTS
7	GPGB_OSPP_REC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total SSP Recovered under PTS
8	GPGB_SMP_REC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total SSP Recovered under PTS
9	GPGB_SAP_REC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total SSP Recovered under PTS
10	GPGB_SPBP_REC	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total SSP Recovered under PTS
11	GPGB_TOT_NIC_HOLS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	End of Year Submissions - Total NIC Holiday claimed in this permit number.
12	GPGB_ADV_RCD_IR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	P35 EDI - Advance received from IR to Refund Tax.
13	GPGB_NICTAX_PAID	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	RTI - NIC/TAX paid already.
14	GPGB_INC_PAYMENT	Signed Number(6,0)	DECIMAL(5) NOT NULL	EDI - Incentive Pay
15	GPGB_DD_SB_CONTS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	P35 EDI - Deductions made from subcontractors.
16	GPGB_EDI_P35CL2	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 2. Y/N Table Edit Default Value: N
17	GPGB_EDI_P35CL3	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 3. Y/N Table Edit Default Value: N
18	GPGB_EDI_P35CL41	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 4.1. Y/N Table Edit Default Value: N
19	GPGB_EDI_P35CL51	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 5.1. Y/N Table Edit Default Value: N
20	GPGB_EDI_P35CL61	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 6.1. Y/N Table Edit Default Value: N
21	GPGB_RTI_P11D	Character(1)	VARCHAR2(1) NOT NULL	RTI P11D Indicator Y/N Table Edit Default Value: N
22	GPGB_ECON	Character(9)	VARCHAR2(9) NOT NULL	Employers Contracted Out Number
23	GPGB_EDI_CIS_IND	Character(1)	VARCHAR2(1) NOT NULL	EDI P35 - CIS Limited Company Indicator. Y/N Table Edit Default Value: N
24	GPGB_CESSATION_IND	Character(1)	VARCHAR2(1) NOT NULL	EDI - Cessation Indicator Y/N Table Edit Default Value: N
25	GPGB_RTI_LATE_PRC	Character(1)	VARCHAR2(1) NOT NULL	Late Terminations Default Value: N
26	GPGB_LEVY_ALL_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	RTI 2017 changes
27	GPGB_LEVY_ALLOW	Number(8,2)	DECIMAL(7,2) NOT NULL	RTI 2017 Changes
28	GPGB_AGRI_SEC	Character(1)	VARCHAR2(1) NOT NULL	Agricultural Sector N=No Y=Yes
29	GPGB_FISH_SEC	Character(1)	VARCHAR2(1) NOT NULL	Fisheries and aquaculture sector N=No Y=Yes
30	GPGB_IND_SEC	Character(1)	VARCHAR2(1) NOT NULL	Industrial Sector N=No Y=Yes
31	GPGB_ROAD_SEC	Character(1)	VARCHAR2(1) NOT NULL	Road and transport Sector N=No Y=Yes
32	GPGB_AID_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	Aid Amount Default Value: 0
33	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
34	GROUPBOX	Character(1)	VARCHAR2(1) NOT NULL	Groupbox
35	GPGB_NO_AID	Character(1)	VARCHAR2(1) NOT NULL	State Aid rules do not apply N=No Y=Yes