LAM_STDNT_SCLNG

(SQL View)
Index Back

Student Gradebook Search Rec.

Use this search record to restrict operator access to the Student Access Grade Book.This view retrieves class sections where the student grades are being kept by the Grade Book application.

SELECT D.EMPLID , A.STRM , A.CLASS_NBR , E.OPRID , B.LANGUAGE_CD , B.DESCR FROM PS_CLASS_TBL A , PS_CRSE_CATLG_LNG B , PS_STDNT_ENRL D , PSOPRDEFN E WHERE A.STRM = D.STRM AND A.CLASS_NBR = D.CLASS_NBR AND A.CRSE_ID = B.CRSE_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_CRSE_CATALOG B1 WHERE B1.CRSE_ID = B.CRSE_ID AND B1.EFF_STATUS = 'A' AND B1.EFFDT <= %CurrentDateIn) AND D.EMPLID = E.EMPLID

  • Related Language Record for LAM_STDNT_SCTY
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_VAL_TBL

    3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    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