CRSE_DESCR_VW_L

(SQL View)
 Index Back

Course Descriptions

Course Descriptions view to store max effective dated row as of system date for each course and Description type.

SELECT B.COURSE ,CASE WHEN B.course_descr_type ='GI' THEN 'GI' WHEN B.course_descr_type ='CA' THEN '' WHEN B.course_descr_type='TA' THEN '' WHEN B.course_descr_type='CC' THEN '' END course_descr_type ,B.language_cd ,B.EFFDT ,B.descrlong FROM PS_CRSE_DESCR_LANG B WHERE B.EFFDT= ( SELECT MAX(B_ED.EFFDT) FROM PS_COURSE_DESCR B_ED WHERE B.COURSE=B_ED.COURSE AND B.course_descr_type= B_ed.course_descr_type AND B_ED.EFFDT<=%CurrentDateIn)

  • Related Language Record for COURSE_DESCR_VW

  • Parent record: COURSE_DESCR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
    2 COURSE_DESCR_TYPE Character(2) VARCHAR2(2) NOT NULL Course Description Type
    CA=Course Agenda
    CC=Course Content
    GI=General Information
    TA=Target Audience
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 DESCRLONG Long Character CLOB Long Description