GPAU_ETP_E1_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
4	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee.
5	GPAU_ETP_PY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ETP Payment Type. N=Non Transitional O=Non-Excluded ETP R=Excluded ETP T=Transitional
6	GPAU_TFN	Character(9)	VARCHAR2(9) NOT NULL	This is the payee's tax file number. This is the payee's unique identification number for tax purposes.
7	GPAU_ETP_DYS_PRE83	Number(5,0)	INTEGER NOT NULL	Nbr of Days before 1 July 1983 - Eligible Termination Payment
8	GPAU_ETP_DYS_PST83	Number(5,0)	INTEGER NOT NULL	Nbr of Days after 30 June 1983 - Eligible Termination Payment
9	GPAU_ETP_SRV_DT	Date(10)	DATE	Payment Summary - Date Started
10	GPAU_ETP_PAY_DT	Date(10)	DATE	Payment Summary - Date of Payment
11	GPAU_ETP_PRE83	Number(11,2)	DECIMAL(10,2) NOT NULL	Pre July 1983 Component of ETP -End of Year Processing
12	GPAU_ETP_PST83_NTX	Number(11,2)	DECIMAL(10,2) NOT NULL	ETP Post-June 83 Untaxed
13	GPAU_ETP_PST83_TAX	Number(11,2)	DECIMAL(10,2) NOT NULL	ETP Post-June 83 element of ETP
14	GPAU_ETP_PST94_INV	Number(11,2)	DECIMAL(10,2) NOT NULL	ETP Post June 94 Invalidity Payment
15	GPAU_ETP_GROSS	Number(13,2)	DECIMAL(12,2) NOT NULL	ETP Gross Amount - End of Year Processing
16	GPAU_ETP_ASSES	Number(11,2)	DECIMAL(10,2) NOT NULL	ETP Assessable Amount
17	GPAU_ETP_TAX	Number(11,2)	DECIMAL(10,2) NOT NULL	ETP Tax Withheld - End of Year Processing