GPES_CRT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
5	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
6	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
7	GPES_SSTC_PYMT_OPT	Character(3)	VARCHAR2(3) NOT NULL	Payment Type. This field is used to generate the FAN File. L00=Regular L02=Litigation Salary L03=Retroactivity wo/Surcharge L09=Retroactivity w/Surcharge L13=Vacations L31=Regular and Vacations L99=Full
8	GPES_REUSE_PRV_BS	Character(1)	VARCHAR2(1) NOT NULL	Reuse Previous Month Bases for Creta reporting
9	XML_TEMPLATE_ID	Character(3)	VARCHAR2(3) NOT NULL	Template type
10	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
11	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
12	SOCS_AUTH_KEY_ESP	Character(8)	VARCHAR2(8) NOT NULL	Authorization Key
13	XMLFILE_ID	Character(50)	VARCHAR2(50) NOT NULL	XML File ID
14	GPES_FILE_PATH	Character(250)	VARCHAR2(250) NOT NULL	Output / Input file path
15	GPES_FILE_NAME	Character(250)	VARCHAR2(250) NOT NULL	Name of a file, according to the process scheduler server.