GPS_CHANGE_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	YEAR	Character(4)	VARCHAR2(4) NOT NULL	Character field to represent a year
3	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
4	GPS_ROWID	Character(45)	VARCHAR2(45) NOT NULL	RowID, a condensed version of the key fields of a budgeting system
5	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
6	GPS_GRADE	Character(8)	VARCHAR2(8) NOT NULL	Salary Grade.
7	GPS_POST_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Post Type AND=Other (Civil Service) ANE=Other (Employee) ANG=Public Sector Employee ANW=Civil Servant on Recall AZU=Apprentice BEA=Civil Servant ERE=Replacement Post (Employee) ERS=Replacement Post (Civil Serv.) LEB=Empty Post (Civil Service) LEE=Empty Post (Employee)
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	ACTIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Action Name
10	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
11	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
12	OLD_VALUE	Character(50)	VARCHAR2(50) NOT NULL	Previous Field Value
13	NEW_VALUE	Character(50)	VARCHAR2(50) NOT NULL	Submitted Value
14	GPS_ACTION	Character(8)	VARCHAR2(8) NOT NULL	Action as executed on GPS Post
15	GPS_DEPT_TGT	Character(10)	VARCHAR2(10) NOT NULL	Target department
16	GPS_FRACTION	Number(9,2)	DECIMAL(8,2) NOT NULL	GPS Fraction
17	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive