INSTRCLASSVWLNG

(SQL View)
 Index Back

Instructor Class View

The Instructor Class View contains by instructor ID and term all the sections that that instructor teaches for the specified term.

SELECT DISTINCT A.STRM ,A.EMPLID ,D.CLASS_NBR ,C.LANGUAGE_CD ,C.DESCR FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CRSE_CATLG_LNG C , PS_CLASS_TBL D WHERE A.CRSE_ID = D.CRSE_ID AND A.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND A.STRM = D.STRM AND A.SESSION_CODE = D.SESSION_CODE AND A.CLASS_SECTION = D.CLASS_SECTION AND D.INSTITUTION = B.INSTITUTION AND D.STRM = B.STRM AND D.ACAD_CAREER = B.ACAD_CAREER AND C.CRSE_ID = D.CRSE_ID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_CRSE_CATALOG C1 WHERE C1.CRSE_ID = C.CRSE_ID AND C1.EFFDT <= B.TERM_BEGIN_DT)

  • Related Language Record for INSTR_CLASS_VW SSR_FC_INSTRENR

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description