GPS_COPY_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
3	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	YEAR	Character(4)	VARCHAR2(4) NOT NULL	Character field to represent a year
6	GPS_YEAR_SRC	Number(4,0)	SMALLINT NOT NULL	Source Year
7	GPS_YEAR_TGT	Number(4,0)	SMALLINT NOT NULL	Target Year
8	GPS_PST_PLN_TP_TGT	Character(1)	VARCHAR2(1) NOT NULL	Post Plan TYpe 0=Base Plan 1=1. Amendment Plan 2=2. Amendment Plan 3=3. Amendment Plan 4=4. Amendment Plan
9	GPS_ROWID	Character(45)	VARCHAR2(45) NOT NULL	RowID, a condensed version of the key fields of a budgeting system
10	GPS_POST_PLN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Post Plan TYpe 0=Base Plan 1=1. Amendment Plan 2=2. Amendment Plan 3=3. Amendment Plan 4=4. Amendment Plan
11	GPS_2YR_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Double Houshold
12	GPS_BDG_YEAR	Number(1,0)	SMALLINT NOT NULL	budget Year 1=1st Budgeting Year 2=2nd Budgeting Year
13	GPS_DESCR1	Character(50)	VARCHAR2(50) NOT NULL	Description 1
14	GPS_DESCR2	Character(50)	VARCHAR2(50) NOT NULL	Description 2
15	GPS_2YR_PLAN_INSTL	Character(1)	VARCHAR2(1) NOT NULL	Double Houshold