SSR_RN_STDGR_VW

(SQL View)
 Index Back

Select Students By Group

Select Students By Group

SELECT DISTINCT B.OPRID , B.RUN_CNTL_ID , A.STDNT_GROUP , A.EMPLID FROM PS_STDNT_GRPS_HIST A , PS_SSR_RUNGRPS_NLD B WHERE A.STDNT_GROUP = B.SSR_GRP_BAS_NLD AND A.INSTITUTION = B.INSTITUTION AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_STDNT_GRPS_HIST A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.INSTITUTION = A_ED.INSTITUTION AND A.STDNT_GROUP = A_ED.STDNT_GROUP AND A_ED.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# 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 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID