GPGB_PYENT_DTL

#	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_SSP_REC	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total SSP Recovered under PTS
4	GPGB_SMP_STD	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	SMP/SPP/SAP Recovery %
5	GPGB_SMP_SER	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	NIC Comp on SMP/SPP/SAP %
6	GPGB_FNDS_RECD_SMP	Signed Number(18,6)	DECIMAL(16,6) NOT NULL	P35 EDI - Funding receiving from IR to pay SSP/SMP/SPP/SAP.
7	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.
8	GPGB_ADV_RCD_IR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	P35 EDI - Advance received from IR to Refund Tax.
9	GPGB_DD_SB_CONTS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	P35 EDI - Deductions made from subcontractors.
10	GPGB_TOT_TCFND_REC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	EDI P35 - Funding Received from IR to Pay Tax Credits.
11	GPGB_NICTAX_PAID	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	RTI - NIC/TAX paid already.
12	GPGB_INC_PAYMENT	Signed Number(6,0)	DECIMAL(5) NOT NULL	EDI - Incentive Pay
13	GPGB_EDI_P35CL1	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 1 Y/N Table Edit Default Value: Y
14	GPGB_EDI_P35CL2	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 2. Y/N Table Edit Default Value: N
15	GPGB_EDI_P35CL3	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 3. Y/N Table Edit Default Value: N
16	GPGB_EDI_P35CL41	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 4.1. Y/N Table Edit Default Value: N
17	GPGB_EDI_P35CL42	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 4.2. Y/N Table Edit Default Value: N
18	GPGB_EDI_P35CL51	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 5.1. Y/N Table Edit Default Value: N
19	GPGB_EDI_P35CL52	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 5.2. 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_EDI_P35CL62	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Checklist 6.2. Y/N Table Edit Default Value: N
22	GPGB_EDI_P35DEC	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Declaration(P14s). Y/N Table Edit Default Value: Y
23	GPGB_EDI_P35DEC1	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Declaration(P38A). D=Due N=Not Due Default Value: N
24	GPGB_EDI_P35DEC2	Character(1)	VARCHAR2(1) NOT NULL	P35 EDI - Declaration(P11Ds). D=Due N=Not Due Default Value: N
25	GPGB_ECON	Character(9)	VARCHAR2(9) NOT NULL	Employers Contracted Out Number
26	GPGB_EDI_CIS_IND	Character(1)	VARCHAR2(1) NOT NULL	EDI P35 - CIS Limited Company Indicator. Y/N Table Edit Default Value: N
27	GPGB_CESSATION_IND	Character(1)	VARCHAR2(1) NOT NULL	EDI - Cessation Indicator Y/N Table Edit
28	GPGB_CESSATION_DT	Date(10)	DATE	EDI - Cessation date.