SSR_RN_STDCL_VW

(SQL View)
 Index Back

Select Students By Class

Select Students By Class

SELECT DISTINCT B.OPRID , B.RUN_CNTL_ID , A.CLASS_NBR , A.EMPLID FROM PS_STDNT_ENRL A , PS_SSR_RUNGRPS_NLD B , PS_SSR_RUNCRTS_NLD C WHERE TO_CHAR(A.CLASS_NBR) = B.SSR_GRP_BAS_NLD AND B.OPRID = C.OPRID AND B.RUN_CNTL_ID = C.RUN_CNTL_ID AND A.STRM = C.STRM AND A.STDNT_ENRL_STATUS = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID