EG_EMPL_VW (SQL View)	Index Back
Employee Tenure Data View Employee Tenure Data View

EG_EMPL_VW

(SQL View)

Employee Tenure Data View

SELECT A.EMPLID , A.NAME , B.EG_TRACK_HIRE_DT , B.EG_ACADEMIC_RANK , B.TENURE_STATUS , B.EG_ORIG_TRACK_DT , B.EG_TENURE_HOME , B.EG_GROUP , B.EG_MAND_REVW_DT , B.EG_GRANTED_DT , B.FTE , B.LAST_PROC_DT , B.EG_OVERRIDE_FLAG , C.ORIG_HIRE_DT , B.SETID FROM PS_PERSON_NAME A , PS_EG_TENURE_DATA B , PS_ORIG_HIR_EMP_VW C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 EG_TRACK_HIRE_DT Date(10) DATE Tenure Track Start Date

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

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_ORIG_TRACK_DT Date(10) DATE Original Tenure Track Start Dt

7 EG_TENURE_HOME Character(10) VARCHAR2(10) NOT NULL Tenure Home Organization
Prompt Table: DEPT_TBL
Set Control Field: DEPTID

8 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group
Prompt Table: EG_CALC_TEN_VW

9 EG_MAND_REVW_DT Date(10) DATE Mandatory Review Dt

10 EG_GRANTED_DT Date(10) DATE Tenure Granted Date

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

12 LAST_PROC_DT Date(10) DATE Last Proc Dt

13 EG_OVERRIDE_FLAG Character(1) VARCHAR2(1) NOT NULL Override Calculation
Y/N Table Edit

14 ORIG_HIRE_DT Date(10) DATE Original Start Date

15 SETID Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	EG_TRACK_HIRE_DT	Date(10)	DATE	Tenure Track Start Date
4	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank Prompt Table: EG_RANK_TBL
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_ORIG_TRACK_DT	Date(10)	DATE	Original Tenure Track Start Dt
7	EG_TENURE_HOME	Character(10)	VARCHAR2(10) NOT NULL	Tenure Home Organization Prompt Table: DEPT_TBL Set Control Field: DEPTID
8	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group Prompt Table: EG_CALC_TEN_VW
9	EG_MAND_REVW_DT	Date(10)	DATE	Mandatory Review Dt
10	EG_GRANTED_DT	Date(10)	DATE	Tenure Granted Date
11	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
12	LAST_PROC_DT	Date(10)	DATE	Last Proc Dt
13	EG_OVERRIDE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Override Calculation Y/N Table Edit
14	ORIG_HIRE_DT	Date(10)	DATE	Original Start Date
15	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID