SSR_SRCHCRSE_VW

(SQL View)
 Index Back

Adv Search Subjects

List of Subjects for Fluid SR Browse Catalog Advanced Search

SELECT DISTINCT A.INSTITUTION , A.SUBJECT , B.DESCRFORMAL FROM PS_CRSE_OFFER A , PS_SUBJECT_TBL B , PS_CRSE_CATALOG C WHERE A.SUBJECT = B.SUBJECT AND A.INSTITUTION = B.INSTITUTION AND A.CRSE_ID = C.CRSE_ID AND A.COURSE_APPROVED = 'A' AND A.CATALOG_PRINT = 'Y' AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_CRSE_OFFER A2 WHERE A2.CRSE_ID = A.CRSE_ID AND A2.SUBJECT = A.SUBJECT AND A2.INSTITUTION = A.INSTITUTION AND A2.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' 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 <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND C.EFFDT = (SELECT MAX(C2.EFFDT) FROM PS_CRSE_CATALOG C2 WHERE C2.CRSE_ID = C.CRSE_ID AND C2.EFFDT <= %CurrentDateIn)

  • Related Language Record: SSR_SRCHCRSE_VL

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