EG_CASE_REVIEW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON Set Control Field: EMPLID
2	EG_CASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Case ID
3	EG_CASE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Case Type FTE=FTE Review MIX=Mixed RNK=Rank Review TEN=Tenure Review TTL=Title Review
4	EG_CASE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Case Status A=Approved D=Disapproved I=In Appeal O=Open
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	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank Prompt Table: EG_RANK_TBL Set Control Field: ACADEMIC_RANK
7	EG_ACADEMIC_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Title
8	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
9	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
10	BEGIN_DT	Date(10)	DATE	Begin Date
11	EG_OUTSIDE_OFFER	Character(1)	VARCHAR2(1) NOT NULL	Outside Offer Indicator Y/N Table Edit Default Value: N
12	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
13	EG_CASE_DOCS	Character(1)	VARCHAR2(1) NOT NULL	Forward Case Portfolio Y/N Table Edit Default Value: N
14	DESCRLONG	Long Character	CLOB	Long Description