SS_LAM_CLS_LNG1

(SQL View)
Index Back

Gradebook - Search Record

Gradebook, search record for Gradebook and Class Assignment components.

SELECT DISTINCT A.STRM , A.CLASS_NBR , C.OPRID , D.LANGUAGE_CD , D.DESCR FROM PS_CLASS_TBL A , PS_CLASS_INSTR B , PSOPRDEFN C , PS_CRSE_CATLG_LNG D WHERE A.CRSE_ID = D.CRSE_ID 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 D1.EFFDT <= %CurrentDateIn) AND 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 B.GRADE_RSTR_ACCESS IN ('A','G','P') AND B.EMPLID = C.EMPLID

  • Related Language Record for SS_LAM_CLAS_VW1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term
    2 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description