CRSE_CATALOG_LV

(SQL View)
 Index Back

Course Catalog Rel Lng View

This Course Catalog Table Rel Lang View is used to display all effective dated rows of a Course if at least one of its rows reference the current Equivalent Course ID in the Course Equivalencies Panel.

SELECT a.crse_id , a.effdt , a.language_cd , a.descr , a.descrlong FROM PS_CRSE_CATLG_LNG a

  • Related Language Record for CRSE_CATALOG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 DATE1 Date(10) DATE Effective Date
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRLONG Long Character CLOB Long Description