GPGB_EE_TAX

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	GPGB_TAX_CD_SRC	Character(4)	VARCHAR2(4) NOT NULL	How Employee was notified of Tax Code eg P45, P46 or P38s OTH=OTH P38S=P38S P45=P45 P46=P46 P6=P6 P6B=P6B P6T=P6T P7X=P7X P9=P9 P9T=P9T P9X=P9X
6	TAXCODE_UK	Character(15)	VARCHAR2(15) NOT NULL	Tax Code
7	TAX_BASIS_UK	Character(1)	VARCHAR2(1) NOT NULL	Tax Basis 0=Cumulative 1=Week 1/Month 1
8	GPGB_SV_TAX_IND	Character(1)	VARCHAR2(1) NOT NULL	Scottish Variable Tax Indicator - Y/N. If this is set to Y then the Tax Code entered should be prefixed with an 'S' Y/N Table Edit
9	GPGB_TAX_CD_ALPHA	Character(2)	VARCHAR2(2) NOT NULL	Alpha part of Tax Code - this field will be hiiden from view and is used in the calculation of Tax. It has been included in the table as the Formulae functionality of GP cannot currently support the Substring and Numeric Conversion type functions that would be required.
10	GPGB_TAX_CD_NUM	Number(6,0)	INTEGER NOT NULL	Numeric part of Tax Code - this field will be hidden from view and is used in the calculation of Tax. It has been included in the table as the Formulae functionality of GP cannot currently support the Substring and Numeric Conversion type functions that would be required.
11	GPGB_TAX_CD_ISSUE	Date(10)	DATE	Tax Code Issue Date
12	GPGB_TAX_YR_END	Character(4)	VARCHAR2(4) NOT NULL	Represents the Tax Year
13	GPGB_P46_STATMNTA	Character(1)	VARCHAR2(1) NOT NULL	P46 - Statement A Y/N Table Edit
14	GPGB_P46_STATMNTB	Character(1)	VARCHAR2(1) NOT NULL	P46 - Statement B Y/N Table Edit
15	GPGB_P46_STATMNTC	Character(1)	VARCHAR2(1) NOT NULL	P46 - Statement C Y/N Table Edit
16	GPGB_PREV_ER_PAYE	Character(10)	VARCHAR2(10) NOT NULL	Previous Employer PAYE ID
17	GPGB_ER_TAXNUM	Number(3,0)	SMALLINT NOT NULL	Employer's Tax Number
18	GPGB_LEAVE_DT	Date(10)	DATE	Captures the Leave Date of the employees last employment
19	GPGB_PREV_PERIOD	Number(3,0)	SMALLINT NOT NULL	Previous employment Pay Period
20	GPGB_PREV_WKMTH	Character(1)	VARCHAR2(1) NOT NULL	Previous Employment week month indicator M=Month W=Week
21	GPGB_P45_TXYR	Number(4,0)	SMALLINT NOT NULL	Tax Year from P45
22	GPGB_PREV_TX_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Previous Employer Tax Basis 0=Cumulative 1=Week 1/Month 1
23	GPGB_PREV_TAX_CD	Character(15)	VARCHAR2(15) NOT NULL	Tax Code at Previous Employment - taken from P45
24	GPGB_PREV_SVTAXIND	Character(1)	VARCHAR2(1) NOT NULL	Previous Scottish Variable Tax Indicator - Y/N. If this is set to Y then the Tax Code entered should be prefixed with and 'S' Y/N Table Edit
25	GPGB_P45_PAY_TD	Number(13,2)	DECIMAL(12,2) NOT NULL	Total Pay to Date from P45
26	GPGB_P45_TAX_TD	Number(13,2)	DECIMAL(12,2) NOT NULL	Total Tax to Date from P45
27	GPGB_P45_STLOAN	Character(1)	VARCHAR2(1) NOT NULL	Continue Student Loan Deductions from P45.
28	GPGB_P45_CAL_RUN	Character(18)	VARCHAR2(18) NOT NULL	P45 Calendar Group Id
29	GPGB_EDI_REF	Number(14,0)	DECIMAL(14) NOT NULL	GPUK EDI stores EDI transaction number
30	LEAVE_DT	Date(10)	DATE	Leave Date
31	GPGB_EMPL_NP	Character(20)	VARCHAR2(20) NOT NULL	Employee Not paid Y/N Table Edit Default Value: N
32	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
33	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.