SSR_RN_STDBT_VW

(SQL View)
 Index Back

Select Students By Block

Select Students By Block

SELECT DISTINCT B.OPRID , B.RUN_CNTL_ID , A.INSTITUTION , A.EMPLID FROM PS_STDNT_BLOCK_DTL A , PS_SSR_RUNGRPS_NLD B WHERE A.STDNT_ENRL_BLOCK = B.SSR_GRP_BAS_NLD AND A.INSTITUTION = B.INSTITUTION

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID