GPGB_CNC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	GPGB_UPLIFT_DATE	Date(10)	DATE	GP GBR - Tax Uplift Date
5	GPGB_INPUT_FILE	Character(20)	VARCHAR2(20) NOT NULL	Inland Revenue Input File
6	GPGB_ERROR_FILE	Character(20)	VARCHAR2(20) NOT NULL	Inland Revenue Error File
7	GPGB_LOGFILE	Character(20)	VARCHAR2(20) NOT NULL	Inland Revenue Log File
8	GPGB_ER_TAXNUM	Number(3,0)	SMALLINT NOT NULL	Employer's Tax Number
9	GPGB_ER_PAYE_REF	Character(10)	VARCHAR2(10) NOT NULL	Employer's PAE reference number
10	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
11	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
12	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'
13	TAXCODE_UK	Character(15)	VARCHAR2(15) NOT NULL	Tax Code
14	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.
15	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.
16	TAX_BASIS_UK	Character(1)	VARCHAR2(1) NOT NULL	Tax Basis 0=Cumulative 1=Week 1/Month 1
17	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
20	GPGB_MSGTEXT	Character(100)	VARCHAR2(100) NOT NULL	Inland Revenue Message Log