COURSE_DESCR_VW

(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 A.COURSE , CASE WHEN A.course_descr_type ='GI' THEN 'GI' WHEN A.course_descr_type ='CA' THEN '' WHEN A.course_descr_type='TA' THEN '' WHEN A.course_descr_type='CC' THEN '' END course_descr_type ,A.EFFDT ,A.descrlong FROM PS_COURSE_DESCR A WHERE A.EFFDT= ( SELECT MAX(A_ED.EFFDT) FROM PS_COURSE_DESCR A_ED WHERE A.COURSE=A_ED.COURSE AND a.course_descr_type= a_ed.course_descr_type AND A_ED.EFFDT<=%CurrentDateIn )

  • Related Language Record: CRSE_DESCR_VW_L

  • 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCRLONG Long Character CLOB Long Description