AV_CLASS_YR_VW

(SQL View)
Index Back

Class Year View

Class year view

SELECT INSTITUTION, EMPLID, AV_CLASS_YR, ALUMNUS_TYPE FROM PS_AV_CLASS_YR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 AV_CLASS_YR Number(4,0) SMALLINT NOT NULL Class Year
4 ALUMNUS_TYPE Character(1) VARCHAR2(1) NOT NULL Alumnus Type
G=Graduate
N=Non-Degree
U=Undergraduate