EG_OTH_DPT_TBL (SQL Table)	Index Back
Other Tenure Dept Table Other Tenure Dept Table

EG_OTH_DPT_TBL

(SQL Table)

Other Tenure Dept Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EG_OTH_DEPT Character(10) VARCHAR2(10) NOT NULL Tenure Department
Prompt Table: DEPT_TBL

3 EG_ACADEMIC_RANK Character(3) VARCHAR2(3) NOT NULL Academic Rank
Prompt Table: EG_RANK_TBL

4 EG_RNK_CHG_DT Date(10) DATE Change Date

5 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence

6 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

7 EG_LAST_UPD_DT Date(10) DATE Changed Date

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EG_OTH_DEPT	Character(10)	VARCHAR2(10) NOT NULL	Tenure Department Prompt Table: DEPT_TBL
3	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank Prompt Table: EG_RANK_TBL
4	EG_RNK_CHG_DT	Date(10)	DATE	Change Date
5	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
6	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
7	EG_LAST_UPD_DT	Date(10)	DATE	Changed Date
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	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.