SSR_CSTRMSTD2VW

(SQL View)
Index Back

Class Search Term Values

View for valid class search terms for students and visitors trimming down for term with scheduled classes only

SELECT DISTINCT A.INSTITUTION , A.STRM , A.DESCR , A.DESCRSHORT , D.DESCRFORMAL , A.TERM_BEGIN_DT , A.TERM_END_DT FROM PS_TERM_TBL A , PS_TERM_VAL_TBL B , PS_INSTITUTION_TBL D WHERE A.STRM = B.STRM AND B.SSR_SSCLS_STD_BDT <= %CurrentDateIn AND B.SSR_SSCLS_STD_EDT >= %CurrentDateIn AND A.STRM = ( SELECT MIN(C.STRM) FROM PS_CLASS_TBL C WHERE C.INSTITUTION = A.INSTITUTION AND C.STRM = A.STRM) AND A.INSTITUTION = D.INSTITUTION

  • Related Language Record: SSR_CSTRMST2VWL
  • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
    6 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    7 TERM_END_DT Date(10) DATE Term Ending Date