SSRFINEXAMLNG

(SQL View)
 Index Back

SS Final Exam View for Faculty

The Final Exam View contains by instructor ID and term all the exam information for the instructor teaches for the specified term.

SELECT DISTINCT A.STRM ,A.EMPLID ,E.CLASS_NBR ,C.LANGUAGE_CD ,F.LAST_NAME_SRCH ,F.FIRST_NAME_SRCH ,F.NAME ,C.DESCR FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CLASS_TBL_LANG C , PS_INSTITUTION_TBL D , PS_CLASS_TBL E , PS_HCR_PERSON_NM_I F , PS_CLASS_EXAM G WHERE A.CRSE_ID = C.CRSE_ID AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND A.STRM = C.STRM AND A.SESSION_CODE = C.SESSION_CODE AND A.CLASS_SECTION = C.CLASS_SECTION AND C.CRSE_ID = E.CRSE_ID AND C.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR AND C.STRM = E.STRM AND C.SESSION_CODE = E.SESSION_CODE AND C.CLASS_SECTION = E.CLASS_SECTION AND E.INSTITUTION = B.INSTITUTION AND C.STRM = B.STRM AND E.ACAD_CAREER = B.ACAD_CAREER AND D.INSTITUTION = E.INSTITUTION AND A.EMPLID = F.EMPLID AND A.CRSE_ID = G.CRSE_ID AND A.CRSE_OFFER_NBR = G.CRSE_OFFER_NBR AND A.STRM = G.STRM AND A.SESSION_CODE = G.SESSION_CODE AND A.CLASS_SECTION = G.CLASS_SECTION

  • Related Language Record for SSR_FIN_EXAM_VW

  • 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 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    6 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description