GPSG_CPFLIN_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	GPSG_CPF_EMPLR_REF	Character(15)	VARCHAR2(15) NOT NULL	CPF Employer Reference no.
5	GPSG_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Character field to represent a year
6	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
7	BEGIN_DT	Date(10)	DATE	Begin Date
8	END_DT	Date(10)	DATE	end date
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number
11	GPSG_ADVICE_NUM	Number(2,0)	SMALLINT NOT NULL	GPSG Advice Code in Numbers
12	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
13	GPSG_ADVICE_CODE	Character(2)	VARCHAR2(2) NOT NULL	Advice Code
14	GPSG_FILENAME	Character(12)	VARCHAR2(12) NOT NULL	File name
15	GPSG_TOTAL	Number(16,2)	DECIMAL(15,2) NOT NULL	Total
16	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name