CRSE_CATNO_SRCH

(SQL View)
Index Back

Course Catalog Number Search

The Course Catalog Number Search selects catalog numbers given the Group and Subject

select b.institution ,b.subject ,b.catalog_nbr ,b.crse_id ,a.descr ,b.Acad_Group from ps_crse_catalog a, PS_CRSE_OFFER b where a.crse_id = b.crse_id and a.effdt = b.effdt

  • Related Language Record: CRSECATNOSRCHLN
  • # 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 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: OPR_DEF_TBL_CS.SUBJECT

    Prompt Table: SUBJECT_TBL

    3 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    4 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group