EG_TENURE_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EG_TRACK_HIRE_DT	Date(10)	DATE	Tenure Track Start Date Default Value: %date
3	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank Prompt Table: EG_RANK_TBL
4	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
5	EG_RNK_CHG_DT	Date(10)	DATE	Change Date
6	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
7	EG_ORIG_TRACK_DT	Date(10)	DATE	Original Tenure Track Start Dt
8	EG_TENURE_HOME	Character(10)	VARCHAR2(10) NOT NULL	Tenure Home Organization Prompt Table: DEPT_TBL
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID
10	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group Prompt Table: EG_CALC_TEN_VW
11	EG_MAND_REVW_DT	Date(10)	DATE	Mandatory Review Dt
12	EG_GRANTED_DT	Date(10)	DATE	Tenure Granted Date
13	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
14	EG_TL_REQ_SVC	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Probationary Periods Default Value: 0
15	EG_ACCR_SVC	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Time Accrued Default Value: 0
16	EG_ADD_REQ_SVC	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Remaining Time To Accrue Default Value: 0
17	EG_TL_EXT_SVC	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Prob. Period Extension (yrs)
18	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
19	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	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.
20	LAST_PROC_DT	Date(10)	DATE	Last Proc Date
21	EG_OVERRIDE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Override Calculation Y/N Table Edit
22	EG_TERM_YR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Terminal Year Y/N Table Edit
23	COMMENTS	Long Character	CLOB	Comment