CRSE_EQUIV_VW

(SQL View)
 Index Back

Course Catalog Equivalent Vw

The Course Equivalent View selects data from the Course Equivalent Table with the primary and alternate keys reversed.

select a.equiv_crse_id, a.crse_id, a.effdt, a.descr, b.acad_group, b.subject, b.catalog_nbr, b.institution, b.campus from ps_crse_catalog a, PS_CRSE_OFFER b where a.crse_id = b.crse_id and a.effdt = b.effdt and b.crse_offer_nbr = (select max(c.crse_offer_nbr) from PS_CRSE_OFFER c where c.crse_id = b.crse_id and c.effdt = b.effdt)

  • Related Language Record: CRSEEQUIVVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group

    Default Value: CRSE_EQUIV_TBL.EQUIV_CRSE_ID

    Prompt Table: CRSE_EQUIV_TBL

    2 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    3 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    7 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    9 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL