SSR_SRCHSUBJ_VW

(SQL View)
 Index Back

Adv Search Subjects

List of Subjects for Fluid SR Class Search Advanced Search

SELECT DISTINCT A.INSTITUTION , A.STRM , A.SUBJECT , B.DESCRFORMAL FROM PS_CLASS_TBL A , PS_SUBJECT_TBL B , PS_TERM_TBL C WHERE C.INSTITUTION = A.INSTITUTION AND C.ACAD_CAREER = A.ACAD_CAREER AND C.STRM = A.STRM AND B.SUBJECT = A.SUBJECT AND B.INSTITUTION = A.INSTITUTION AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_SUBJECT_TBL B2 WHERE B2.INSTITUTION = A.INSTITUTION AND B2.SUBJECT = A.SUBJECT AND B2.EFFDT <= C.TERM_BEGIN_DT AND B.EFF_STATUS = 'A')

  • Related Language Record: SSR_SRCHSUBJ_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 STRM Character(4) VARCHAR2(4) NOT NULL Term
    3 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    4 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field