EG_CHANGE_HIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank
4	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP NOT NULL	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
5	TENURE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Tenure Status DEF=Tenure by de facto DEN=Tenure Denied NA=Not Applicable NOT=Non Tenure Not On Track NTK=Non Tenure On Track OTH=Other TEN=Tenure
6	ACTION_DT	Date(10)	DATE	Action Date
7	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group
8	EG_TENURE_HOME	Character(10)	VARCHAR2(10) NOT NULL	Tenure Home Organization
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	EG_ADJ_RSN1	Character(1)	VARCHAR2(1) NOT NULL	Change Reason A=Retroactive Adjustment C=Error corrections M=Partial Month N=New O=Other P=Service Recalc. Pending R=Recalculation