View used by Self-Service Class Rosters and Grade Rosters.

SSFACCLASVWLNG

(SQL View)
 Index Back

SELECT DISTINCT C.EMPLID , A.STRM , F.INSTITUTION , E.OPRID ,A.LANGUAGE_CD , A.DESCR FROM PS_CLASS_TBL_LANG A , PS_CLASS_MTG_PAT B , PS_CLASS_INSTR C , PS_CRSE_CATALOG D , PSOPRDEFN E ,PS_CLASS_TBL F WHERE A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION AND A.CRSE_ID = D.CRSE_ID AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.STRM = B.STRM AND C.SESSION_CODE = B.SESSION_CODE AND C.CLASS_SECTION = B.CLASS_SECTION AND C.CLASS_MTG_NBR = B.CLASS_MTG_NBR AND A.CRSE_ID = F.CRSE_ID AND A.CRSE_OFFER_NBR = F.CRSE_OFFER_NBR AND A.STRM = F.STRM AND A.SESSION_CODE = F.SESSION_CODE AND A.CLASS_SECTION = F.CLASS_SECTION AND F.ENRL_TOT > 0 AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_CATALOG D1 WHERE D1.CRSE_ID = D.CRSE_ID AND D1.EFF_STATUS = 'A') AND C.EMPLID = E.EMPLID

  • Related Language Record for SS_FAC_CLAS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description