STDNT_GRD_HDRV2 (SQL View)	Index Back
Student Grade View used on student's view on schedule of classes to allow showing a link to the student view of the gradebook.

STDNT_GRD_HDRV2

(SQL View)

Student Grade

View used on student's view on schedule of classes to allow showing a link to the student view of the gradebook.

SELECT A.EMPLID , A.STRM , A.CLASS_NBR FROM PS_STDNT_ENRL A , PS_LAM_CLASS_ACTV B WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: TERM_TBL

3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_TBL
3	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr