EG_ADM_POST_TBL (SQL Table)	Index Back
Admin Post Setup Admin Post Setup

EG_ADM_POST_TBL

(SQL Table)

Admin Post Setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ADMIN_POST Character(15) VARCHAR2(15) NOT NULL Administrative Post
AD=Assciate Dean
CH=Chair
DE=Dean
DI=Director
VC=Vice Chair

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 POST_TYPE Character(3) VARCHAR2(3) NOT NULL Post Type
ACR=Academic Responsibility
ADM=Administrative
TTL=Title

4 HP_STATS_RESP_CD Character(1) VARCHAR2(1) NOT NULL Stats-Can Responsibilty Code
0=Teaching - No other adm duties
1=Dean
2=Dean - Assit., Assoc. or Vice
3=Dir. w/ Resp./Salry = Dean
4=Director/Dept Head/Coordinator
5=Chairperson
6=Visitor - Teaching
7=Researcher - Non-Visitor
8=Researcher - Visitor
9=Asst/Assoc Dir,DptHd,Coord,Oth

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ADMIN_POST	Character(15)	VARCHAR2(15) NOT NULL	Administrative Post AD=Assciate Dean CH=Chair DE=Dean DI=Director VC=Vice Chair
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	POST_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Post Type ACR=Academic Responsibility ADM=Administrative TTL=Title
4	HP_STATS_RESP_CD	Character(1)	VARCHAR2(1) NOT NULL	Stats-Can Responsibilty Code 0=Teaching - No other adm duties 1=Dean 2=Dean - Assit., Assoc. or Vice 3=Dir. w/ Resp./Salry = Dean 4=Director/Dept Head/Coordinator 5=Chairperson 6=Visitor - Teaching 7=Researcher - Non-Visitor 8=Researcher - Visitor 9=Asst/Assoc Dir,DptHd,Coord,Oth