GPGB_EXPAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
4	GPGB_CITIZEN	Character(1)	VARCHAR2(1) NOT NULL	To determine if European Economic Area or Commoweath citizen Default Value: N
5	GPGB_P45_STLOAN	Character(1)	VARCHAR2(1) NOT NULL	Continue Student Loan Deductions from P45.
6	GPGB_SL_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field determines the Plan type for Student Loan Plans 1=Plan Type 1 2=Plan Type 2 3=Post Graduate Loan 4=Plan Type 4
7	GPGB_PG_LOAN	Character(1)	VARCHAR2(1) NOT NULL	Post Graduate Loan
8	GPGB_P46_STATMNTA	Character(1)	VARCHAR2(1) NOT NULL	P46 - Statement A A=A (This is my first job). B=B (This is my only job). C=C (I have another job/pension) Y/N Table Edit Default Value: N
9	GPGB_P46_STATMNTB	Character(1)	VARCHAR2(1) NOT NULL	P46 - Statement B Y/N Table Edit Default Value: N
10	GPGB_P46_STATMNTC	Character(1)	VARCHAR2(1) NOT NULL	P46 - Statement C Y/N Table Edit Default Value: N
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	GPGB_EPM6_IND	Character(1)	VARCHAR2(1) NOT NULL	EPM6 (Modified Scheme) Indicator Default Value: N
13	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
14	TAXCODE_UK	Character(15)	VARCHAR2(15) NOT NULL	Tax Code for the UK
15	TAX_BASIS_UK	Character(1)	VARCHAR2(1) NOT NULL	Tax Basis for the UK 0=Cumulative 1=Week 1/Month 1
16	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: PERSON_ADDRESS
17	GPGB_EDI_REF	Number(14,0)	DECIMAL(14) NOT NULL	GPUK EDI stores EDI transaction number