CRSE_CAT_R5_LNG

(SQL View)
 Index Back

Course Catalog Rqmnt View

This related language view is used to pull data for courses to be displayed in academic advisement. It has been adjusted to handle courses that no longer have an active catalog record available in the CRSE_CATALOG table.

SELECT A.CRSE_ID ,A.EFFDT ,L.LANGUAGE_CD ,L.DESCR FROM PS_CRSE_CATALOG A , PS_CRSE_CATLG_LNG L WHERE A.CRSE_ID = L.CRSE_ID AND A.EFFDT = L.EFFDT

  • Related Language Record for CRSE_CAT_R5_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description