CRSE_ID_VW2

(SQL View)
 Index Back

Course Catalog Search

The Course Catalog Search contains course data that is printed in the academic institution's course catalog. This information is extracted from the Course Catalog and the Course Catalog Offerings tables.

SELECT b.institution , b.crse_id , b.crse_offer_nbr , b.subject , b.catalog_nbr , b.campus , a.descr FROM ps_crse_catalog a , PS_CRSE_OFFER b WHERE a.crse_id = b.crse_id AND a.effdt = b.effdt

  • Related Language Record: CRSEIDVW2LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: COURSE_TBL

    3 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    4 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    5 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    6 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description